You're in the middle of giving a presentation when you realize that you should have repositioned and enlarged a portion of your Microsoft Excel spreadsheet so that your audience (especially those sitting in the back of the room) could get a better view of a chart or figures. But don't fret—you can improve your presentation on the spot by using the Selection option under Excel 2002 and 2003's Zoom feature.
You could try enlarging the spreadsheet using the Zoom feature, and then scrolling so that only the portion of the spreadsheet dealing with your presentation fills the worksheet window. But rather than having your audience watch you fumble with all those view adjustments as you try to guess how much to zoom in or zoom out, let Zoom's Selection option automatically adjust the view for you. Simply follow these steps:
- Select the range of cells you want to fill the window.
- Click the drop-down arrow on the Zoom tool in the standard toolbar and click Selection. Excel will instantly resize and reposition the selection to fill the worksheet window.
To return to normal view, select 100% from the drop-down Zoom list.
Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.