Working with Rows and Columns
Rows and columns make up an Excel Worksheet. Every worksheet has 1,048,576 rows and 16,384 columns, and these values can’t be changed. You can insert/delete Row(s) and Column(s) but here rows and columns will be deleted automatically from the last according to the number of rows and columns inserted.
Alternatively,
You can also insert Row(s) or columns from the home Tab ribbon by clicking on the Insert Button and clicking on the insert sheet rows or columns option
Deleting Rows or Columns
Row(s) or Column(s) can be deleted by right-clicking on the selected Row(s) or Column(s) and clicking on the Delete option.
Alternatively,
You can also delete selected row(s) or column(s) by clicking on Delete sheet Rows or Columns from the Insert button under the home tab ribbons Cells group
Hide/Unhide rows or columns
To get the options of hiding and unhiding rows and columns, go to the format button of the Home tab
Adjusting Row Height
How to select a cell, a range, or text in a cell
| To Select | Do This |
| A single cell | Click on the cell, or press the arrow keys to move to the cell. |
| A range of cells | From the range click the first cell and drag to the last cell or you can press SHIFT and hold the arrow keys to extend the selections. There is a second method to do this, select the first cell in the range and press F8 it will open the selection by using the arrow keys. Press F8 again to stop extending the selection. |
| All cells on a worksheet | Click the Select All button. To select the entire worksheet, you can also press Ctrl + A. NOTE If the worksheet contains data, CTRL + A selects the current region. Pressing CTRL+A a second time selects the entire worksheet. |
| Nonadjacent cells or cell ranges. | Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges. You can select the first cell or range of cells, and then press SHIFT+F8 to add another nonadjacent cell or range to the selection. To stop adding cells or ranges to the selection, press SHIFT+F8 again. NOTE We cannot cancel the selection of a cell and range of cells in a nonadjacent selection without canceling the entire selection. |
| An entire row or column | Click the row or column heading. 1. Row heading. 2. Column Heading. Select multiple or single cells in a column or row by selecting the first cell. Then press CTRL+SHIFT+ARROW Key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns). NOTE If the row or column contains data, the CTRL+SHIFT+ARROW key selects the row or column to the last used cell. Pressing the CTRL+SHIFT+ARROW key a second time selects the entire row and column. |
| The first or last cell on a worksheet or in a Microsoft Office Excel Table | The first or last cell on a worksheet or in a Microsoft Office Excel Table |
| The last used cell on the worksheet (lower-right corner) | Select the first cell, then press CTRL+SHIFT+END for extending the selection to the last used cell on the worksheet (lower-right corner) |
| Cells to the beginning of the worksheet | Select the first cell, and then press CTRL+SHIFT+HOME to extend the selection of cells to the beginning of the worksheet |
| More or few cells than the active selection | Press SHIFT while you click the last cell that you want to include in the new selection. The rectangular range between the active cell and the cell that you click becomes the unique selection. |
