Excel Limitation - Inserting Colums - Help

[Tim Harding]

Having difficulties inserting columes into a document.

Error received
To prevent possible loss of data non blank cells , Microsoft Excel cannot
shift non blank cells off the worksheet.

Any siggestions.

many thanks

Tim


--
Help is always there..youv just got to look for it !

[JulieD]

Hi Tim

it sounds like a cell somewhere has got a space in it .. press CONTROL & END
and see where you go ... then i would recommend deleting all the columns
from your last real entry to that entry & same with the rows and then
closing & saving the workbook. When you reopen it it should work fine ...
check out
http://www.contextures.com/xlfaqApp.html#unused
for more details
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Tim Harding" <TimHarding@discussions.microsoft.com> wrote in message
news:058D588C-D9E2-4C00-8F31-E93B5297B2D3@microsoft.com...
> Having difficulties inserting columes into a document.
>
> Error received
> To prevent possible loss of data non blank cells , Microsoft Excel cannot
> shift non blank cells off the worksheet.
>
> Any siggestions.
>
> many thanks
>
> Tim
>
>
> --
> Help is always there..youv just got to look for it !