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...
Category: Excel Tips& Tricks
Have you found when you try to reference a cell in a Pivot Table that Excel will sometimes automatically creates a cell reference with the prefix GETPIVOTDATA? ......even when you just want a simple...
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...
If you want to add chart titles that are live or active, it is really easy to do in Excel with just a few clicks of the mouse. Create your chart as normal in Excel Select the chart title you...