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...
Tag: Excel Tips
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...
Do you need to clear just the numbers from your Excel worksheet?. I know I do this regularly if I have a worksheet I want to re -use for example a generic input form and I want to keep all of the...
Excel is really cool when it comes to automatically filling in cells in columns or rows with weekdays, months etc etc...so when you type in the first couple of items in the list, then drag the fill...
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...