[Affiliate]
Blog Stats
- 3,268,929 hits
-
Join 3,244 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Dropdown calendar in Excel
- Perform VLOOKUP with 2 lookup values
- About
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Calculate number of "*day" in a given period
- =SUM('???'!C3) Is it a valid formula?? No. It is magical indeed!
- Bug with copy and paste in Excel Table
- Time Conversion - How to convert 24hr input as 4-digit number into TIME in Excel?
- Sequential number for visible rows only
- The amazing SUMPRODUCT
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: QAT
Customize Alt 1 to 4 to become the favorite #Excel shortcuts of your own
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
Create your own favorite keyboard shortcuts in #Excel without VBA
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
Copy customized Ribbon and QAT to another PC
Customized Ribbon and QAT is very common. I believe all serious Excel users will have their own customized Ribbon and QAT according to their own working habits. I rarely share my customization with others and I am not going to … Continue reading
First thing to do when switching from Excel 2003 to 2007/2010
is to know where are the old menus and toolbar icons!!! I guess there are still a lot of of Excel 2003 users in Hong Kong, mainly in workplaces. No idea if it is also common in other cities. There are … Continue reading



