Microsoft has announced a major new feature for Excel users on Windows and Mac. Excel for Windows and Mac now comes with a new Automation tab to help you tackle repetitive tasks. With this new feature, you can automate repetitive worksheet tasks without any programming experience.
The new Automation tab was previously available to Excel Web users, so many of you already know how it works. But if this sounds all new to you, in the Automation tab you'll find a new option called "Record Actions" which helps you save recorded actions into a script, You can run this script on any workbook at any time. However, the action recorder is in preview, so don't expect it to handle all actions perfectly.
Microsoft warns that the new worksheet actions don't work for all actions right now. However, the tech company said it will add support to increase the number of actions that can be logged. It also encourages users to try to record as many actions as possible, and based on usage share, Microsoft will prioritize which actions are recorded first.
If you are running Excel on a Mac or Windows PC, you need to check that you meet the prerequisites to check out the new Automation tab. You will need the following to automate repetitive tasks.
Microsoft also released a video showing how the new Record Actions option works in the real world. The video is a little over two minutes long and covers everything you need to know before trying it.
The above is the detailed content of Microsoft Excel gets Action Recorder to help you handle repetitive tasks. For more information, please follow other related articles on the PHP Chinese website!