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:.
![For For](/uploads/1/2/5/3/125387433/269191723.jpg)
Select one row of cells from the spreadsheet range you want to see (e.g. From A4 to H4.
![Cells Cells](/uploads/1/2/5/3/125387433/905933276.jpg)
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. We welcome your comments and questions about this lesson.
Auto-size comment box to fit its content in a range of cells. If you just need to auto-size a range of cell comment boxes, you can use the following VBA code. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window. Click Insert > Module, and paste the following macro in the Module window. Excel Cell Width Adjustment. The simplest way to adjust cell width is to change the width of a column in Excel. You do this by going to the dividing line on either side of the column the cell is in. Scroll to the top of the column so you can see the letters that label the columns.
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.