Changing a Formula

  • Thread starter Thread starter Skip
  • Start date Start date
S

Skip

In my workshhet I add three columns. I would like to delete one of the
columns in a new worksheet. And add only two of the three.
I know I can delete a colum, but in the formula all three cloumns
remain. Is there a way I can delete that column from the formula ,
without editing each formula one by one?
Thanks
 
if you highlite the range for the formula, type in the formula once,
then hit Ctrl Enter, this will enter the formula in all the highlited
cells and will reference accordingly
 

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

using the =page! feature to transpose a row to column 0
#REF! 1
Lock in formulas 2
Need Formula to "Adjust" to New Column Assignment 3
Excel Help to copy information from one row at a time to another sheet 1
Moving cells without changing their formulas 3
How Do I Find Different Values In A String? 2
Lookup formula of some sort 4

Back
Top