1. Assume you have a chart like below and you want to hide Field Buttons (the ones highlighted in red)
2. Click at the chart. Then go to Analyze → Field Buttons → select Hide All
3. Done! All the field buttons are now hidden
Advanced Filter
It is used to filter selected range but works differently from Filter command. It displays the Adv ...
Format Number in Thousand or Million
Thousand #0.00, Million #0.00,, 1 comma stands for thousand. 2 commas stand for million. 0.00, ...
HowTo Select A Worksheet in A Workbook with Many Worksheets
Too many worksheets? Tired of using scroll left and right? Too bad if you cannot reduce worksheets ...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment