Selection · original practice scenario
Shift the selected block one column left
Fill B2:D4 with nine distinct labels and select C2:C4 without entering edit mode.
Start here: Mac worksheet range selection, outside cell-edit mode
No Windows binding is listed in the reviewed source. If the OS intercepts the combination, stop and inspect the active application rather than typing into it.
Follow these instructions in your own desktop Excel workbook. This page explains the operation; it does not send commands to Excel.
Windows keys and context
This catalog has no verified Windows binding for this operation. The steps below describe Mac. Choose Mac to use the walkthrough and recall controls.
Walk through the operation
- Confirm C2:C4 is the selected block, leaving room to the left.
- Use the listed combination once.
- Inspect the selection address and the unchanged values in the original cells.
Expected result: The selection moves one column left with the same height; this is not a move of cell contents.
Related walkthroughs
- Extend a rectangular selection to a clicked cell
- Add a separate cell or range to a selection
- Select nonadjacent worksheet tabs
- Select adjacent worksheet tabs
Catalog updated 2026-10-18. US keyboard notation: + joins held keys; commas separate successive presses. Function keys may require Fn. Desktop instructions are separate from this browser's own keyboard shortcuts.