Yes indeed Excellers it is Pivot Table week at how to excel at excel.com For some they are something they cannot live without in Excel world, for others they make them run screaming away at the very...
Tag: Excel Tips
Search For And Highlight Invalid Data In Your Excel Worksheets
If you find that users are consistently entering incorrect data into worksheets then using Data Validation to prevent users entering invalid data and also displaying a message to prevent them is the...
Want to create your own style Excel work book to re use over and over again? It is easy to create your own default template in Excel to fit in with your corporate style or your own personal...
Here is another fab Excel tip. Excel is kind of clever as if you didn't already know. Excel will automatically fit your data to your cells by shrinking it. The data in the cell is fitted...
If you have a large worksheet with a lot of data then finding exactly what you are looking for can be problematic. The Excel Find And Replace dialog box is the most useful tool for this...
Quickie Excel Tips: Close A Workbook and Close Excel Using Shortcuts
We are all in a hurry, most of the time, so I thought I would share one of my all time favorite Excel keyboard shorcuts. How to Close An Excel Workbook If you want to close a selected...