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.
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
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.
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.
PowerPoint contains slides and objects.
Selecting things can get confusing because things can be overlapping.
But if you know the right method, it is a cakewalk.
Estimated reading time 7 min
Continue reading Selecting things in PowerPoint
Excel is a grid. Therefore selecting things in Excel is very different from Word or PowerPoint.
Excel offers many powerful and interesting ways of selecting things.
You will be surprised to know the capabilities …
Read on to find out more.
Estimated reading time 10 min
Continue reading Selecting things in Excel
Yes. You have no idea how many unbelievable things there are in this seemingly simple topic.
Read on and get amazed!
Estimated reading time 3 min
Continue reading How to select things in Word
In this post, I will discuss Ctrl A, the humble shortcut which almost everyone uses in the context of Word documents but nowhere else.
The idea is simple. Ctrl A selects all the things in the current context.
Confused? Read on …
Continue reading Do you know all about Select All?
This is a very small post. But very useful in specific scenarios.
Continue reading Did you know? Vertical Selection in Word