Frequently asked questions - Calc

From The Document Foundation Wiki
< Faq‎ | Calc
Jump to: navigation, search

How to select all the data on a sheet

  1. Press Ctrl+Home or click on A1 to select that cell
  2. Press Ctrl+⇧ Shift+End

Note

  • Ctrl+A, or a click on the intersection of the row numbers and the column headers, selects the whole sheet, including the empty rows
  • Ctrl+* selects only the current contiguous range (the same as the range selection tool in the navigator)
  • If you position the mouse on the last cell and then go back to the beginning (with Ctrl+⇧ Shift+Home) it works but... you need to know which is the last cell

See also: Shortcut Keys for Spreadsheets