This menu provides all to do with editing cells and worksheets, that is once you have an entry, sheet, etc. It can be edited here.

As a rule in Office, (and most windows), programs, any menu options with three ellipses (...) after the menu option, will be followed by another dialog, any options with a ►, will be followed by a sub-menu if you hover over the ►.

The menu options on the image to the left are live hyperlinks and will help you navigate to the relevant page or you can use the links on the far left.

In the linked pages you will find detailed explanations of the option, together with a code snippet on how the menu option may be implemented in VBA (Visual Basic for Applications), any lines in these snippets starting with a single apostrophe(') are comment lines to assist you and explain what is being done and if pasted into a module will appear green with no notice being taken of them when the code is run. (To implement and explain VBA you would do best to read the pages on this subject first).

Top