Sometimes you want to print just a part of your worksheet, not all of it.
The slow way is to highlight the area you want to print, then use the Set Print Area option.
The quick way is to highlight the area you want to print, then:
File - Print at bottom left, change from Active Sheet to Selection Print Preview - Print.
More Excel tips from David Carter
2min Tip 1: Sort data with the =RIGHT function
2 min Tip 2: Use & to combine two columns into one
2min Tip 3: Create a run-time filter when importing into Excel
ExcelZone's Five Minute Pivot Table Tips - Index
Subscribe to the ExcelZone newswire
To ensure you don't miss any of David Carter's handy Excel tips,...