If you have Classic Menu for Office, there are two methods to find out the Fit to One Page command in. Classic Menu for Office will bring the Excel 2003/XP(2002)/2000 user interface of drop down menus and toolbar into the ribbon of Excel 2007, 2010, 2013, 2016, 2019 and 365. Under Cells, click Distribute Rows or Distribute Columns. Find out Fit to One Page at ease if you have Classic Menu for Office. Rest the pointer on the column boundary until appears or the row boundary until appears, and then double-click it. If you have text in a table cell, the column must be as wide as or wider than the text. Rest the pointer on the column boundary that you want to move until appears, and then drag the boundary until the column is as wide as you want. If you have text in a table cell, the row must be the same height or taller than the text. Rest the pointer on the row boundary that you want to move until appears, and then drag the boundary until the row is the height that you want. Rest the pointer on any corner of the table until appears, and then drag the table boundary until the table is the size that you want. You can also resize one or more rows, columns, or individual cells in a table. You can resize a whole table to improve readability or to improve the visual effect of your document. Under Default cell spacing, select the Allow spacing between cells check box, and then enter the measurement that you want.

Under Cell Size, click Distribute Rows or Distribute Columns.Ĭhange the space between cells in a tableĬlick the table, and then click the Table Layout tab.Ĭlick the Table tab, and then click Options. Select the columns or rows that you want to make the same size, and then click the Table Layout tab. Make multiple rows or columns the same size Tip: To display column width measurements on the horizontal ruler, click a cell, and then hold down OPTION as you drag the boundary.

Find shrink to fit in word