Am I the Last One? Select All

Yes, I have been using the Select All keyboard shortcut for years.

CTRL + A = Select All; hold down the CTRL key, tap the “a” key (no need to capitalize) and then release the CTRL key

In Word – CTRL + A will select all text in the document. This makes wholesale changes quick – you can easily select all text, then as an example, make it all size 14, Comic Sans, dark blue and centered.

In a folder full of files – CTRL + A will select all files within that folder. This makes it easy to copy, move, delete, etc. all the files at once.

In PowerPoint – click in the little Slides thumbnail area and  CTRL + A will select all slides at once and you can then change the layout of all slides at once, change the background of all slides at once, etc.  Click on the edge of one of your slides in the large preview area and CTRL + A will select all objects in the one slide. It’s then easy to move everything at once, change all fonts at once, etc.

In Excel – CTRL + A will select all cells in the worksheet… or WILL IT???
Hmmm… this is what I learned just recently: Typically in Excel you have a group of cells with data (a list, table, range, etc.). This table may be just a few cells or thousands.  If you click outside the table and CTRL + A Excel will select all the cells in the entire worksheet, BUT, if you click within the table and then CTRL + A, Excel will magically select only the cells within the table.  SCORE!
Look at the example below. You’ll see a table of cells in the B3:E13 range.
If you click outside the range, say in cell D15 (marked in green in the screenshot) and CTRL + A, you’ll select all 16,000+ cells in this one worksheet.
But if you click inside the range, say in cell D7 (marked in orange) and CTRL + A, you’ll select just the range B3:E13
What an incredible time saver!

Table in Excel

Advertisements

One thought on “Am I the Last One? Select All

  1. I still use them, and yes I knew about the Excel tricks. I use ctrl + a most often to cut, copy, or paste.

    We dinos have to stick together down here in the tar pit…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s