Ask Your Question
0

How to reach the bottom of a sheet with a click?

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

Antonello Lobianco gravatar image Antonello Lobianco
28 5

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

tohuwawohu gravatar image tohuwawohu flag of Germany
1812 13 40

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 :-)

delete close flag offensive retag edit

2 Answers

Sort by » oldest newest most voted
0

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

Pedro gravatar image Pedro flag of Portugal
3218 4 23 54

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

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.

link delete flag offensive edit
0

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

Antonello Lobianco gravatar image Antonello Lobianco
28 5

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

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

link delete flag offensive edit

Login/Signup to Answer

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow

subscribe to rss feed

Stats

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

Seen: 62 times

Last updated: Apr 30 '12