Oct 27 2019 09:44 AM
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 thanx from Paris
Oct 27 2019 12:06 PM
Oct 27 2019 05:55 PM
SolutionJust type in reference box (top left from A1) 1:43001 or so.
Oct 29 2019 09:32 AM
Thanx. Not working. I need to select and delete LINES, not cells.
Oct 29 2019 09:38 AM
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.
Oct 29 2019 09:51 AM
Under Lines you mean rows like this
or something different? Above is selected by 3:8 in the box.
Oct 30 2019 06:08 AM
Nov 02 2019 03:07 AM
Thanx, it works, have a great day
Nov 04 2019 03:44 AM
@YvesD , you are welcome
Oct 27 2019 05:55 PM
Solution