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...
Recent Posts
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...
Restrict The Number Of Characters A User Can Enter In An Excel Cell
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....
Quickly Freezing Rows And Columns With One Click Of A Button
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...
Recently a colleague was having an issue with their Pivot Table, they claimed some if their data was 'missing', a subscriber to my newsletter also had this issue so I thought I would cover it in...