View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Janis Janis is offline
external usenet poster
 
Posts: 360
Default can't insert a column, can't shift columns off the sheet.

I have some week ending utilization figures in columns, for example 5/19,
6/1, 6/9, 6/16,6/23 & 6/30 and a 6 week average column.
The columns are z, aa, ab, ac, ad, & ae with af being the 6 week average.
I have to add a column but when I do insert-- column I get the error
"cannot shift objects off the sheet".

So I thought that inserting a column between ae and af I would get the error
because of the formula in af. But I thought I would try inserting a column
at the beginning and moving it to AE but I can't insert any columns. I get
the error message I can't insert and there are plenty of columns left in the
sheet I'm only using up to AK.

tia,