[Affiliate]
Blog Stats
- 3,191,141 hits
-
Join 3,265 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- How to sort bar chart in descending order?
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- How to replace value with a value from another column in Power Query
- Show number in thousand (k) or in million (M) by using custom format
- Open an embedded Excel file during a slide show in PowerPoint?
- Highlight weekends and holidays using Conditional Formatting in #Excel
- Lovely stickers in #Excel 365
- The INDIRECT trick of using Structured Reference in Conditional Formatting
- Case-insensitive SUBSTITUTE???...
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Go to special
Highlight different cells in two lists in #Excel
Finding and highlighting differences should be a common task in Excel. Most of the time, it’s solved by formula or conditional formatting. Either way, we need to construct a simple formula like the one below to compare the cell contents … Continue reading
Replace blanks with zero in #Excel
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
Posted in Excel Tips
Tagged Ctrl Enter, Find and Replace, Go to special, Keyboard Shortcut
Leave a comment
Unstack data across columns with #Excel Pivot Table
Another commonly seen problem in daily work. Many hours are spent on reshaping data, we all know that. Nevertheless, if you are good in Excel, doing this task is not difficult at all. Indeed, there are many ways to solve … Continue reading
Go to Special + Copy and Paste do the magic
Answer to the 5 little Tips (tests) – Part 4/5 The task: To convert “1” to “Tick” in a table like the following one: Answer: Copy and Paste with a simple trick … What? Not Find and Replace? Yes, you may do it by using … Continue reading
Move cells with data to the top
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
F5 – It is the key I rarely press
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
Posted in Shortcut
Tagged FIND, Find and Replace, Function Keys, Go To, Go to special
Leave a comment
Fill in the blanks – quickly
How to fill up all the blank cells in a Table in less than 1 minute??? The table on the left is a typical output from Pivot Table. The blank cells help to make the table more “reading-friendly”. However they … Continue reading
Quickly highlight the differences in two columns – Go to Special
There are many ways to find out the cells in column B which are different from the cells in column A, e.g. using Conditional Formatting, Using formula in column C. These methods require some knowledge in Formula. Nevertheless, It could … Continue reading
Another useful tips with Go to Special – Visible cells only
This is an extension of the previous post that talks about Go to Special -> Visible cells only Apart from Copy ONLY unhidden rows/columns, another situation we used to run into is probably deleting or modifying hidden cells unintentionally. Sound … Continue reading
How to copy visible cells only?? – GO TO SPECIAL: visible cells only
Have you run into a situation that you wanted to copy a table, like the one below, to a new worksheet. However the Table “expanded” automatically… All the information from the hidden rows and columns reappears. What??? A simple trick … Continue reading
wmfexcel 