10 More Useful Keyboard Shortcuts In #Excel

Here are 10 keyboard shortcuts in Excel that I’ve started using more regularly. I hope they are useful to you:

Alt H B A – this will apply all borders to your data range.
Alt H B N – this will remove all borders from your data range.
Ctrl B – this will bold your selected cells. It’s a toggle so it will also remove bolding.
Ctrl U – this will underline your selected cells. It’s also a toggle so it will remove underlining.
Ctrl + (plus sign) – this will bring up the dialog box to insert a cell, row, or column. I use the plus sign from the number keypad, but you can also use Ctrl Shift + from the number row.
Ctrl – (minus sign) – this will bring up the dialog box to delete a cell, row, or column. You can use either minus sign on your keyboard.
Ctrl 1 – this will bring up the Format dialog box.
Ctrl F1 – this will hide/unhide the Ribbon. Very useful if you need the extra space while working.
Ctrl Shift 1 – this will format numbers with a comma and two decimal places.
Menu key V – this will paste values only. The menu key is this one:

menu key

Happy (and speedy!) Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, ,

No comments yet.

Leave a Reply