Tag Archives: Selection

Irritant: Excessive Text selection

I want to select a sentence. Sometimes, instead of the sentence, the entire paragraph is selected. Inside a table, contents of the entire cell are selected. I quickly undo and then try to select the text again, this time with a bit more caution, but alas, the problem still remains. It is inexplicable and frustrating. Here is what you do in such cases.

The Text Selection action replay

I want to select the second paragraph.
I am using Shift Right Arrow to select the text, one character at a time.

excessive selectionimage

imageimage

Usually we get frustrated at this point. We give up the effort and start all over again … HOPING that it will work this time.  It never does!

Fortunately, there is a simple solution to this selection nightmare.

The solution is … Press SHIFT  and LEFT ARROW once. That’s all.

Even if you use Shift CTRL RightArrow to select word by word, this problem can occur. The solution is exactly the same: Press Shift LeftArrow.

Continue reading Irritant: Excessive Text selection

How to select a column in an Excel table

Usually we select ENTIRE column rather than the data column. That leads to many side effects including applying unnecessary formatting to millions of rows or thousands of columns. Tables make it extremely easy to select only the data in a column. See for yourself.

image

Just hover the mouse cursor over the column name in a table and click. It selects only the data in the column – not the entire sheet column. Even if there are empty cells in the column, the entire data column will be selected. To select a table row, right click and choose Select – Table Row.
Now you NEVER need to select entire columns and rows across the sheet.