Faq/Calc/126

    From The Document Foundation Wiki
    < Faq‎ | Calc

    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