- 1,923,322 hits
- Follow wmfexcel on WordPress.com
Want Google to translate this page?
Top Posts & Pages
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Show number in thousand (k) or in million (M) by using custom format
- When unhide row doesn't work...
- Insert a text string into a specific position of another text string in #Excel
- How to sort bar chart in descending order?
- 2D SUMIF with two variables – one on column and one on row
- Perform VLOOKUP with 2 lookup values
- Sequential number for visible rows only
- Open an embedded Excel file during a slide show in PowerPoint?
- Dropdown calendar in Excel
My YouTube Channel
- My Tweets
Category Archives: Shortcut
It’s not uncommon to insert a date stamp or time stamp on a spreadsheet. We may use the following functions to get the results easily: =TODAY() ‘to get the date of today =NOW() ‘to get both the date of today … Continue reading
Do you know how many keyboard shortcuts we have in Excel? Honestly, I don’t know. I just know the shortcuts that I need to use. Believe it or not, from Ctrl+ A to Z, I use them all but M, … Continue reading
When talking about keyboard shortcuts, there is always discussion on what’s the most time-saving shortcuts, what are the top X shortcuts you should learn, what is the most frequently used shortcuts, etc… Just to name a few, Ctrl+S to save, … Continue reading
Make better use of the Quick Access Toolbar (QAT) We all know that shortcuts could save us lots of time when working with Excel. Excel has many built-in shortcuts. Ctrl+C, Ctrl+V should be the most popular and commonly used … Continue reading
Alt+↓ is absolutely one of my frequently used shortcuts when using Excel. What it does? “Open sesame” under four common circumstances. 🙂 When you are at the bottom of a column Alt+↓ displays the list of items on the column. … Continue reading
Why is F12 for the things that matter? Because it basically performs one crucial action: SAVE. F12 alone – Save as (Alt+F2 does the same) Ctrl+F12 – Save as (same as F12 alone) Shift+F12 – Save (Ctrl+S does the same … Continue reading
F11 key should be the most-hit key for those who use Marco or VBA a lot in Excel. If you use F11 but do not work with VBA at all, then you must have inserted new (blank / chart) sheet very … Continue reading
Out of the following combinations for F10, I find one of them really useful. Wanna guess which one? Let’s take a quick look at what F10 does: F10 alone – Shows the shortcut key for the commands on the Ribbon … Continue reading
When you think your Excel is not calculating… Stay Calm and Press F9. I have to admit that I did not know about “Manual Calculation” mode in Excel long long time ago. I still remember how stupid I was when … Continue reading
In the introductory post of Function Keys, I used F8 as an example to illustrate the situation when we thought we know English but cannot comprehend a sentence. F8: Turns extend mode on or off. In extend mode, Extended Selection appears in the … Continue reading
If you do not spell very well and your boss pays attention to spelling, please make sure you press F7 before sending your Excel reports. Otherwise, your boss may challenge your spelling instead of your analysis. 🙂 F7 key is … Continue reading
If you never work with mouse for your Excel work, I believe your are a true master in using F6. If you use both mouse and keyboard like most people do, you may probably know little about F6. However if one … Continue reading
The working combinations for F5. F5 alone – Open the Go To Dialog box Ctrl+F5 – restore the window size of the selected workbook Shift+F5 – Open Find (and Replace) Alt+F5 – Refresh Pivot Table Ctrl+Alt+F5 – Refresh All Nevertheless, … Continue reading
Two years ago, I wrote two posts about using F4. How to switch between Absolute and Relative reference? F4 Another use of F4 – Repeat LAST action Honestly, these were the only two ways I know about F4 by that time. Now … Continue reading
F3 key can be used with the following combinations: Ctrl+Shift+F3 – Create Names from Selection Ctrl+F3 – Open Name Manager F3 alone – Paste Name Shift+F3 – Open Insert Function dialog box As you see, F3 is mainly used for … Continue reading
Among the F1-F12 keys, I use F2 most often. Why? Because it helps me edit cell contents quickly. On the other hand, F2 is extremely helpful when I try to edit cell reference in chart or revising reference in Name manager. … Continue reading
This is the first post of the Function Keys series. Why F1 is the must-know key for self-learner? Because it takes you to Excel Help! 🙂 Literally, the F1 key serves the following in Excel: F1 alone – Open “Need … Continue reading
F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 F11 F12 F1 to F12 are always sitting on the keyboard quietly. How often do you use them? In the era of Google, you may find what you need by simply … Continue reading