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 dont 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

An Excel Spreadsheet is limited to 256 columns (A through IV). Although the
new version of Excel (2007) will contain more.

Have you used all 256 columns? If not, then you only need to delete the
last 2 columns (IU and IV) in order to insert new columns elsewhere.
Otherwise, I'd suggest breaking up your data onto a second worksheet.

HTH,
Elkar


"Karl" wrote:

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 dont 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