Ask Your Question
0

How to reach the bottom of a sheet with a click? [closed]

asked 2012-04-30 10:17:27 +0100

Antonello Lobianco gravatar image

updated 2012-08-12 13:30:16 +0100

tohuwawohu gravatar image

Hello, in large spreadsheets it is ofter hard to reach the exact bottom of themm, as you have to move with sliders. In the orizzontal dimension a useful help is the usage of the "end" keyboard button, and if you press shift+"end" you even select the whole row active interval (that's different to select the raw of course). I wander if there is a similar feature for the vertical dimension, so you don't have to scroll the whole document to reach its latest row or select the column interval. Thank you/grazie/merci :-)

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-15 23:57:58.327262

2 Answers

Sort by » oldest newest most voted
0

answered 2012-04-30 11:27:22 +0100

Pedro gravatar image

updated 2012-04-30 11:29:29 +0100

Ctrl+Down Arrow moves the cursor to the last cell on the sheet that contains data. Therefore pressing Shift+Ctrl+Down Arrow selects vertical data to the last cell that contains data.

edit flag offensive delete link more
0

answered 2012-04-30 10:23:16 +0100

Antonello Lobianco gravatar image

I got this link that actually includes all the shortkeys for calc:

http://help.libreoffice.org/Calc/Shortcut_Keys_for_Spreadsheets

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-04-30 10:17:27 +0100

Seen: 3,290 times

Last updated: Apr 30 '12