Use the Action Recorder in Excel to record your actions as scripts to replay whenever you want. The Action Recorder creates a script based on your changes to a workbook. These actions can include entering text or numbers, formatting cells, rows, or columns, creating Excel tables, and so on. More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.