Adding More Columns

dai_hop

New Member
Joined
Oct 11, 2004
Messages
20
Hi,

I was wondering if anyone could tell me whether or not it is possible to extend the default amount of columns in Excel 2002 past column IV please?

I need some more columns!

Cheers,

dai_hop
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Not, it is not. That is an Excel limitation. The next release (Version 12, I believe) will offer more. You will have to do some sort of workaround, like using other worksheets or rows.

Check out this link for a discussion on Excel 12:
http://www.mrexcel.com/board2/viewtopic.php?t=172620
 
Upvote 0
jmiskey said:
You will have to do some sort of workaround, like using other worksheets or rows.

Or transpose your data to go down the rows instead of across columns.

Or use Access.
 
Upvote 0
dai_hop

jmiskey and Kristy/Von Pookie(never sure what to use) are, of course, right.:)

Perhaps if you explained why you want more columns we could help.
 
Upvote 0
jmiskey said:
Kristy,
That probably needs a little clarification. Each Table in Access DOES have the same limitation on fields (columns) as Excel, being 255. However, you can set up multiple tables and link them.

Fair enough. I don't know a thing about Access, myself (at least at this point in time). However, I know it's a database program, which is what most people seem to try and use Excel as (which it is not) :)
 
Upvote 0
jmiskey said:
Each Table in Access DOES have the same limitation on fields (columns) as Excel, being 255
jmiskey

True, but the only databases I've ever seen/dealt with with that no of fields were legacy ones.

The data had to be restructured, sometimes into 1 table, sometimes into multiple tables.

Just depended on what the fields and data was.
 
Upvote 0

Forum statistics

Threads
1,223,171
Messages
6,170,480
Members
452,332
Latest member
The2ndQuest

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top