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 6 Networking Technologies for Data Centers Posted on August 28, 2022January 20, 2025 Spread the love Spread the love Data centers are the heart of any business, and you never want to cause a disruption or service outage in these. Many different technologies can be used for data center solutions, but this article is going to cover the top 6 most common ones. The importance of… Read More
Best Project Management Software Posted on March 19, 2023January 22, 2025 Spread the love Spread the love Introduction Project management software is an essential tool for businesses of all sizes. These software solutions allow teams to collaborate, plan, track progress, and manage resources for projects of all kinds. With so many options available, it can be difficult to choose the best one for your… Read More
A Guide To Choosing A High Caliber Family Entertainment Software Point of SaleĀ Posted on June 9, 2022January 21, 2025 Spread the love Spread the love From sales to inventory, POS systems can handle it all. It takes research to find one that is a good match for the job and budget. POS (point-of-sale) system integrates a number of business functions into a single package. They could be used to manage purchases as… Read More