The Excel Ribbon is the command bar at the top of the application window that contains all the buttons we commonly press to perform actions. The Ribbon contains various tabs starting with the File and Home tabs
Open the menu for a selected button. Alt+Down arrow key When a menu or submenu is open, move to the next command. Down arrow key Expand or collapse the ribbon. Ctrl+F1 Open a context menu. Shift+F10 Or, on a Windows keyboard, the Windows Menu key (usually between the Alt Gr and ...
Close your Excel workbook. Doing so does not shut down Excel Ctrl+X Cut selected cells, or any other selected object such as a chart Ctrl+Y F4 Repeat or redo the last command or action, if doable Ctrl+Z Undo the last action; press repeatedly to undo more actions ...
Insert the password to protect your workbook >> press OK.2.10 Close Current Workbook: Ctrl + F4Press Ctrl + F4 to close the active workbook.Note: For Mac users, press Command (⌘) + W2.11 Close Excel: Alt + F4To close all opened workbooks, press Alt + F4....
PressControl + Command + Space (This opens the Character Viewer) In the search box, type:greater than or equal Double-click the≥symbol to insert Option 2: Use AutoReplace (in Word for Mac) If you’re using Microsoft Word for Mac, you can set up an AutoCorrect rule just like in Windo...
Excel - File Password Excel - File Share Excel - Emoji & Symbols Excel - Context Help Excel - Insert Data Excel - Select Data Excel - Delete Data Excel - Move Data Excel - Rows & Columns Excel - Copy & Paste Excel - Find & Replace Excel - Spell Check Excel - Zoom In-Out Excel -...
F4: Repeat the last command or action. F7: Check the spelling F9: Calculate all worksheets in all open workbooks F10: Turnkey tips on or off F11: Create a bar chart based on selected data (on a separate sheet) F12: Open the Save As dialog box Shortcuts for moving around in ...
The command fills the rest of the range. Read More:How to Drag Formula and Ignore Hidden Cells in Excel Method 6 – Using the Table Feature to Drag Formula in Excel Steps: Select the entire dataset. Go to theInserttab and selectTable. ...
Redo the most recently undone command. CTRL+Y Find text. CTRL+F Switch between hiding and showing gridlines. CTRL+SHIFT+G Create a hyperlink for a selection or edit an existing hyperlink. CTRL+L Insert an image. ALT+CTRL+I Insert a table. ALT+SHIFT+T Insert a row in a table...
To use one of these combinations Hold the Command (Apple) key down and strike the letter key Less commonly used keyboard combinations (Note: To save space below, the control key is indicated by Ctrl) Assignment Leave your browser window open. Open Microsoft Excel, if it is not already open...