Excel Tip- How To Find Unsaved Versions Of Your Excel Workbooks
I bet you have closed the odd Excel workbook or two without saving the changes when really should have. I know I have!. Not so much of a worry with Excel 2010 onwards though as your workbook will...
A lot of businesses still use earlier versions of Excel than 2007. If you find that you need to issue of share workbooks with such earlier versions then it is a good idea to run the Compatibility...
If you ever need to move or copy or move permantly a worksheet form one workbook to another then here is the best way to do it in Excel - using the Move or Copy Dialog Box. Firstly open the...
I want to share with you a tip that I use most days if my rows of data are more than a few hundred lines (which is most days!!). It's the Go To feature where you can specify an exact cell location...
Most Excel workbook I find that I will need to print only one sheet or a part of a worksheet, which is the default setting of Excel. An odd time though I need the full workbook. Here's where this...
Display The Details Behind Your Pivot Table Data With One Click
Ever need to drill down into your Pivot Table to look at the details behind your summary calculations? Simple stuff with the double click of a mouse and Excel will display all of the details behind...