Ask Your Question

Revision history [back]

Hit Ctrl+Shift+T to enter the Name Box and append the end address to the cell address displayed there, for example when you are on cell A5 edit the field to A5:A1048576 for the rest of the column until its end, then hit Enter, the range gets selected without moving the view. Another possibility is to select to the end of the column first by repeated Ctrl+Shift+Down, which moves the view, then hit Enter followed by Shift+Enter and you're back on the position where you started, though that cell will be on top (first row) of the view then.