When you launch Microsoft Excel, an exactly-formatted spreadsheet grid is presented for you to start using your worksheet. Each cell in a default Microsoft Excel worksheet is exactly the same size as all of the other cells within the spreadsheet, containing the rows and columns on the screen. The spreadsheet isn’t protected, though. You can alter cell width and height to put prominence on certain data, change font sizes to fit or to add white space to your worksheet. Microsoft Excel doesn’t permit single cell changes; size works on a row or column buddy system. “Tag: resize the height & width of cells in Excel 2016″
So here is how to resize the height & width of cells in Excel 2016
- Start Microsoft Excel. To alter cell size on a current spreadsheet, click the “File” tab. Click “Open.” Steer to the worksheet to alter and double-click the file name.
- Click on the cell you are likely to alter. Note the highlighted column letter at the top of the screen and the row number on the left side of the screen.
- Click the small line on the right side of the column letter. For example, if the cell you want to alter is in column E, click the small line between the E and F columns.
- Drag the line to the right. This increases the width of the cell and all other cells in that column. Drag the line to the left to decrease the width of the cell.
- Click the small line between the row numbers the cell is in. For example, if the cell you want to change is in row 5, click the line between rows 5 and 6.
- Drag the line below the worksheet. This increases the height of the cell and all other cells in that row. Drag the lineup, closer to row 4, to reduce the height of the cell.
Tag: resize the height & width of cells in Excel 2016″