headermask image

Business Tools Blog

Fast Excel Trick - Zoom or Fit Selection to Your Screen

When you are working in Microsoft Excel, it’s always best to have your numbers be as large as possible.  Because playing around with the Zoom feature is time consuming, you probably skip that step and spend all day squinting at your screen.

The Excel programmers were thinking about your eye health when they put in an auto zoom feature.  It allows you to highlight the working area of your spreadsheet, then auto-zoom (fit selection) to exactly the right percentage.

Just highlight the cells you will be working with in on your spreadsheet, then hold down the [ALT] button and click V, Z, F [Enter].

Or you can use the toolbar.  First highlight the cells you will be working in on your spreadsheet, the click View > Zoom > Fit Selection > Enter

Photobucket

Photobucket

If you liked my post, feel free to subscribe to my rss feeds

Money Making Options

Post meta

This entry was written by Sandi Mays and posted on April 3, 2009 at 12:57 am and filed under Excel. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment(Latest is displayed first) or leave a trackback: Trackback URL.

Share with others

Post Fast Excel Trick - Zoom or Fit Selection to Your Screen to digg. Post Fast Excel Trick - Zoom or Fit Selection to Your Screen to Reddit add to stumbleupon Google Bookmark myweb bookmark on del.cio.us newsvine Tailrank magnolia Furl co.mments shadows simpy blinklist

2 Comments so far (Add 1 more)

  1. Thanks Jon!

    1. Sandi Mays on April 3rd, 2009 at 8:28 am

  2. Just be careful, because some things don’t work exactly as expected if the zoom is other than 100. For example, if you’re using Excel 2003 or earlier, try this. Create an embedded chart on a worksheet. Set the zoom to 75. Copy the chart, select a cell, and paste it. The pasted chart is about 75% of the original’s size. Some programmer corrected for the zoom twice.

    If you shift-click the chart to select the chart object (so it’s highlighted with white handles instead of black), it will paste the same size as the original regardless of zoom.

    2. Jon Peltier on April 3rd, 2009 at 4:47 am

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*