View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default I can't insert column in Excell file! Help please

Probably you have some non-blank cells in the last columns (...IU,IV), maybe
unwanted. When you insert a column then Excel shifts columns right to the new
column rightward deleting the last column (IV) because the total No of
columns has to remain 256 (in Excel2003). Excel cannot decide you need data
in the last column or not, therefore it doesn't accomplish the action. Find
unwanted non-blank cells and clear them!

Regards,
Stefi

€žOlga€ť ezt Ă*rta:

When I try to insert column appiarenses window with text:
to prevent possible loss of data, Microsoft Office Excel cannt shift
nonblank cells off the worksheet. Try to locate the nonblank cell by pressing
CTRL+END, and delete or clear all in cells between the last cell and the end
of your data. Then select A1 and and save your workbook to reset the last
cell used.

 
ExcelBanter Database Error
Database Error Database error
The ExcelBanter database has encountered a problem.

Please try the following:
  • Load the page again by clicking the Refresh button in your web browser.
  • Open the www.excelbanter.com home page, then try to open another page.
  • Click the Back button to try another link.
The www.excelbanter.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.