Ctrl + Space Bar - Excel Shortcut Keyboard Selecting Entire Column(s) | Exceltip2day

Hello there.

I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about:

How to use "Ctrl" + "Space Bar"

Tip Quiz

How do I delete the multiple data entry in an easy way?

Yes, we're going to explore how to select the columns(s) entirely in Excel worksheet with a few steps.

Why do we have to select the entire columns?

Because of columns are fundamental parts of any worksheet of Excel office program. They contain cells that intersect with rows.

Then the tips will help us to select all cells from top to down in the columns for any future proceeding such as deleting all entered data in the column(s), deleting or hiding column(s),

See the 2 methods of how to select column(s) as below:

1] Use mouse and clicking on the column heading letter as shown as image underneath. Example click on "D" letter at the top of the column.

2] Use the shortcut letter key.

• Move cursor to any cell(s) wherever as desired to select. For example, as the images below, selecting the cells "B7-C7"

• Press [Ctrl]+[Space Bar] buttons on the keyboard.

Shortcut for: Select the entire column which cell(s) have been occupying currently.

Windows shortcut

CtrlSpace Bar

Click the cells B7-C7

Press [Ctrl] and [Space Bar]

That's finished.

The entire cells in the column(s) are selected.

Additional:

It will work for any column(s) wherever as you want to proceed, just only one single column or more...can do.

This shortcut is giving the same result if we use the basic method; moving the mouse cursor to the head top of some column we want to select.

For example, if we would like to select column "B" to "F", just use mouse clicking on the letter "B" to "F" of the top head of the columns.

Tip Answer

 a. You can use the function “Find & Replace” to apply for delete.

 b. You can use “Ctrl" + "Home”.

 c. You can use only the "Delete" button.

 Answer: a. Yes! Let's try. 

Check: Trick How To Delete The Same Data In Multiple Places With An Easy Way

Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000

Thanks for reading.
Bye,

Posted by: Michael Leng



I've known, then I've grown.


See more articles:

• Trick How To Delete The Same Data In Multiple Places With An Easy Way
• Ctrl+Shift+_ Excel Shortcut Erase The Selected Lines Border Of Cells
• Removes Unwanted Spaces Leading, Trailing And Between Words From The Text String