Excel Tip of the Day
Quickly check your worksheet's set print area (Excel 2002)
Excel's Print Area feature makes it easy to print just a section of a larger worksheet. All you do is select the ranges you want to print and choose File | Print Area | Set Print Area from the menu bar. If you frequently use this feature, there have surely been times when you've forgotten to change the print area, resulting in incorrect printouts. Fortunately, there are easy ways to tell what ranges are set to print. One way is to select View | Page Break Preview. However, if you'd rather not change views, there's a way to tell from Excel's normal viewing mode. When you set a print area, Excel creates a named range. You can see what ranges will print by selecting Print_Area from the Name Box on the Formula bar.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.