I'm trying to figure out how to select a specific number of rows in Excel, specifically 100 rows. I want to be able to highlight or choose these rows for data manipulation purposes.
6 answers
Giulia
Wed Dec 11 2024
To make a selection in a spreadsheet, you have multiple options.
EchoPulse
Wed Dec 11 2024
You can choose one or more rows and columns by clicking on them directly.
CryptoWanderer
Wed Dec 11 2024
Alternatively, you can click on any cell within a column and press Ctrl + Space to select the entire column.
Bianca
Tue Dec 10 2024
If you wish to select an entire row, simply click on any cell within that row and press Shift + Space.
benjamin_rose_author
Tue Dec 10 2024
For selecting non-adjacent rows or columns, you need to hold down the Ctrl key while clicking on the desired row or column numbers.