Our Recommendation for You Search your Query, You can find easily. for example search by book name or course name or any other which is related to your education

Followers

Select cells, rows, columns or range of data in Excel 2013

How to select a cell or group of cells (cells block) or area in Excel 2013

One of the main activities in working with Excel 2013 is a selection or highlight the cell, a group of adjacent cells, groups of nonadjacent cells, large areas of cells and the like. Select the mark or can a mouse or key combination on the keyboard or keyboard.

In the picture below you can see a few ways of selecting or marking of cells and I'll try to describe in words.

How to select a cell in Excel

Selecting a single cell in Excel is done by positioning the cursor on the cell and click the left mouse button on the desired cell. The address of that cell, you can see the 'Name Box' field. In the picture you see and selected cell B2. This cell is marked with a green frame.


To select a block of adjacent cells in Excel 

Selecting or select multiple adjacent cells in Excel (or block the cell) can be done in two ways.
  1. The first way is using a drag-and-drop, which means that you need to click on the first cell to keep the left mouse button and move the selection cursor to the last cell blocks or areas that we want to select. The figure below under red notice selected block adjacent cells D6:F9 (area adjacent cells).
  2. Another way is by using the mouse and keyboard combinations. When selected, the first cell in the selected cell block, press Shift key on your keyboard and keep it. Now continually push the arrow in the direction in which we want to expand the selection of the cell block area. We can also use the PageUp key and PageDown key to a larger area.

Notice how it looks first selected cell and also in 'NameBox' field note its relative address.

How to select cells or select multiple nonadjacent cells in Excel 

If you want to select multiple nonadjacent cells can then use the mouse and the Ctrl key on your keyboard. Selects the first cell, and then press the shortcut CTRL key on your keyboard and hold a further mouse clicks by other desired cells and as a result we have a more selective nonadjacent cells as shown below in the blue box. Notice how it looks last selected cell and also in NameBox field note its relative address. Also you see in the picture below were selected following nonadjacent cell or nonadjacent block of cells: K6:K9, J11, I13, K13:K14, I15, J16.

Selection and highlight of cells, ranges of cells, contiguous and nonadjacent cells in Excel

How to highlight or select all the cells at once in Excel

If you want you can select all the cells in one step or one click in Excel in two ways.

The first way is to click the mouse on the small triangle in the merge field rows and columns you see in the picture below that is automatically set as the active cell and different color selections to cell A1.

Another way is to click the mouse on the worksheet so that it is selected at least one cell, and then press the hot key combination CTRL+A. Notice in the picture below that was active cell C5 before selecting all of the cells in the Excel worksheet.

Marking or selecting of all cells in Excel


How to select or mark the rows in Excel (adjacent and nonadjacent rows)

When it comes to highlight or selecting of rows or columns in Excel, then the same can in many ways make a selection of rows and columns. For information here and selecting adjacent rows or columns can be made by utilizing the drop-and-down so that you click on the first line and move the cursor up or down (left or right)

I personally prefer selecting rows by clicking the row number and then pressing the Shift key or Ctrl key and selected other lines as needed. With the help of a shortcut or hot key SHIFT on the keyboard arrow keys UP or DOWN arrow keys on the keyboard selects other adjacent rows. If I want to select nonadjacent rows then all the desired rows selected by using the mouse and CTRL keys on my keyboard that I hold while I do my selecting or highlight. Notice in the picture below that the last row is selected (ok that was selected last is the active cell). There is a way that you can select the first row of keys on the keyboard and that the SHIFT+SPACE onwards holding the Shift key, you make the following selecting using the arrows.

Selection or highlight of rows in Excel

How to select or mark the columns in Excel (adjacent and nonadjacent columns)

Also, I prefer the selecting of columns by clicking on the column letter and then pressing Shift or Ctrl i selects other columns as needed. With the help of shortcuts or shortcut keys SHIFT on the keyboard and arrow keys LEFT or RIGHT arrow keys on the keyboard I selects other adjacent columns. If I want to select nonadjacent columns, then all the desired columns I selected by using the mouse and shortcut keys CTRL key on the keyboard that I hold while I do my selecting or highlight columns. Notice in the picture below that the last column is selected (in a column that was selected last is the active cell).

Selecting or highlight columns in Excel

If you want, you can select the combined rows and columns using the CTRL key and clicking the Mouse on the title rows or columns.

Selecting rows and columns in same time in Excel

Selecting range of data fields or tables containing data in Excel

If the worksheet we have some data in a range of cells or table can select only that this particular area. For this operation, it is important that the active cell is in the range of the data table or field. To be selected by the cell that contains the data required is the active cell within the area or press the shortcut key combination CTRL+SHIFT+SPACE. After the combination of push these buttons, all adjacent cells in the affected area containing some kind of information will be selected (see figure below).

How to select only the data or the table in one go in Excel