Forum Discussion
Selecting a range of cells in MS Excel
How do I select (in order to delete or modify) a range of cells from a currently selected cell to:
- the end of a range with data in a row or column
or
- to the end of a row (left or right) or column (up or down)
Thanks
Hi,
To select an entire range of data (columns and rows included) just select one cell that contains data and press CONTROL + A.
If you are in a cell and want to select until the last written cell in that column, CONTROL + SHIFT + DOWN/UP Arrow. For selecting and moving to the last not-empty cell of the row CONTROL + SHIFT + LEFT/RIGHT Arrow.
Is this what you're looking for?
Martin, thank you very much; just what I was looking for.
I think is earlier versions there was a different combination of keys; I was not aware of the change.
I wonder if you also know, how, in MS Word, to select a row of text?
Thanks. Peter O'Sullivan
In Word, place the cursor and select the starting of a line and then click SHIFT + DOWN ARROW.
Please mark any solution of this post as an answer if that is all you needed!
Martin
PeterOSullivanUK More information can be found at Keyboard shortcuts in Excel - Microsoft Support, specifically under the topic Keyboard shortcuts for making selections and performing actions (for Windows; click instead on one of the links near the top of the page for macOS, Office for iOS, Office for Android, or Web, for those platforms; topic names differ by platform).
Additionally you can press ctrl+space to select a column or shift+space for rowsPeterOSullivanUK
