doctorbill
asked on
excel
We have a a spreadsheet in excel 2003 format which has reached it's limit in terms of number of columns
We need to insert another column - is there a work around for this?
Also, if we delete columns we still cannot insert columns, getting the following error message:
To prevent possible loss of data excel cannot shift non-blank cells off the worksheet .......
We have checked for non-blank cells but cannot find any - unhiding fields still reveals no non-blank cells
We need to insert another column - is there a work around for this?
Also, if we delete columns we still cannot insert columns, getting the following error message:
To prevent possible loss of data excel cannot shift non-blank cells off the worksheet .......
We have checked for non-blank cells but cannot find any - unhiding fields still reveals no non-blank cells
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Solution as I expected
ASKER
They could migrate to excel 2010 where there are >16,000 columns allowed I suppose