Keyboard Shortcut to Select Text in Column

A keyboard shortcut to select all text in a column is a quick and easy way to do so without having to scroll down the worksheet.  However, depending on whether you are at the top or the bottom of the column, will dictate which keyboard shortcut to use.

Select Text from Top of Column Downwards

So, if you were at the top of Column A, hold down the Ctrl and Shift key together and then press the down arrow. This will then select all the text in that column up until excel finds a blank cell. If you have more text after this then simply repeat the shortcut.

Select Text from Bottom of Column Upwards

The shortcut for this is, funnily, very similar to the process above! Hold down the Ctrl and Shift key together, then press the Up arrow. As before, it will select the text up to the first blank cell.

Simple, eh?

Leave a Reply

Your email address will not be published. Required fields are marked *