Forum Discussion
AutoSum not working
The screenshot that Haytham posted seems to indicate that clicking the Data ribbon gives you an option to change the cell format. This is misleading. Instead, you can either (a) select the range of cells and click the Home ribbon to find the indicated format cells dropdown list or (b) select the range of cells then right-click the range and select Format (near the bottom). Finally, apply either General format or the relevant number format.
Hi Deleted,
I hope you next time to choose more appropriate terms because the term (misleading) is often used for deceptive and intended fraud.
The polite term that you should say is that the screenshot might not be clear enough!
Although I think it is clear enough because all Excel users are supposed to know that selected ribbon tab in the screenshot is the Home tab because it's popular, mostly used, and it's the first tab that appears to the user when he opens Excel.
Regards
- mlshuntMar 09, 2022Copper Contributor
Not to be rude, but I too could not follow the screen-shot. I am still having this problem and it is very frustrating.
- John_01Mar 10, 2022Copper Contributor
Don't worry about thinking you might be rude. I agree with you that what I posted was very cryptic and very difficult to understand. I was tired of trying to figure it out and ran out of energy to make it understandable. When I have some time I'll give it another go.
John
- LorraineJ_FCJul 11, 2020Copper Contributor
There is a difference between misleading information and intentionally misleading information. A picture /screenshot/description may be misleading without being intentionally misleading. Only intentionally misleading is fraud. This is not a court, social media, or a financial statement. Misleading is not an accusation but merely indicating that the information displayed will confuse somebody who is stressed and in a hurry to sort a problem out. It is to help you to in future be more careful of the screenshot.
- DeletedMay 29, 2019good lord you're an **bleep**