How to Select Multiple Sheets in Excel

Excel worksheets are a fantastic tool.

Rate: (0 Ratings)

Excel spreadsheets are extremely efficient and cut your work down immensely, IF you know what you are doing and are able to utilize all of the functions that it offers. Many times you will be required to work with multiple worksheets and you will have to know what to do when faced with that challenge.

Flag Article

Instructions

Difficulty: Moderately Easy

Step1

Enter all of your data in multiple worksheets at the same time. To do this click the Ctrl key, start a new blank worksheet in Excel, press and hold the Ctrl key and click sheet 1,2,3, etc. Click cell A1 on the first page and begin typing. You will then find the same information on the following pages.

Step2

Find the sum by using a simple formula. Start a new Excel sheet, in cell B3 in Sheet 1, type 20, in cell B3 in both Sheet 2 and Sheet 3, type 30, in cell A1 in Sheet 1, type the following formula:
=SUM(Sheet1:Sheet3!B3). Press ENTER. See that cell A1 displays 80, which is the total sum of the cells in the three worksheets.

Step3

Check your spelling in multiple worksheets. Start a blank new worksheet in Excel. In cell A1 type anything that you want. Do the same for the following sheets. Press and hold the SHIFT key, and then click Sheet1, Sheet2, and Sheet3. On the Tools menu, click Spelling.

Step4

Name the worksheets. Start a blank new worksheet in Excel. Add a command button to the worksheet: Select Sheet1, on the View menu, point to Toolbars, and then click Control Toolbox, click the Command Button, click somewhere on the worksheet to insert the command button, and then click and drag the borders of the command button to size it.

Step5

Right-click the command button, and then click View Code on the shortcut menu. Enter the following code between the Private Sub Command Button1 statement and the End Sub statement: Set NewSheet = Sheets. Add(Type:=xlWorksheet)
For i = 1 To Sheets.Count
NewSheet. Cells(i, 1).Value = Sheets(i).Name
Next i

Tips & Warnings

Just take your time and familiarize yourself with the various functions that Excel offers. At times it may seem a bit overwhelming but be assured it is well worth the efforts.