In Excel, we often need to pick a specific range of cells to operate. Sometimes, we need to pick cells from the digit to the digit. Below, I will introduce how to pick cells from digits to digits in Excel.
First of all, we need to use the mouse or keyboard to select the range of cells to pick. You can use one of the following methods:
1.Drag the mouse to select: Move the mouse to the cells in the first row or column of the cell range you want to select, then hold down the left mouse button and drag to the cells in the last row or column of the cell range you want to select, and then release the left mouse button.
2.Use the keyboard keys to select: Hold down the shift key, then use the arrow keys or the page up page down key to select the cells in the first row or column of the cell range you want to select, then release the shift key, then hold down the shift key, then use the arrow keys or the page up page down key to select the cells in the last row or column of the cell range you want to select, and then release the shift key.
Once we have selected the range of cells to be manipulated, we can use one of the following methods to pick cells from the digit to the digit
1.Use the right-click menu: Right-click the mouse in the selected range of cells, and then select the "Columns" or "Rows" option under the "Selected" menu in the pop-up context menu. Enter the starting row or column and the number of the end row or column of the cell range you want to select in the pop-up dialog box, and then click OK.
2.Use shortcut keys: Press Ctrl + Shift + Arrow keys (Top, Down, Left, Right) or Ctrl + Shift + Page Up Page Down keys to select a range of specified rows or columns starting from the current cell within the selected cell range.
For example, if we want to pick cells from row 2 to row 5, we can follow these steps:
1.Click the intersection between row 1 and column 1 in the excel sheet to select the entire worksheet.
2.Press Ctrl + Shift + Down Arrow keys in the selected range of cells to select cells from row 2 to row 5.
The above is how to select cells from the digits to the digits in Excel. Hope it helps!