- 2,225,894 hits
- Follow wmfexcel on WordPress.com
Want Google to translate this page?
Top Posts & Pages
- When unhide row doesn't work...
- How to sort bar chart in descending order?
- Show number in thousand (k) or in million (M) by using custom format
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Perform VLOOKUP with 2 lookup values
- Insert a text string into a specific position of another text string in #Excel
- Filter a list of items from a long long list
- Dropdown calendar in Excel
- Have you encountered any weird formula in #Excel?
- Open an embedded Excel file during a slide show in PowerPoint?
My YouTube Channel
- My Tweets
Tag Archives: Keyboard Shortcut
Following the techniques used in the previous post , we can perform many Excel magics for different scenarios. On top of my mind is to replace blank cells with zero. The first task is to select all blank cells in … Continue reading
Guess what? We are going to do it with a sequence of keyboard shortcuts only. Believe it or not, it requires only 8 key strokes: Ctrl+A => Ctrl+G => Alt+S => k => Enter => Ctrl+- (minus sign) => r … Continue reading
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
Did you spend too much time to move cells so that there are no blank cells in each column? Again, a picture tells thousand words. Here’s the task… Would you do it this way? Or this way? What did I do … 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
If you think Ctrl+A does merely Select All, then you are likely not using it frequently. Let’s me take you through how to boost your efficiency working with Excel with Ctrl+A under different situations.
… Ctrl+D or Ctrl+R is ready to help 🙂 Ctrl+Enter is one of my favorite shortcuts. It helps me to input a value or a formula to a range simultaneously. As usual, Ctrl+Enter won’t let me down. But many times, … Continue reading
This key is sitting on the keyboard forever. I wonder how many people have ever pressed it? Maybe you don’t even know where the key is on keyboard… do you? It is between “Windows” and “Ctrl”, just two keys below … Continue reading
The shortest post ever! 🙂
“Copy and Paste Value” is probably one of the most popular actions taken by many people every day. A probably fastest way to do so is definitely worth sharing. I learn this from a comment to the post (http://www.myonlinetraininghub.com/favourite-excel-shortcuts) by MYNDA TREACY … Continue reading