How do I copy a reference formula onto multiple worksheets

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

Guest

While attempting to do this, the formula on the top worksheet creates the
proper formula. However the other sheets chosen enters the reference formula
as a text. I have tried everything I can think of to reformat those cells to
a value. Nothing, so far works.
 
Hi,

(1) Check that the other sheets aren't in formula view mode. Ctrl+` to
enter/exit mode.

(2) Do a text to columns on the columns that you are attempting to put the
formula in, use delimited and use an unlikely delimiter such as ~.

(3) Make sure the formula is suffixed with =, make sure it's not suffixed
with '.

(4) Make sure that the cell is appropiately formatted: Format -> Cells /
Number -> General.

Something in this list should make it work???

Good luck,
A
 
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

How do I reference a worksheet name through a formula? 3
Worksheet relative reference 3
Linking Totals Across Multiple Worksheets 2
How to Auto Reference Worksheet Tab ID's in Formulas? 9
Absolute References and worksheets 0
How do I reference a cell to another in the preceding worksheet 8
Copying a formula to multiple worksheets 1
how do i copy the result of a formula into another worksheet as te 3

Back
Top