Ctrl+Shift+_ Excel Shortcut Erase The Selected Lines Border Of Cells | Exceltip2day

Hello there.

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

Ctrl + Shift + _ shortcut Excel.

Tip Quiz

What is the shortcut key to order printing?

In Excel spreadsheet, if you want to erase lines border off. You can use a shortcut key to apply the task as method below:

Method:

• Select the active cell(s) where you want to line off the border (e.g. as the image below is B3 : D7)

• Press the "Ctrl" button on your keyboard and keep it hold.

• Press the "Shift" button and keep it hold too.

• Press the "_" button. (underscore)

Then release all the three buttons.

Shortcut erase border lines in Excel sheet

The square outline border will be off immediately.

Note:

This shortcut will help you to erase a square border with the only press the three shortcut keys.

Shortcut for: Border lines off.

Windows shortcut

CtrlShift_

Did you find this article useful?

Tip Answer

 a. It's an "Alt" + "P".

 b. It's a "Shift" + "P".

 c. It's a "Ctrl" + "P".

 Answer: c. That's cool! 

Check: Shortcut Excel Keyboard Key Button to Order for PRINTING

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:

• Removes Unwanted Spaces Leading, Trailing And Between Words From The Text String
• VLOOKUP Searches For Value From Table Array In The First Column Return Value The Same Row
• Formula “LOOK UP - Array Form” Automatically Looks Approximate Match Values First