Forum Discussion
Solved
How can you select 43 001 lines in one swift movement?
Hi, how do you select 43 001 lines in Excel (yes, I mean "lines", not "cells") using a very fast method ? I use Office 365 Excel on my HP Spectre i7, fiberglass to internet link, etc. In advance th...
Just type in reference box (top left from A1) 1:43001 or so.
One option might be to convert the range to a table and then select the entire table from the top-left of the headers. If you are a fan of magic key combinations Ctrl+Shift+End might do what you require.
Hi. Thanx. To be more precise :
In my Excel sheet :
- my first line is n°1
- I want to select all the lines until the n°43 001
- the last line is n°84 703
I don't want to select the lines n°43 002 to 84 703
So is there a key combination resembling " Ctrl+Shift+End " that could work? ... that wouldn't select until (the) END (of the sheet), is what I mean.