Operations with blocks in Excel

The following article provides detailed instructions for you to manipulate blocks in Excel.

Frequently used operations in spreadsheets when working with blocks:

1. Select blocks of contiguous cells.

Place the mouse cursor in the first cell position of the block -> hold the left mouse button drag to the data area of ​​the block -> the selected block is highlighted:

Operations with blocks in Excel Picture 1

2. Select blocks of discrete cells.

- To select a block of discrete cells, do the following: Place the mouse cursor in the first cell of the block -> hold down Ctrl -> move to the other cell you want to be in the block, with many similar operations until The entire data range of the block -> is finally the result (the highlighted cells are the cells in the selected block):

Operations with blocks in Excel Picture 2

3. Select 1 or more columns.

- To select an entire column -> move the mouse over the column header until the cursor changes to an down arrow, hold the left mouse button drag to the next column to create a block -> results:

Operations with blocks in Excel Picture 3

- To select individual columns do the following: Click to select the first column (by moving the column header when the cursor appears arrow down) -> hold down Ctrl -> move to the title of the required column Add to the block until the arrow appears downward and the column is highlighted, if there are multiple columns doing the same operation, the result:

Operations with blocks in Excel Picture 4

4. Select 1 or more rows.

- Similar to selecting columns, if you select multiple adjacent rows you just need to move the order of the first row in the left mouse-holding block and move to the order of adjacent rows -> results:

Operations with blocks in Excel Picture 5

- Select a block of non-adjacent rows: Click the first row number in the block -> hold down Ctrl -> move to the rows you want to create the block and select the same as the first row selection -> result:

Operations with blocks in Excel Picture 6

5. Select the entire workbook.

- Click the intersection of rows and columns -> the whole worksheet is highlighted:

Operations with blocks in Excel Picture 7

Above is a detailed guide for manipulating blocks in Excel 2013.

Good luck!