Excel

How to working with rows and columns in excel 2016

0

Working with Rows and Columns

Rows and columns are an excellent worksheet. Each worksheet has exactly 1,048,76 rows and 16,684 columns and these values can not be changed. You can insert/delete rows and columns, but here rows and columns are automatically deleted from the last by the number of rows and columns inserted.

Inserting Rows and Columns

  • It is very simple to insert rows in excel. Right-click the row number before which you want to insert the row and select the insert option from the popup menu that appears. Accordingly, by right-clicking on the selected columns and clicking on the insert option, you can insert columns. Always insert columns just before your selected column(s).

Alternatively,

you can also insert row(s) and columns(s) from the Home Tab ribbon click on the insert button and clicking on the insert sheet rows or columns option.

How to Deleting Rows or Columns

Row(s) or columns(s) can be deleted by right-clicking on the selected Row(s) or columns(s) and clicking on the delete option.

  • Right click on the selected rows and click the delete option from the drop-down list, selected rows and columns will be deleted. Naturally, two rows are selected here, two will be deleted. Accordingly, you can delete columns right-click on the selected columns and click the delete option from the drop-down list.

Alternatively,

You can also delete selected row(s) or columns(s) clicking on delete sheet Rows or Columns from the insert button under the Home ribbon’s cell group.

how to Hide/Unhide rows and columns.

To get the option of hiding and unhiding rows and columns, go to the format button of Home Tab.

  1. Click Hide Rows to hide the selected rows and click Hide Columns to hide columns. The contents of the hidden rows/columns will not be To retrieve the hidden rows/columns,
  2. select the previous and next rows or columns of the hidden rows/columns or select the entire worksheet, and then select any of these options accordingly. All the hidden rows/columns will return immediately.

How to Adjusting Rows hight and Columns width

Row Height ⇒ This option is used to change the row height of the selected row or rows to the defined value. The following dialog box will appear when you click this option, type the value and click the OK button.

AutoFit Row Height ⇒This feature is used to changing the height of the selected cell(s) to fit the contents accordingly. this can be done by Best Fit Option.

Column Width ⇒ This option changed the width of the columns selected. The following dialog box will appear, define the value and then click the OK button.

Autofit columns width ⇒ This option changed the columns width immediately to the appropriate size to fit the contents with it.

Default Width ⇒ It shows the value of the standard columns width as 8.43

How to select a cell,  range, or text in a cell 
To SelectDo this 
A single cellClick the cell, or press the arrow keys to move to the cell.
A range of cellClick the first cell in the range, then drag to the last cell, or hold down SHIFT while pressing the arrow keys to extend the selection. You can also select the first cell in the range, then press F8 to extend the selection using the arrow keys. Press F8 again to stop extending the selection.
All Cells on a worksheetClick on the Select All button. You can also press CTRL+A to select the entire worksheet. Note that if the worksheet contains data, CTRL+A Select the current region. Pressing CTRL+A selects the entire worksheet for the second time.
Non-adjacent cells or cell rangeSelect the first cell or range of cells, then hold down the URL while selecting the other cells or ranges. You can also select the first cell or range of cells, 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: You can not cancel the selection of a cell or range of cells in a nonadjacent selection without canceling the entire selection.
An entire row or columnClick the row or column heading.1 Row heading2 Column heading by selecting You can also select the first cell in a row and then press the 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 or columns to the last used cell. Pressing the CTRL+SHIFT+ARROW key selects the entire row or column a second time.
The first or last cell on a worksheet or in a Microsoft Office Excel table or DatabasePress CTRL+HOME to select the first cell on the worksheet or in an Excel list.
Press CTRL+END to select the last cell on the worksheet or in an Excel list that
contains data or formatting.
Cell to the last used cell on the worksheet(lower right corner)Select the first cell and then press CTRL+SHIFT+END to extend the selection od cell to the last cell in the worksheet (bottom – right corner).
Cell to the beginning of the worksheetSelect the first cell, and then press CTRL+SHIFT+HOME to extend the selection of a cell to the beginning of the worksheet
More or fewer cells than the active selectionHold down SHIFT while you click on the last cell you want to include in the new selection. The rectangular range between the active cell and the cell you click becomes the new selection.

How to protect PowerPoint Presentation with password encryption

Previous article

How to change the background color of text in excel organised worksheet

Next article

You may also like

Comments

Leave a reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

More in Excel