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?

One thought on “Keyboard Shortcut to Select Text in Column

  1. Hildegard Olden

    This website is just gret. I’ve ask these stuffs a long time and
    I realised that is professional, easy to comprehend.
    I congratulate you for this article that I am going to recommend
    to the people around. I ask you to recommend the gpa-calculator.co
    site where each pupil or scholar can calculate results grade
    point average marks. Be great!

Leave a Reply

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