G
Guest
Hi,
I plan the newsletters I publish using a large excel planning sheet. This
sheet consists of many sections of grouped columns – one group per issue.
My manager has asked me to insert new columns into each group in order that
we can track how many billable hours we spend on each article.
Problem; if I try to insert a column into any section of grouped cells I get
the following error message:
“To prevent possible loss of data Microsoft Excel cannot shift non-blank
cells off the worksheet.
Try to locate the last nonblank cells by pressing CTRL+END…â€
The only solution I can find seems to suggest that I delete all the data to
the right of the point where I want to insert the new columns. I don’t really
want to junk hours or work just to insert two columns.
Does anyone know a better fix? Any tips and hits gratefully received.
Many Thanks
Karl
I plan the newsletters I publish using a large excel planning sheet. This
sheet consists of many sections of grouped columns – one group per issue.
My manager has asked me to insert new columns into each group in order that
we can track how many billable hours we spend on each article.
Problem; if I try to insert a column into any section of grouped cells I get
the following error message:
“To prevent possible loss of data Microsoft Excel cannot shift non-blank
cells off the worksheet.
Try to locate the last nonblank cells by pressing CTRL+END…â€
The only solution I can find seems to suggest that I delete all the data to
the right of the point where I want to insert the new columns. I don’t really
want to junk hours or work just to insert two columns.
Does anyone know a better fix? Any tips and hits gratefully received.
Many Thanks
Karl