10 Excel Quick Tips
Part four of a -part series of blogs

Posted by Andrew Gould on 02 December 2011

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Excel Quick Tip #4 - Selecting a Table

When you have an entire table of cells to select there's a much quicker way than simply clicking and dragging with the mouse.

  1. Click on any cell within the block of data that you want to select.
Selecting a single cell

Here we've clicked on the cell in the second row and second column of the block of data we want to select.

  1. Press CTRL + A on the keyboard.
Selected block

Excel selects all of the cells up to the next completely blank row and column.

You can see this technique in action in this short video.

This blog has 0 threads Add post