what is the formula for changing the same cell on different sheet.

S

scotty

i want to change the same cell on many sheets in one go can anyone give me
the formula for this
 
A

Alan Beban

scotty said:
i want to change the same cell on many sheets in one go can anyone give me
the formula for this
Click to expand...
Select all the sheets; then insert the formula in the appropriate cell
in the active sheet.

Alan Beban
 
A

Alan

No need for a formula, as Alan Beban advised, hold down the shift key and
select all the sheets, then enter whatever in F5
 
S

scotty

many thanks will try that

Alan said:
No need for a formula, as Alan Beban advised, hold down the shift key and
select all the sheets, then enter whatever in F5
Click to expand...
 

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

Autonumber field in Excel that behaves the same as Access 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Excel - Wich Function should I use? 1
Copy addition formula of non-consecutive horizontal cells 2
Creating a template that I can reproduce every month by keying ininformation from SAP 8
Dragging a formula down isn't working - where am I going wrong? 1
Is there a function to count how many times a cells value is used? 0
Converting a number into a cell reference 2

Top