Delete two columns with formula

G

Guest

I need to delete 2 columns (with formula) and only display the last two
columns.

When I delete the first 2 columns, the last two columns display #REF!.

I know I can copy the info I need to a new sheet and paste special the
value. Is there a way to fix this on the current sheet I am working on.

Thanks.
 
G

Gordon

ED said:
I need to delete 2 columns (with formula) and only display the last two
columns.

When I delete the first 2 columns, the last two columns display #REF!.

I know I can copy the info I need to a new sheet and paste special the
value. Is there a way to fix this on the current sheet I am working on.

Thanks.


Well obviously the last two columns contain references to the two columns
that you delete. You need to either remove the references to the columns
that you want to delete, or, more simply, just hide them.
 
G

Guest

Ed
The last 2 columns are probably displaying #REF because they have formulas
in them that depend on values in the 2 columns that you are deleting. You
need to either keep the first 2 columns (hide them if you want) or copy-paste
special-values the last 2 columns (right over the top of the existing
formulas if you want).
Will
 

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

Top