Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
David Pharmacy 777
 
Posts: n/a
Default Increase the limit to number of columns?

I have run oput of columns on my sheet. I can't insert any more. Can I
increase this limitation?
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

No, you have to manage it in other ways (e.g. multiple sheets)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"David Pharmacy 777" <David Pharmacy wrote in
message ...
I have run oput of columns on my sheet. I can't insert any more. Can I
increase this limitation?



  #3   Report Post  
Ben McBen
 
Posts: n/a
Default

This requires kidnapping Bill Gates and holding him to
ransom until they change this!

Until then - buy a mug:

http://www.cafepress.com/mrexcel.6298265
  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

$12.99 for a mug!

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ben McBen" wrote in message
...
This requires kidnapping Bill Gates and holding him to
ransom until they change this!

Until then - buy a mug:

http://www.cafepress.com/mrexcel.6298265



  #5   Report Post  
Michael R Middleton
 
Posts: n/a
Default

David Pharmacy 777 -

I have run oput of columns on my sheet. I can't insert any more. Can I
increase this limitation? <


The limit is 256 columns, and it cannot be changed.

If you're not using all 256, and if you cannot insert a column, there may be
some columns on the far right that seem to be empty but that Excel thinks
contain data or that previously contained data. If you select those columns
on the far right and delete (or clear contents), you may be able to insert
columns again.

- Mike

www.mikemiddleton.com


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
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Nested IF limit or Open parentheses limit Fred Excel Discussion (Misc queries) 5 December 23rd 04 04:34 PM
Increase Number of Worksheets Hoochi Coochi Man Excel Discussion (Misc queries) 4 December 10th 04 05:17 PM
two columns of numbers, need to sort/filter to find one number th. Larry in Seattle Excel Discussion (Misc queries) 1 December 10th 04 07:17 AM
How do I sum a number of columns and ignore the minimum value? Nicole Excel Discussion (Misc queries) 2 December 10th 04 02:03 AM


All times are GMT +1. The time now is 08:50 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"