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...
Category: Quickie Tips
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...
If you need to fit all of your Excel columns on one printed page really quickly, it's really easy to do with a couple of clicks using the Scaling Setting. File tab Print In Settings Section...
Here is a really quick Excel tip for entering data into multiple cells super fast!!..just by using the CTRL+Enter. Select the cells you want to enter the value or formula...
I am sure you all know how to use the AutoSum, just click the Excel's AutoSum button on the Excel Ribbon that looks like this from a cell next...