Best MS Excel Shortcut Keys

More than 100 Best MS Excel Shortcut Keys: You have to Know to make your work life easier

All the Best MS Excel Shortcut Keys

In this article, we will cover more than 100 best Microsoft Excel Shortcut keys which will make your work life easier and faster:

Ctrl + A = Select All

Ctrl + B = Bold

Ctrl + C = Copy

Ctrl + D = Fill the same content towards Downward

Ctrl + F = Find

Ctrl + G = Go To

Ctrl + H = Replace

Ctrl + I = Italic

Ctrl + K = Insert Hyperlink

Ctrl + N = New Workbook

Ctrl + O = Open

Ctrl + P = Print

Ctrl + R = Fill the same content towards Rightward

Ctrl + S = Save

Ctrl + U = Underline

Ctrl + V = Paste

Ctrl + W = Close

Ctrl + X = Cut

Ctrl + Y = Repeat or Redo

Ctrl + Z = Undo





F1 = Help

F2 = Edit

F3 = Paste name

F4 = Repeat last action

F4 = While typing a formula, switch between absolute/relative reference.

F5 = Go To

F6 = Next pane

F7 = Spell check

F8 = Extend mode

F9 = Recalculate all workbooks

F10 = Activate Menubar

F11 = New Chart

F12 = Save As

Ctrl + : = Insert Current Time

Ctrl + ; = Insert Current Date

Ctrl + " = Copy value from cell above

Ctrl + ' = Copy formula form cell above

Shift = hold down shift for additional functions in Excel’s menu

Shift + F1 =What’s This

Shift + F2 = Edit cell comment

Shift + F3 = Paste function into formula

Shift + F4 = Find Next

Shift + F5 = Find

Shift + F6 = Previous pane

Shift + F8 = Add to selection

Shift + F9 = Calculate active worksheet

Shift + F10 = Display shortcut menu

Shift + F11 = New worksheet

Shift + F12 = Save





Ctrl + F3 = Define name

Ctrl + F4 = Close

Ctrl + F5 = XL, Restore window size

Ctrl + F6 = Next workbook window

Ctrl + F7 = Move window

Ctrl + F8 = Resize window

Ctrl + F9 = Minimize workbook

Ctrl + F10 = Maximize or restore window

Alt + =  Auto Sum

Shift+Ctrl+F6 = Previous Workbook window

Ctrl + F11 = Insert 4.0 Macro sheet

Ctrl + F1 = File open

Alt + F1 = Insert Chart

Alt + F2 = Save As

Alt + F4 = Exit

Alt + F8 = Macro dialog box

Alt + F11 = Visual Basic Editor

Ctrl + Shift + F3 = Create name by using names of Row and Column labels

Ctrl + Shift + F6 = Previous Window

Ctrl + Shift + F12 = Print

Alt + Shift + F1 = New worksheet

Alt + Shift + F2 = Save

Alt + ' = Format style dialog box

Ctrl + Shift + A = Insert argument names into formula

Alt + Down arrow = Display auto complete List

Ctrl + Shift + ~ = General format

Ctrl + Shift + ! = Comma format

Ctrl + Shift + @ = Time Format

Ctrl + Shift + # = Date Format

Ctrl + Shift + $ = Currency format

Ctrl + Shift + % = Percent Format

Ctrl + Shift + ^ = Exponential format

Ctrl + Shift + & = Place outline border around selected cells

Ctrl + Shift + _ =Remove Outline Border

Ctrl + Shift + * = Select current region

Ctrl + + = Insert Row/Column

Ctrl + - = Delete Row/Column





Ctrl + 1 = Format cells dialog box

Ctrl + 2 = Bold

Ctrl + 3 = Italic

Ctrl + 4 = Underline

Ctrl + 5 = Strikethrough

Ctrl + 6 = Show/Hide objects

Ctrl + 7 = Show/Hide Standard toolbar

Ctrl + 8 = Toggle Outline symbols

Ctrl + 9 = Hide rows

Ctrl + 0 = Hide columns

Ctrl + Shift + ( = Unhide rows

Ctrl + Shift + ) = Unhide columns

Alt or F10 = Activate the menu

Ctrl + Tab = In toolbar: next toolbar

Shift + Ctrl + Tab = In toolbar: previous toolbar

Ctrl +Tab = In a workbook: activate next workbook

Shift + Ctrl + Tab = In a workbook: activate previous workbook

Tab = Next tool

Shift + Tab = Previous tool

Enter = Do the command

Shift + Ctrl + F = Font drop down list

Shift + Ctrl + F +F = Font tab of format cell dialog box

Shift + Ctrl + P = Point size drop down list


There are lots of other MS Excel Shortcut Keys which we will cover in the next article. Please share the information so that everyone's working life will be easier.



Dedicated Video on some other Unknown Computer shortcuts for Daily Use

MS Word & Excel Computer Shortcuts for daily use | Unknown MS office Shortcut explained in Hindi



JOIN OUR CHANNEL/GROUP FOR REGULAR UPDATES


On Telegram:
  • Join our Telegram group for GST Updates (Ranked Top on Google): Click Here
  • Join our Telegram group for Income Tax Updates: Click here
  • Join our Telegram group for all Statutory Updates: Click here
  • Join our Telegram group for Finance Updates: Click here
  • Join our Telegram group for Accounts Updates: Click here
  • Join our Telegram Channel for GST, Income Tax Discussion & Queries: Click here
  • Join our Telegram group for Wholetubermanish overall Website updates: Click here

On Whatsapp:

On Facebook:
  • Join our GST, Income Tax, Accounts, Audit & Finance Updates Group: Click here
  • Like our Wholetubermanish FB page for overall Website updates: Click here

(We committed to deliver you the very best of knowledgeable content without even a single spamming)

If you want to submit your articles and featured your name on our website, Submit your article here or you can mail us at contact@wholetubermanish.in.

Please allow push notification from our website and subscribe to our E-mail newsletter so that you won't miss any important updates from us.


FOLLOW US ON OUR SOCIAL MEDIA HANDLES FOR REGULAR UPDATES

Instagram 🔴 YouTube 🔴 Facebook 🔴 Twitter 🔴 Linkedin 🔴 Pinterest 🔴 Reddit

Post a Comment

Please drop your queries, suggestions & feedback.

Previous Post Next Post