Extend Spreadsheet Record For Free

Double-click the item that you want to expand or collapse. Right-click the item, click Expand/Collapse, and then do one of the following: To see the details for the current item, click Expand. To hide the details for the current item, click Collapse.

Select the row or rows that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click Row Height. In the Row height box, type the value that you want, and then click OK.

Resize a table by adding or removing rows and columns Click anywhere in the table, and the Table Tools option appears. Click Design > Resize Table. Select the entire range of cells you want your table to include, starting with the upper-leftmost cell.When you've selected the range you want for your table, press OK.

Collapse or expand the entire outline to a specific level To minimize or expand all the groups at a particular level, click the corresponding outline number at the top left corner of your worksheet. Level 1 displays the least amount of data while the highest number expands all the rows.

Use the ROW function to number rows In the first cell of the range that you want to number, type =ROW(A1). The ROW function returns the number of the row that you reference. For example, =ROW(A1) returns the number 1. Drag the fill handle. across the range that you want to fill.

Select the boundary of the column or row you want to move and drag it to the width or height you want. Select the rows or columns and then select Layout and choose your height and width. Select View > Ruler checkbox, select the cell you want, and then drag the markers on the ruler.

Resize rows Select a row or a range of rows. On the Home tab, select Format > Row Width (or Row Height). Type the row width and select OK.