Russian Doll, image credit pixabay/JackMac34 There are many times when we need to create spreadsheets that have the same titles and even the same calculations in the exact same place. Many of us use the wonderful copy and paste. I want to introduce you to the simultaneous creation of data in several sheets. This feature can not only create the same data for you but you can use it to calculate across many sheets too.

Here is an example of what we need.

This example is for a second hand car dealership with several locations. They only sell a few models. The dealership has venues in several towns. Luton, Glasgow, Liverpool and Exeter. To create the first sheet then to copy and paste into the subsequent sheets is a little time consuming.

  • Start by naming the sheets with the names of the towns and a final one name TOTAL.

sheet names

  • You are in the last sheet TOTAL as that is the one you named last. Hold down the SHIFT key.
  • Select the first sheet Luton.
  • Let go of the SHIFT key.

The five sheets are grouped together. They all have white tab names.Grouped

Look up at the centre of the window at the name of your file and you will notice that there is [GROUP] at the end of the name. This indicates that there are grouped sheets in this file.

  • Create the sheet as the example above.

As you type the information is simultaneously created in all of the grouped sheets.

How to Ungroup sheets.

There are two ways to do this.

  1. Right mouse click on one of the tabs at the bottom. i.e. TOTAL, and a list appears. ungroup list
  • At the very bottom you’ll find Ungroup Sheets.
  1. Create another sheet that you don’t need to fill with any information but can use just to select it to ungroup. Extra sheet

Now that you have ungrouped the sheets you can fill in the appropriate information in each and then total up the figures in the TOTAL sheet.

Using the Keyboard to access tabs in Windows.

Tips – How to protect parts of your spreadsheet

Need to change the data in a cell from lots of characters to just a few?


Please enter your comment!
Please enter your name here