![]() ![]() Excel closes the dialog box and selects the cells. To select nonadjacent cells, type each range separated with a comma, for example, type "C5:F9, J5:P9" to select cells between C5 and F9 and J5 and P9 and press ENTER.To select a single range, type the range you want to select, for example, type "C5:F9" to select all the cells between C5 and F9 and press ENTER.The "Go To" dialog box opens with the cursor in the "Reference" box. To select cells using the "Go To" command: Tip: Excel indicates it is ready to add further cells to the selection by showing the word "ADD" on the Excel Status bar. Repeat the previous step until you have selected all the required cells in the worksheet. ![]() If you wish to select more cells, press SHIFT + F8 and select the next range of cells.Hold down SHIFT and press DOWN ARROW and RIGHT ARROW to select the cells in the second range.Go to the top left cell in the second range. ![]() Hold down SHIFT and press DOWN ARROW and RIGHT ARROW to select the cells in the first range.To select nonadjacent cells using the keyboard: You can select nonadjacent cells in a worksheet. Select nonadjacent ranges using the keyboard To select all used cells in the worksheet, press CONTROL + HOME to go to the first cell in the worksheet and then press CONTROL + SHIFT + END.To select an entire row, press SHIFT + SPACEBAR.To select an entire column, press CONTROL + SPACEBAR.If you press CONTROL + SHIFT + RIGHT ARROW again, you will select the entire row. This will select cells to the last used cell in the row. To select a row, move to the first cell in the row and press CONTROL + SHIFT + RIGHT ARROW. ![]() If you press CONTROL + SHIFT + DOWN ARROW again, you will select the entire column. This will select cells to the last used cell in the column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |