Forum Discussion

PeterOSullivanUK's avatar
PeterOSullivanUK
Copper Contributor
May 17, 2024

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 col...
excel
Martin_Angosto's avatar
Martin_Angosto
Iron Contributor
May 17, 2024

PeterOSullivanUK 

 

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?

  • PeterOSullivanUK's avatar
    PeterOSullivanUK
    Copper Contributor
    May 23, 2024

    Martin_Angosto 

    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 

    • Martin_Angosto's avatar
      Martin_Angosto
      Iron Contributor
      May 24, 2024

      PeterOSullivanUK 

       

      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

Resources