Excel Tip of the Day
Scaling worksheets when you don't know the final size (Excel 97/2000/2001/2002)
Excel allows you to scale worksheets to fit a specific number of printed pages across and down. To specify the printout size, select File | Page Setup from the menu bar and select the Fit To option button on the Page Setup dialog box's Page tab. While this is handy, sometimes you won't know the exact dimensions that should be used for a printout. For example, let's say that you have a worksheet that contains several thousand rows of data. Because the worksheet also contains more columns than can print across a page, you wind up with a printout that's two pages across and dozens of pages long. You know that you want the printout to only be one page wide, but it's unlikely you'll know how many pages tall the printout needs to be in order to show all your data. In such situations, all you need to do is delete any existing value in the Tall spin box. When the Tall control is blank, Excel will figure out the appropriate scaling percentage on its own.
(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.