Chancing Excel worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Chancing Excel worksheet

I have 240 filled excel worksheets. I need to change 1 formula over 1 cell.
I can open 1 by 1 and chance de formula. I will appreciate if some one could
help me to do it automatically.
 
If the formula you wish to change is the same cell or range of cells in all
the sheets, you can select all the sheets (shift and click to select a
contiguous range of sheets, or Ctrl and click to select a non-contiguous
range of sheets), and make your change once, and it will automatically be
made on all the sheets you selected.

Hope this helps,

Keith
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Open Specific Worksheet Using Button Form Control in Excel 0
Need Macro... 8
Using Offset on two seperate worksheet 1
Converting from 123 to Excel 7
Counting multiple memberships 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top