Spreadsheets

Unit 1: Introducing the Spreadsheet

Lesson 2: Entering Data

How do you select multiple worksheets?
How do you enter data on multiple worksheets?

Certain actions are performed on the selected worksheet. For example, if you select Print or Print Preview, or enter data, the action is performed on the selected worksheet. If multiple worksheets are selected, these actions are performed on each worksheet that is selected. To select:

• One sheet–click the tab for that sheet.

• Two or more adjacent sheets–select the first in the series and then while holding the Shift key down select the last in the series.

• Two or more non-adjacent sheets–select the first worksheet and then while holding the Ctrl key down select the others.

• All sheets in the workbook–right-click on one of the worksheet tabs and then choose Select All Sheets.

The following animation shows the interest rate being changed on all worksheets simultaneously.