Putting Excel into Lock Down
There are a few lock downs in place around Australia at the moment, so let’s look at putting Excel into lock down.
(more…)Excel Border Icons
I typically turn gridlines off on my sheets and then use borders for the lines. I have added icons to my Quick Access Toolbar to speed up the process. (more…)
Identifying Locked Cells in Excel
How do you know if a cell is locked in Excel? There is an easy way to find out. And it also makes it easier to lock or unlock the cell. (more…)
Excel Filter Trick
Do you use the “Filter by Selected Cell’s Value” option? If you do then you will be pleased to know there is a Quick Access Toolbar icon that applies it in one click. (more…)
Excel Full Screen
There are times in Excel when you want to see as much of the Excel grid as possible. You may be reviewing or presenting a dashboard or looking at a large PivotTable. Excel has a Full Screen mode that shows just the grid and the sheet tabs.
Running a Macro From the Quick Access Toolbar
The Quick Access Toolbar (QAT) can really speed up your work in Excel. You can even attach macros to the QAT. (more…)
Printing in Excel
It is easy to print things from Word. It is not so easy in Excel. Excel has this huge grid and if you don’t tell Excel otherwise, it will print everything on the sheet, whether you want it to or not. (more…)
Paste Only Subtotals in Excel
Excel’s SUBTOTAL function is my function of choice for all my subtotaling requirements. See my earlier post here on its features.
Excel’s automated subtotal feature can do most of the work for you and leave you with a nicely summarised list. (more…)
How to make the most of Excel Macros
I get many questions from Australian CPA’s and sometimes the solution involves a macro. Not everyone knows how to install and run a macro. This post will take you through the basics. (more…)
DO NOT PASS GO TO in Excel
Excel’s Go To feature provides a quick way to select certain types of cells. For example, if you wanted to apply the same fill colour to all formula cells on a sheet, you can do that in five easy steps using Go To. (more…)
How to see the old Print Preview in Excel 2010
Excel 2010 introduced the File tab with its new Print Preview screen. Many users don’t like this new layout and want the good old fashioned Print Preview screen they are used to. As with many features in Excel, it’s still there, you just need to find it. (more…)
Customizing Excel 2007 and 2010 [VIDEO]
Excel 2007 introduced the new interface called the Ribbon. It’s a cross between a toolbar and a menu. It also has a Quick Access Toolbar (QAT) that many people don’t seem to be using. (more…)