Managing Worksheets

Rows and Columns

Select a row, range of adjacent rows, and range of non-adjacent rows.

To select a row, simply click on the row header for that row. It should just be a single click and not a double click. This will select the entire row.

To select a range of adjacent rows, click on the row header for the first row in that range and without releasing the mouse button, drag the cursor to the last row header in the range. This will select the entire range of adjacent rows.

img0
img1
img2
img3
img4
img5
img6
img7
img8
img9
img10
img11
img12
img13
img14
img15
img16
img17
img18
img19
img20
img21
img22
img23
img24
img25
img26
img27
img28
img29
img30
img31
img32
img33
img34
img35
img36
img37
img38
img39
img40
img41
img42


To select a range of non-adjacent rows, click on one of the row headers from any of the rows and then press the ‘ctrl’ key on the keyboard. Without releasing the ‘ctrl’ key, select each of the non-adjacent row headers individually. But the ‘ctrl’ key should not be released throughout. This is how we can select a range of non-adjacent rows.

Select Rows

Select a column, range of adjacent columns, and range of non-adjacent columns.

To select a column, simply click on the column header for that column. It should just be a single click and not a double click. This will select the entire column.

To select a range of adjacent columns, click on the column header for the first column in that range and without releasing the mouse button, drag the cursor to the last column header in the range. This will select the entire range of adjacent columns.

To select a range of non-adjacent columns, click on one of the column headers from any of the columns and then press the ‘ctrl’ key on the keyboard. Without releasing the ‘ctrl’ key, select each of the non-adjacent column headers individually. But the ‘ctrl’ key should not be released throughout. This is how we can select a range of non-adjacent columns.

Select Columns

Insert, delete rows and columns.

To insert a row or a column, right-click on the column header to the left of which you want to insert a new column or right-click on the row header above which you want to insert a new row. From the resulting menu, in the case of column, click on ‘Insert Columns Left’, and in the case of rows, click on ‘Insert Rows Above’. This will insert a new row or a new column to the worksheet.

To delete a row or a column, simply right-click on the row or column header which needs to be deleted, or select multiple columns or rows and then right click on any one of the headers from the entire range. From the resulting menu, click on ‘Delete Selected Columns’ or ‘Delete Selected Rows’. The selected rows or columns will get deleted.

Modify column widths, row heights to a specified value, to optimal width or height.

To modify column widths or row heights, right click on the column header and then click on ‘Column Width’ from the resulting menu or right click on the row header and then on ‘Row Height’ from the resulting menu respectively. This will open the ‘Column Width’ or ‘Row Height’ dialog box where the width or height of the column or the row can be set. After giving the appropriate value, click on ‘OK’. This will change the height or width of the row or column accordingly.

Column Width

To modify the column width or row height to optimal values, right click on the column or row header and from the resulting menu, click on ‘Optimal Column Width’ or ‘Optimal Row Height’. This will open the ‘Optimal Column Width’ or ‘Optimal Row Height’ dialogs. Click on ‘OK’ and the width or the height will get modified to the default values.

Row Height

Freeze, unfreeze row and/or column titles.

Freezing locks a number of rows at the top of a spreadsheet or a number of columns on the left of a spreadsheet or both rows and columns. Then, when moving around within a sheet, the cells in frozen rows and columns always remain in view.

To freeze a row or a column, click on the row header below the rows you want the freeze or click on the column header to the right of the columns where you want the freeze. After this, click on ‘Window’ from the main menu bar. From the resulting drop-down, click on ‘Freeze’. This will freeze the rows and columns as per your selections.

To unfreeze these rows and columns, click on ‘Freeze’ again from the ‘Window’ drop down menu from the main menu bar.

reeze Rows