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:

  1. Select
    the range of cells you want to fill the window.
  2. 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.