List of MS Excel Shortcut Key for office use

Accountant Interview, CA Jobs, News & Updates Leave a comment

Hello Dear CA Students,

We are Sharing With You List of MS Excel Shortcut Key . So kindly Check Out our http://www.castudynotes.com website and ALL the Best for Your upcoming Exams.

CA STUDY NOTES

🕹List of MS Excel Shortcut Key
Save it and it will be very Helpful in office work.

  • Ctrl+A – Select All
  • Ctrl+B – Bold
  • Ctrl+C – Copy
  • Ctrl+D – Fill Down
  • Ctrl+F – Find
  • Ctrl+G – Goto
  • Ctrl+H – Replace
  • Ctrl+I – Italic
  • Ctrl+K – Insert Hyperlink
  • Ctrl+N – New Workbook
  • Ctrl+O – Open
  • Ctrl+P – Print
  • Ctrl+R – Fill Right
  • Ctrl+S – Save
  • Ctrl+U – Underline
  • Ctrl+V – Paste
  • Ctrl W – Close
  • Ctrl+X – Cut
  • Ctrl+Y – Repeat
  • Ctrl+Z – Undo
  • F1 – Help
  • F2 – Edit
  • F3 – Paste Name
  • F4 – Repeat last action
  • F4 – While typing a formula, switch between absolute/relative refs
  • F5 – Goto
  • 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 from 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
  • Shift+Ctrl+F6 – Previous workbook window
  • Ctrl+F7 – Move window
  • Ctrl+F8 – Resize window
  • Ctrl+F9 – Minimize workbook
  • Ctrl+F10 – Maximize or restore window
  • Ctrl+F11 – Inset 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+= – AutoSum
  • Ctrl+` – Toggle Value/Formula display
  • Ctrl+Shift+A – Insert argument names into formula
  • Alt+Down arrow – Displayy AutoComplete list
  • Alt+’ – Format Style dialog box
  • 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
  • Ctrl+- – Delete
  • 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

◈◉◎┄┅══❂❣❂══┅┄◎​◉◈
Telegram https://t.me/Jobs4CA

Instagram :- https://www.instagram.com/ca.notes

Share this Post with your friends & help them to PASS.

Here all materials, PDFs are provided from various available sources, as we never own them, or scan them, we ar just facilitators, so we are not intentionally violating any laws, still if you feel that something should not be on site, you can contact us through email: infocanotes@gmail.com

JOIN OUR MAILING LIST:

Subscribe to hear from us about new addition to castudynotes.com website and other important stuff.

All PDF which are provided here are for Education purposes only. Please utilize them for building your knowledge. We request you to respect our Hard Work. Our Intention is to provide free Study Materials for all Aspirants and we believe Education Should be free for All, and for the same reason, we gathered everything and assembled at one place.

Disclaimer:-

castudynotes.com does not own this Materials, Test Series or anything we share, neither created nor scanned. we just providing the links already available on Internet. and also we doesn’t Own any trademarks or copyrights of any institute, Teachers and others which we share are purely for Education purpose only and all copyrights and Trademarks lies with the respective Institutes/Comapanies only. We don’t intend to either harm or encash your hard work, if any way you feel that our content violates any Copyrights or any privacy laws or if you have any issue, please let us know at infocanotes@gmail.com and we will definitely try to provide possible solution for the same. Thank you.

kindly Leave a Reply Here