Select & Move Worksheet Cells in Excel

Question

How to select & move worksheet cells in Excel?

Answer

To select a large area of cells, click the first cell in the range, press and hold the Shift key, and then click the last cell in the range. Once you have selected a range of cells, you may move the cells within the worksheet by clicking and dragging the selection from its current location to its new one.
  1. To do this, bring your cursor to the side of the selection. When your cursor turns into 4 arrows pointing in opposite directions click and hold on to the mouse and drag wherever you want to locate it and let go of the mouse.
  2. By pressing and holding the Ctrl key as you drag, Excel will leave the original selection in its place and paste a copy of the selection in the new location.  To move between workbooks, use the Alt key while dragging the selection.

For more information about Microsoft Excel Basics, please view the full tutorial from the CTL here: Excel Part 1

If you need further assistance, please click the CTL Support Request button on this page.

CTL Support Request Print Article

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.