Other useful shortcut keys Frequently used shortcuts This table lists the most frequently used shortcuts in Excel. To do this Press Close a workbook. Ctrl+W Open a workbook. Ctrl+O Go to the Home tab. Alt+H Save a workbook. Ctrl+S Copy selection. Ctrl+C Paste selection. Ctrl+V Und...
1.12 Create Chart in New Worksheet: F11Select your dataset, and press F11 to create a chart in a new worksheet.Note: For Mac users, press Function (Fn) + F11.1.13 Toggle AutoFilter: Ctrl + Shift + LSelect the data range, i.e. B4:C10 and press Ctrl + Shift + L and access the ...
Move to next ribbon controlTab Shortcut for Tables and Filters in Excel Activate filterAlt+? Clear slicer filterAlt+C Insert tableCtrl+T Select tableCtrl+A Select table columnCtrl+Space Select table rowShift+Space Toggle AutofilterCtrl+Shift+L ...
If we scroll down, the headers will remain in the same place. Read More: How to Freeze Multiple Panes in Excel Method 3 – Freeze the First Column with the Keyboard Shortcut STEPS: Use the keyboard shortcut Alt + W + F to open the Freeze Panes menu bar. To lock the first column,...
ShortcutWindowsMacWeb Activate next cell in selected range (based on direction set in Excel Options)EnterReturnEnter Activate next cell to right/below in selected rangeTabTabTab Activate each corner cell in selected range in clockwise directionCtrl+.Ctrl+.Ctrl+. ...
Keyboard shortcut for autofill in Excel If AutoFill isn’t familiar to you, you could benefit greatly from our free Basic Skills E-book, which will show you the basics of Excel formulas, functions and AutoFill. If you use AutoFill often, you’re probably used to double-clicking on the ...
This article includes some of the more common business-specific shortcuts. Be aware that the shortcuts might differ in your solution. In the user interface, the tooltip for an action shows the keyboard shortcut to use.General keyboard shortcuts...
That’s why I have listed only the 82 most important keyboard shortcuts that you can learn and use easily. If somehow you are not able to find a keyboard shortcut for the option that you use frequently in your work, you can use the following method to find it. ...
General Excel Shortcuts What it Does?Windows Shortcut Opens HelpF1 Repeats the last command or actionCtrl + Y Repeats the Last ActionF4 UndoCtrl + Z Spell CheckF7 Apply Data FilterCtrl + Shift + L Activate Filter (when the cell with filter is selected)Alt + ↓ ...
If you are not equipped with the necessary tools and techniques, it is quite hard to work on Microsoft Excel. This is especially true when you have a lot