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.
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 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.
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.
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.
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.
