As a newcomer to Excel, I may not be as good as everyone, but I have been learning. I have accumulated experience and hope to help you solve practical problems in your work.
1. Data change amount without reason
This problem has been encountered by many colleagues. After the excellent Excel document is opened, the numbers in it become the accounting amount or the euro format. In fact, this is a sequel to using a custom format in the worksheet.
Solution： Press to open 【Set Cell Format】–【Digital】–【Custom】– Delete all the format codes that can be deleted on the right side, save the file and open it again, there is no problem.
2. Quickly copy the format to other charts
How to quickly apply a chart effect to another chart? Click on the selected chart – copy – click on the chart to apply the style – paste-and-format – confirm
3. Annotation quick reset
Many colleagues are used to inserting annotations into cells to mark and describe the data. But sometimes the position of the annotation will be confused, and some even go out of sight.
How do I get the wrong annotations back to the default location? Select all the worksheet – copy in new worksheet — paste in the new worksheet, then, there is no more.
