Scale your Excel spreadsheet to fit your screen
If you work with large Excel spreadsheets, you'll probably know the hassle of scrolling left and right, up and down as you try to work with all that data. You can use the Zoom feature to make the spreadsheet smaller and fit more onto the screen, but that doesn't always give you the result you want. Often, it will make your spreadsheet too small or not small enough.
To fit your spreadsheet exactly to the screen - let's say you want to reduce the width of it so you can see all the columns fitting snugly into the width of your screen, with no screen space wasted, simply follow these steps:
- Select one row of cells from the spreadsheet range you want to see (e.g. from A4 to H4.
- Choose View, Zoom, then select Fit Selection
- Click OK
This will make the cells you selected fit exactly into the width of your screen. It doesn't matter that you only selected cells from one row (or column if doing it the other way) - Excel will scale according to the longest dimension (in this example the dimension was width rather than height).
Note that this tip also works to make a spreadsheet larger to fit the screen as well.
Our Comment Policy.
We welcome your comments and questions about this lesson. We don't welcome spam. Our readers get a lot of value out of the comments and answers on our lessons and spam hurts that experience. Our spam filter is pretty good at stopping bots from posting spam, and our admins are quick to delete spam that does get through. We know that bots don't read messages like this, but there are people out there who manually post spam. I repeat - we delete all spam, and if we see repeated posts from a given IP address, we'll block the IP address. So don't waste your time, or ours. One other point to note - if you post a link in your comment, it will automatically be deleted.
Comments on this lesson
EDIT: Sorry, read the spam
EDIT: Sorry, read the spam policy after posting. If the link is considered spam, just delete it.
Fit to screen for the whole workbook (different screen res)
Hello,
I have a technical question… I have made a workbook with 10 spreadsheets, each with different column widths and common toolbar (horizontal group of text objects on the top of each spreadsheet with hyperlinks and macros). When I use Activewindow.Zoom = True for the first spreadsheet(“homepage") and apply it to the others (Activewindow.Zoom = iZoom), it works great for my screen resolution but as soon as I change screen resolution or zoom level on certain spreadsheets, the toolbar "moves" - it is not on the same place (object/toolbar is locked – “don’t move or resize with cell").
Since I plan to offer my workbook to customers I want it to look as close as real toolbar.
Do you know a quick fix? Have I missed something?
Thank you for a quick reply, greetings from Slovenia,
Jaka
how to enlarge the informational headings on top
Because of my living situation my screen is further away then I like it to be. I can enlarge the cells and all but I can't enlarge the information on the top like the file home input page layout all that stuff
Thats a handy trick, thank you. Most people would think that the zoom function is either self explanatory or not worth mentioning, but it can really help the workflow. I just have to add one thing: After working with zoom, you can reset the zoom with a button, so you dont have to do it manually. http://www.excel-aid.com/using-the-excel-zoom-function.html is where i got that info, just wanted to share the link cause i think its way easier to look at a screenshot, that shows where the button is located, instead of describing it.