Help need for excel sheet problem

Asked By sanjeewa 0 points N/A Posted on - 06/19/2012

I have excel work books with about 200 sheets. I want to apply same formulas to every sheet .Is there a way to do it at the same time. please help.

• Status: Open
• Question Views: 806
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Sherin Viluel

Go To Solution

Answered By vibhuti 0 points N/A #161658

Help need for excel sheet problem

Hold down the Shift key from your keyboard and then go to the last sheet of your file. Click into it while continuously holding the Shift key.The bar on top will be renamed to spreadsheet(book1) & [GROUP].

Any formula that you put on any sheet when you sort it in group mode will also be applied on the entire sheet.

Let us take an example:

If you inserted a formula in cell B2 under your sheet 1, this formula will also be put on all the sheet that you grouped. To ungroup the sheets, right-click on every sheet and then click Ungroup Sheets.

 

 

About vibhuti

Questions
1

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/19/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Sherin Viluel 0 points N/A #161659

Help need for excel sheet problem

 

If you want to apply the same formulas to every sheet in a work book, you are able to follow the below method. However, the formulas will be applied in the same cell in the every work sheet.

First you have to make sure that any of work sheet has not been previously protected. Because if any of work sheet has been protected you will not be able to apply formulas to every sheet. This is the way

Right click on a sheet name and click on the “Select all sheets” as follows.

 

 

 

Then type the formula that you want to type in a cell.

(Sheet 8 in the following image)

 

 

 

Now you can see the same formula in every work sheet.

(Sheet 11 in the following image)

 

 

About Sherin Viluel

Questions
0

Answers
50

Best Answers
37

• Vote Up 0 Vote Down

• Posted on - 06/20/2012
• Question Category: MS Excel