Skip to content Skip to bottom

How to autofill, undo and redo data in Microsoft Excel

Microsoft Tips

This video, delivered by our Microsoft Certified training expert, provides a quick tutorial on how to autofill, undo or redo your data.



The ‘autofill’ function is a very useful tool within Microsoft Excel, it allows you to automatically enter data. So, if you need to populate a lengthy table with data series, then the ‘autofill’ function will prove to be very helpful. What’s great about autofill, is that you can use this function with almost any data set, for numbers and for words. This video also discusses how to undo and redo any edits in your worksheet.

Here are some useful shortcuts on your keyboard to easily undo, redo, copy and paste your work.

  • Ctrl and Y to redo an action
  • Ctrl and Z to undo an action
  • Ctrl and C to copy data
  • Ctrl and V to paste data

If you would like to learn more about other features and functionality within Microsoft Excel, then head over to our YouTube. We have a channel of videos called Microsoft Excel for beginners, here you will find lots of quick intuitive tutorials to help you master Excel. All of our videos are delivered by a Microsoft Certified expert.


Fill your digital skills gap

The digital skills gap in the UK is worryingly growing. There are millions of UK workers who lack the basic digital skills needed to fully participate and stay productive in the digital working world.

Microsoft 365 and it’s suite of productivity apps such as Word, Excel, PowerPoint, Outlook, SharePoint, and Microsoft Teams, are essential to the successful running of hundreds of thousands of businesses across the world. But knowing how to fully utilise the features within these applications is where so many businesses are struggling. Basic IT skills can improve productivity, collaboration and help your business gain a competitive advantage.

The 848 Group is a Microsoft Gold Partner with a team of Microsoft Certified IT professionals. Our experts hold the knowledge, skills, and experience to help close the digital skills gap in your business. We have a range of Microsoft 365 training courses designed to meet varying end user capabilities.

Choose from a range of introductory courses that help you learn the essentials, or level up your Microsoft skills with an advanced course. Course timelines are flexible, with bitesize classes to full day sessions available.

Find out more about our training courses here!