Using a document theme is a great way to personalise and standardise your own personal or company image for consistency and a professional look.  It is really not complicated to do, and can save you...

Sometimes you may want to limit the access of a user to a particular range of cells in a worksheet, for example you may have a worksheet set up that only a certain range can be modified or activated...

If you have used Microsoft Excel then you will know how powerful it is for our business and also personal use. Sometimes you just need your spreadsheet to also look good. Whether you enter data...

Sometimes it's necessary to limit the number of character entries into cells, for example account codes or user names.  You may want to limit an account code to 6 characters.  This cuts down on...

Most of the time in Excel an AutoFilter would enable you filter lists in the ways you need to,  But, in some cases you may need or want to exert more control of over the way filtering operates....

I just HAD to share this little gem with you.  There is a button in Excel for freezing rows and columns really easily.  It's a small icon right at the very top of the scroll bar, and a similar one...