Video Tutorial -How To Delete Obsolete Items From Pivot Table
If you reuse your pivot tables over and over again but your source data changes then you may find you have old items remaining in the TabLe Field Drop downs. In Excel 2007 it's really easy to deal...
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...
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...