In this lesson, we will learn how to edit multiple sheets in Excel simultaneously.
First, insert multiple sheets in Excel that you want to edit together and add the same information to them using one sheet only.
Then go to the first page “Sheet1” and right-click on it. Then, from the menu that will appear, choose “Select All Sheets”.
You will see how all sheets are selected.
Now if we create a table of the days of the week and a set of numbers on the first sheet “Sheet1”.
When you navigate between pages, you will find that the same information has been added to other pages. In this way we could save the time to copy and past the same information to every sheet in excel.
Dear reader, if you liked the article, do not forget to subscribe to our YouTube channel, which provides all new in the field of technical and completely free training courses.
You can also browse our website to access the blog and read technical topics, or learn about the training courses offered by the site.
To access the full course “Excel Course” on YouTube, click here.
