How to Make a Single Formula Apply to Every Page

  • Thread starter Thread starter R Bolling
  • Start date Start date
R

R Bolling

Not using a header or footer, how is it possible to apply a formula to
Cell A1 of every sheet in the workbook.

For Example: I want to see the sheet name in cell A1 of every sheet
in the workbook, so in add the formula to Sheet1, Cell A1:

=MID(CELL("filename"),A16),FIND("]",CELL("filename"),A16))+1,99)

How do I duplicate this formula on every active page of the workbook
without having to do a lot of cutting and pasting.

If I wanted to add this to the Header instead of a cell, how would I
do that?

Thanks for any help

Robbie Bollinger
 
Robbie,

You can "Group Edit" in Excel by selecting multiple worksheets at the same
time. Here's how:

Simply hold down the CONTROL key and select the desired sheet tabs that
should be "grouped". Then simply enter your formula in the cell you want. It
will automatically be entered in all selected worksheets..... also works for
formatting. Right-click the sheet tabs to stop Group Editting. Note that
holding the SHIFT key instead will select all contiguous sheets from the
active to the selected....

As far as headers... I am afraid that they aren't too flexible... you should
look at Print Titles (File | Page Setup -- Sheet tab).....
 
Back
Top