More than 100 Best MS Excel Shortcut Keys: You have to Know to make your work life easier
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 HindiJOIN 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:
- Join our GST Income Tax Update WM1: Click here
- Join our GST Income Tax Update WM2: Click here
- Join our CA Fraternity: Click here
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
Post a Comment
Please drop your queries, suggestions & feedback.