"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Excel Users Become Local Spreadsheet Experts"

How To Make Your Spreadsheet Fit Your Screen

You put a lot of preparation into designing your spreadsheets exactly the way you want them. But many times you'll find that your spreadsheet is a little wider than will fit your screen. Maybe you have many spreadsheets like this now.

The problem here is that not only do you have to scroll up and down to navigate your spreadsheet but you also have to scroll left and right.

If the data on your sheet is slightly wider than will display on your screen I will show you how you can easily make it fit.

Here’s how.

  1. Select a range of cells (can be only one row high) from the left-most cell to the right-most cell.
  2. From the View menu select Zoom, click Fit Selection, and then click OK.

Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright © 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.