SOLVED

Selecting Continuous data in a spreadsheet

Copper Contributor

I am using Excel for Microsoft 365 MSO (Version 2111 Build 16.0.14701.20254) 64-bit

Back in the day (over 20 years ago) I was importing a lot of csv files with a lot of data in each. I was graphing this data and wanted a way to easily select all the data. There were thousands of lines sometimes. I remember finding a command I could add to the toolbar that selected all cells that were contiguous with the cell you selected. The icon looked like a circle in a square with arrows pointing to each corner of the square. I looked at customising the ribbon but can't see it. Does this still exist?

2 Replies
best response confirmed by VI_Migration (Silver Contributor)
Solution

@Gordon_Lamb  is 'Select Current Region' the button you want?

mtarler_0-1641644760540.png

Under customize the ribbon you need to select "All Commands"

That is it, thanks.

Gordon
1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

@Gordon_Lamb  is 'Select Current Region' the button you want?

mtarler_0-1641644760540.png

Under customize the ribbon you need to select "All Commands"

View solution in original post