MS Excel Shortcut Keys | A to Z MS Excel Shortcut Keys Posted on September 4, 2022September 6, 2022 By Sourabh Kumar Getting your Trinity Audio player ready... Spread the love List of Top MS Excel Shortcut Keys or a to z MS Excel Shortcut Keys: Alt + F + E: To export your own workbook.Ctrl + Shift + Tab: To go to the previous workbook.Ctrl + Shift + F: To open fonts menu under format cells. (Main shortcut keys of ms excel)Ctrl + Shift + O: To select cells containing comments.Ctrl + Up arrow: To go to topmost cell in a current column.Ctrl + End: To go to last cell in a workbook. (Main shortcut keys of ms excel)Alt + Page down: To move screen towards the right.Alt + Page Up: To move the screen towards the left.Alt + F + Z: To share your workbook.Alt + F + C: To close & save your workbook. (Very Important MS Excel Shortcut Keys)Ctrl + Drag: To drag a& copy a cell or to a duplicate worksheet.Ctrl + Shift + Drag: To drag and insert copy.F1: To open Microsoft Excel help. (Function keys in excel)Ctrl + F2: To open print preview window. (Use of function keys in excel)Ctrl + F1: To expand or collapse ribbon. (Use of function keys in excel)F2: For edit a cell. (Function keys in ms excel)F3: To paste a cell name if the cells have been named. (Function keys in excel)Ctrl + F3: For open the name manager. (Use of function keys in excel)Ctrl + F4: To close Microsoft Excel. (Use of function keys in excel)Ctrl + Shift + F3: To create names from values in rows and columns.Shift + F2: To add or edit a cell comment. (Shortcut function keys in excel)Alt or F11: To turnkey tips on or off. (Use of function keys in excel)Shift + F3: To open the Insert function dialog box. (Function keys in excel)F5: Displays to Go to dialog box. (Function keys in ms excel)Ctrl+F5: Restores window size of selected workbook window.F6: Switches between worksheet, task pane, ribbon & Zoom controls. (Function keys in excel)Shift+F6: Switches between worksheet, task pane, Zoom controls & ribbon.Ctrl+F6: Switches to next workbook window when more than one workbook window is open.F7: Open Spelling dialog box to check spelling in active worksheet or selected range. (Function keys in excel)Ctrl+F7: Performs Move command on workbook window when it not maximized. Use arrow keys to move window, & when finished press Enter, or Esc for cancel.F8: Turns extend mode on or off. (Function keys in excel)Shift+F8: Enables you to add a nonadjacent cell or range to selection of cells by using arrow keys.Ctrl+F8: Performs Size command when a workbook is not maximized.Alt+F8: Displays Macro dialog box to create, run, edit, or delete a macro.F9: For calculate workbooks. (Function keys in excel)Shift + F9: For calculate an active workbook.Ctrl + Alt + F9: For force calculate all workbooks.F10: Turns key tips on or off. (Function keys in excel)Shift+F10: Displays shortcut menu for a selected item.Alt+Shift+F10: Displays menu or message for an Error Checking button.Ctrl+F10: Maximizes or restores selected workbook window.F11: Creates a chart of the data in current range in a separate Chart sheet. (Function keys in excel)Shift+F11: inserts a new worksheet.Alt+F11: Opens the Microsoft Visual Basic for Applications Editor, in this create a macro by using visual basic for applicationsF12: Displays the Save As dialog box. (Function keys in excel)Ctrl + Down arrow: To jump to last cell in a current column.Ctrl + Right arrow: To go to last cell in a selected row.Ctrl + Left arrow: To jump back to first cell in a selected row.Alt + Y + W: To know what’s new in Microsoft Excel.Ctrl + Shift + %: To apply percentage formatting.Ctrl + Shift + &: To place borders around selected cells.Ctrl + Shift + _: To remove a border.Ctrl + –: To delete a selected row or column.Ctrl + Spacebar: To select an entire column.Tab: Move to next cell. (Also, Important shortcut keys of ms excel)Alt + F + T: To open options.Alt + Down arrow: To activate filters for cells.Ctrl + Shift + Spacebar: To select an entire workbook.Ctrl + Alt + +: To zoom in inside a workbook.Ctrl + Alt +: To zoom out inside a workbook.Alt + 1: To turn on Autosave.Alt: For Open the access keys.Alt + 2: For save a workbook.Alt + N: To go to the Insert tab in Ribbon.Alt + P: To go to the Page Layout tab in Ribbon.Alt + M: To go to the Formulas tab in Ribbon. (shortcut excel formulas)Ctrl + Shift + ~: To switch between displaying Excel formulas or their values in cell. (shortcut excel formulas)Ctrl + Shift + @: To apply time formatting.Ctrl + Shift + !: To apply comma formatting. (Main shortcut keys of ms excel)Ctrl + Shift + $: To apply currency formatting.Ctrl + Shift + #: For apply date formatting.Alt + A: To go to the Data tab in Ribbon.Alt + R: To go to the Review tab in Ribbon.Alt + W: To go to the View tab in Ribbon.Alt + Y: For open the Help tab in Ribbon.Alt + Q: To quickly jump to search. Alt + Enter: For start a new line in a current cell.Alt + Down arrow: To activate filters for cells.Ctrl + 9: To hide the selected rows. (Also, Important MS Excel Shortcut Keys)Ctrl + 0: To hide the selected columns. (Also, Important MS Excel Shortcut Keys)Esc: To cancel an entry.Enter: To complete the entry in a cell and move to the next one.Shift + Right arrow: To extend the cell selection to the right.Shift + Left arrow: To extend the cell selection to the left.Shift + Space: For select the entire row.Alt + H + H: For select a fill colour. (Also, Important shortcut keys of ms excel)Alt + H + B: To add a border.Page up/ down: To move the screen up or down.Alt + H: For go to the Home tab in Ribbon. (Also, Important shortcut keys of ms excel)Ctrl + 8: To show the outline symbols.Ctrl + 9: For hide a row.Ctrl + 0: To hide a column.Ctrl + Shift + :: To enter the current time in a cell.Ctrl + ;: To enter the current date in a cell.Ctrl + `: For change the view from displaying cell values to formulas. (shortcut excel formulas)Ctrl + ‘: To copy the formula from the cell above. (shortcut excel formulas)Ctrl + –: To delete columns or rows.Ctrl + Shift + =: To insert columns and rows.Ctrl + N: For create a new workbook.Ctrl + O: To open a saved workbook.Ctrl + S: To save a workbook.Ctrl + A: For select all the contents in a workbook.Ctrl + B: To turn highlighted cells bold.+ C: To copy cells that are highlighted.Ctrl + D: To fill the selected cell with the content of the cell right above.Ctrl + F: To search for anything in a workbook.Ctrl + G: To jump to a certain area with a single command.Ctrl + H: To find and replace cell contents.Ctrl + U: To underline highlighted cells.Ctrl + V: To paste anything that was copied.Ctrl + W: To close your current workbook.Ctrl + Z: To undo the last action.Ctrl + 1: To format the cell contents.Ctrl + 5: To put a strikethrough in a cell.Ctrl + I: To italicise cell contents.Ctrl + K: To insert a hyperlink in a cell.Ctrl + L: To open the create table dialog box.Ctrl + P: To print a workbook.Ctrl + R: To fill the selected cell with the content of the cell on the left. How to enable function keys in excel or how to activate function keys in excel? Check keyboard for “F-Lock” or “Function Lock” key.Press “F-Lock” key & then try using a function key Ms excel shortcut keys pdf: You can download ms excel shortcut keys pdf when your internet not working or you cann’t find ms excel shortcut keys online. Click below link Download ms excel shortcut keys pdf Download QR 🡻 Technology excel short cut key
Top Skills To Make Money Every Student Must Know Posted on March 21, 2023January 24, 2025 Spread the love Spread the love As a student, it’s not always easy to balance the demands of schoolwork and earning an income. However, with the rise of technology and the internet, there are now more opportunities than ever to make money while studying. Developing a set of skills that can be monetized… Read More
Technology Understanding Cumulative Layout Shift (CLS) and its Impact on SEO Posted on April 21, 2023January 21, 2025 Spread the love Spread the love In recent years, user experience has become increasingly important for search engine optimization (SEO). One aspect of user experience that has gained attention is Cumulative Layout Shift (CLS). In this blog post, we will explore what CLS is, why it matters for SEO, and how to optimize… Read More
How to Choose a Solar Hot Water System That Won’t Freeze? Posted on January 28, 2022January 21, 2025 Spread the love Spread the love There are ample advantages of non-renewable energies. Solar energy is most widely used provides help in various sectors. It has a wide range of usage, right from modern-day agricultural techniques to various IoT devices. One such usage is seen in hot water systems. A solar heater uses… Read More