Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!


Green Marks inside Excel cells

A visitor asked

I have refined the spreadsheet you done earlier so that each meal calculates the percentage of fats, carbohydrates, and proteins.  It also does the same for the totals at the end of the day.  But I notice there are green marks inside some of the bottom cells.  Why?

Updated- Read more about the green triangles in Excel and how to remove, use and customise them.

These are some error checks that have been built into Excel. If you hover over the green mark and click on the drop down that appears it will say something like “Inconsistent Formula”. This means that Excel has identified that the cells in this area have a common structure and this cell is different. It does not mean that it is wrong, it is just a warning.

You can switch this feature on and off in the Options sections.

Below how you can use them to convert numbers that Excel confuses as text back into numbers


Edit with arrows keys not working in Conditional Formatting