Format brings you the ability to change the 'look and feel' of everything from a single cell being bold to the overall look of the worksheet with some of Excel's pre-packed 'auto formats'.  There are also some very clever areas which will allow you to change formats depending upon cell contents, values and formula.  In other words 'conditional formatting'.

Lastly, like Word, there is the ability to apply 'Styles'. This is a very important, oft overlooked area where Excel can come 'unstuck' with an error of 'too many different formats'. This can be avoided with the use of styles.

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 above 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