Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default Insert column - when worskeet over

Hello,

May someone be so kind to help in the following problem:

My excel document ends with the column "IV" and I can not insert any more
columns?

What could be the problem and how can I fix it?

Thank you very much!

Kinldy
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 419
Default Insert column - when worskeet over

ekonomija,

What version of XL are you using......2002, 2003, 2007?

If 2007, what kind of file are you using.......xls or xlsx?

If 2002 or 2003, do you have data in every single column?

If you are using 2002/2003 and you have data in every single column, there
is nothing you can do but upgrade to 2007. If you do not have data in every
column, then I'm not sure what is going on and maybe someone else can help.

If you are using 2007 and the file type is xls (file types prior to 2007),
then save as an XL 2007 file type (xlsx).

HTH,

Conan




"ekonomija" wrote in message
...
Hello,

May someone be so kind to help in the following problem:

My excel document ends with the column "IV" and I can not insert any more
columns?

What could be the problem and how can I fix it?

Thank you very much!

Kinldy



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7,247
Default Insert column - when worskeet over

If you are in Excel 2003 or in Excel 2007 using the Excel 97/2003 file
format (xls, compatibility mode), then you are limited to 256 columns
(column IV) and this limit cannot be increased. For more than 256 columns,
you must be using Excel 2007 (in native, not compatibility, file format
mode).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"ekonomija" wrote in message
...
Hello,

May someone be so kind to help in the following problem:

My excel document ends with the column "IV" and I can not insert any more
columns?

What could be the problem and how can I fix it?

Thank you very much!

Kinldy


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
insert a blank column between each column in a data file Holly Excel Discussion (Misc queries) 1 October 31st 07 07:04 PM
insert row / insert column command buttons fairgreen Excel Worksheet Functions 1 October 29th 07 02:41 PM
Insert blank column every other column saman110 via OfficeKB.com Excel Discussion (Misc queries) 2 August 29th 07 09:06 PM
Cannot insert Column Buss Excel Discussion (Misc queries) 1 January 17th 06 08:41 PM
Look up then insert value in next column Tenacity Excel Worksheet Functions 2 February 18th 05 10:53 PM


All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"