Excel Dynamic Arrays and Print Ranges
Print ranges can accept dynamic arrays. This means you can set up print ranges that automatically expand or contract based on dynamic array spill ranges.
(more…)Updating the Excel Header with a Cell Value
A common request over the years for Microsoft has been to have the ability to link the print header or footer to a cell. As at the time of writing this functionality doesn’t exist, but we can add a one-line macro to fix that.
(more…)Excel VBA to Clear Manual Page Breaks
When clearing page breaks in Excel VBA you need to be careful. There is one command that will clear page breaks but it will also affect other print settings.
(more…)Excel VBA BeforePrint Issue
Excel has a BeforePrint event which enables you run VBA code before a document is printed. This event can also be triggered by Print Preview. But not all Print Previews are the same. (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…)
Excel’s Print Options
Printing in Excel can be a tricky exercise. Both Word and PowerPoint basically don’t let you print outside the page, but each Excel sheet has a huge grid with over 17 billion individual cells. Printing large spreadsheets can be a challenge. (more…)
Right Clicking in Excel
Right clicking in Excel offers many productivity benefits. If you don’t already right click try it, it’s fun to see all the options that are just a click away. (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…)