I was trying to move the “Fill Cells” from the Sheet drop down menu to the Insert drop down menu. Once I used the Customize Menu function to move the “Fill Cells” over to the Available Commands selection box it does not show up there. I cant even find the “Fill Cells” to put it back on the Sheets menu. Is there some other way to get this menu function back?
I suppose in the Menu tab of Customise you select Sheet, click the Insert button and Insert Sub-menu. Name it Fill Cells and then drag across the commands shown under Assigned Commands in image below.
That worked exactly as I needed and you taught me at the same time how to make the menus of Calc even more customizable. I am very keyboard shortcut proficient with Excel pre-ribbon and I am in the process of configuring LibreOffice Calc menus to be exactly like Excel 2003. Thank you so much.