Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Traci
 
Posts: n/a
Default Adding columns to a worksheet

Does anyone know how to add more than 256 columns to a excel worksheet?
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Cannot be done with current or previous versions of Excel.

What are your needs(other than more than 256 columns)?

There may be other methods to do what you want.


Gord Dibben Excel MVP

On Mon, 29 Aug 2005 09:27:03 -0700, "Traci"
wrote:

Does anyone know how to add more than 256 columns to a excel worksheet?


  #3   Report Post  
bj
 
Posts: n/a
Default

You can't, but you can use additional workshhets for many applications.

"Traci" wrote:

Does anyone know how to add more than 256 columns to a excel worksheet?

  #4   Report Post  
Traci
 
Posts: n/a
Default

I have to keep a history of some purchases and I have already used the 256
columns but, I added new worksheets and referenced as needed, it would have
just been easier to continue as I was but, a new sheet with 256 new columns
will hold me for about another year. Thanks for the help.

"Gord Dibben" wrote:

Cannot be done with current or previous versions of Excel.

What are your needs(other than more than 256 columns)?

There may be other methods to do what you want.


Gord Dibben Excel MVP

On Mon, 29 Aug 2005 09:27:03 -0700, "Traci"
wrote:

Does anyone know how to add more than 256 columns to a excel worksheet?



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
Adding columns (one with a formula) PaulStroik New Users to Excel 7 June 27th 05 10:32 PM
How do I Compare worksheet columns dannix54 Excel Worksheet Functions 8 May 9th 05 02:26 AM
columns and rows on my worksheet will not stay resized vulcan88 Excel Worksheet Functions 0 March 15th 05 11:07 PM
How do I automatically hide columns in a worksheet based on a cell value? dkhedkar Excel Worksheet Functions 1 March 5th 05 12:20 AM
How can i set consecutive columns in an excel worksheet to differ. Adam H Charts and Charting in Excel 2 February 25th 05 11:08 PM


All times are GMT +1. The time now is 11:00 PM.

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"