Calc: Add Data to Multiple Sheets

Posted June 13, 2007 by Rob Rogers in Windows

When working with spreadsheets, there is often a situation that requires the same data, text, and/or formulas to be placed on separate sheets. Examples of this would be a list of employees or formulas for monthly calculations. If you need the same data, text, and/or formulas to be on multiple sheets of your document, you can accomplish this by following these steps.

1. Select one of the sheets that will contain the data, text, or formulas by selecting its corresponding tab at the bottom of the spreadsheet.

2. Hold down the Ctrl key and select the individual sheets tabs for the sheets that are to contain the data, text, and/or formulas. You can also use the Shift key if the desired sheet tabs are next to each other (sequentially placed). The tabs will turn white on the selected tabs.

3. Paste the data, text, and/or formulas that is to be placed on the sheets onto the initially selected sheet.

4. When finished, hold down the Shift key and select the initially selected tab and the tabs of the previously selected sheets will turn back to gray.


About Rob Rogers

Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers

The Conversation

Follow the reactions below and share your own thoughts.

Leave a Reply