It will eventually shrink the sheet to let it fit on one page which will be easier to print later.Ģ. Similarly, you can reduce the row height by placing the cursor of your mouse at the edge of the row number that you want to reduce in size and simply click and drag.īy doing so, you can save a lot of space in your Excel sheet.Then click and drag the cursor to reduce the size of the column. You can place the cursor of your mouse at the edge of the column that you want to reduce the size.You will be able to see the scales at the top and the left side of the spreadsheet. This will change how the sheet is being displayed. Go to the View tab, then select Page Layout.Steps to know the column width from the Page Layout option are given below. ![]() To know that easily, you can utilize the Page Layout option from the View tab in Excel. You can simply reduce the column width or row height to shrink data on the worksheet so that the sheet could be printed on one page.īut how do you know the amount of space that you can reduce so that the data of the cells won’t be affected? How can you know whether you have shrunk enough or not? ![]() Print Excel Sheet on One Page by Adjusting the Column Width or Row HeightĮxcel has an auto-generated column width or row height which sometimes are not needed. In the following section, we will discuss various ways how you can optimize your Excel spreadsheet and fit it into one page while printing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |