How To Select Everything In Excel

If you want to select a whole spreadsheet in Excel, you can use the familiar Control-A shortcut (which also works in many other apps). For a more mouse-centric alternative, click in the empty box next to Row A and column 1 (with a shaded triangle on it).

The keyboard version has one difference to the mouse approach: if you type Control-A whilst inside a table, that will select the table rather than the entire spreadsheet. Both options can be useful. (If you want to select all of a spreadsheet that includes tables using the keyboard, move to a cell which isn't in the table before typing Control-A.)

For more Excel shortcuts, check out the six most useful options we've discovered and the very handy use of the Control key to move around blocks of data.

[via Project Woman]


Comments

    (If you want to select all of a spreadsheet that includes tables using the keyboard, move to a cell which isn’t in the table before typing Control-A.)

    or just press Ctrl+A twice, that selects the table, then everything.

    EXCEL-101

    Next after selecting all data :- Resize all columns to fit, but positioning the cursor between any 2 columns headers (ie between the 2 | 3 - the cursor will change) and double clicking.

      but -> by

    Alternatively, press CTRL+A twice to select the entire spreadsheet rather than just a table therein.

    EDIT: D'OH! Too slow

    Last edited 22/11/12 4:35 pm

    I think they taught us this in primary school, in the 90s!

    What next, a tip on how to save by pressing Ctrl-s or F12 to save-as?
    Stunningly boring.

    Next up, how to get the flight-sim game in Excel '95.

    That only selects all cells in a worksheet. To select the entire workbook, follow those steps on the leftmost or rightmost sheet, hold down shift, then click the rightmost or leftmost sheet accordingly.

    Thanks for the post and also the additional tips in the comments. I didn't know that you could resize all columns like that. I'm fairly new to Excel, so little tips like these are great! :)

Join the discussion!

Trending Stories Right Now