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

Details

Article ID: 7876
Created
Thu 12/22/22 11:52 AM
Modified
Fri 11/3/23 11:13 AM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

Related Services / Offerings (1)

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.