Microsoft Excel is a very powerful application for spreadsheet processing and a pretty old one, its first version emerged as early as in 1984. Each new version of Excel came with more and more new shortcuts and seeing the full list (over 200!) you may feel a bit intimidated. Show Don't panic! 20 or 30 keyboard shortcuts will absolutely suffice for everyday work; while others are purposed for highly specific tasks such as writing VBA macros, outlining data, managing PivotTables, recalculating big workbooks, etc. I've put together a list of the most frequent shortcuts below. Also, you can download top 30 Excel shortcuts as a pdf file. If you want to re-arrange the shortcuts to your liking or extend the list, then download the original workbook. Must-have Excel shortcuts no workbook can do withoutI know, I know, these are basic shortcuts and most of you are comfortable with them. Still, let me write them down again for beginners. Note for newbies: The plus sign "+" means the keys should be pressed simultaneously. The Ctrl and Alt keys are located on the bottom left and bottom right sides of most keyboards.
Formatting data
Working with formulas
Navigating and viewing data
Entering data
Selecting data
You may also be interested inWhat is the shortcut key for VLOOKUP?Working with formulas. Is VLOOKUP like Ctrl F?Re: What is the differenec between vlookup and Ctrl+F? vLookup is when you writing macros and manipulating formulae. Ctr+F is when you looking (Find and Replace), which can be used to search in all workbooks. Checkout Excel Help!
How do I turn on VLOOKUP in Excel?In the Formula Bar, type =VLOOKUP().. In the parentheses, enter your lookup value, followed by a comma. ... . Enter your table array or lookup table, the range of data you want to search, and a comma: (H2,B3:F25,. Enter column index number. ... . Enter the range lookup value, either TRUE or FALSE.. What does F4 do in Excel VLOOKUP?When you select a cell or range in a given formula, you can use the F4 key to cycle through the various combinations to absolute and relative reference. You can also use the F4 function key to lock a cell reference.
|