When editing Excel spreadsheet, you can hardly avoid entering a series of similar data, like departments in company, product ID, e-mail address, etc. Some of them are almost the same, just a little difference in the begging or ending, but you still need to input them completely over and over, which is quite exhausting. In fact, you can do it smarter by customizing a template in Format Cells.

For example, if you are making an information sheet of company staff, there are so much similar text you shall enter in Excel, like the department of each employee. To save the time and effort, you can make a basic template at first.

The fixed content that will repeat in each cell should be enclosed in quotation marks, and @ refers to the content that you want to manually input every time.