Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!

Subscribe for Free Excel tips & more!

Free Excel Forum

How To Increase Maximum Number Of Columns In Excel 2003

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Excel 2003 is set to 256 columns, perhaps because my spreadsheet was
originally started in Excel 97. How can I increase the maximum number of
columns to what is possible in Excel 2003? Quattro Pro has far more columns
available. I can't believe that Microsoft would limit Excel 2003 to 256
columns. ?????

View Answers     

Similar Excel Tutorials

Quickly Create a Huge List of Numbers in Excel
Quickly create a large list of numbers in Excel using the Fill Command.  This will save you time and allow you to ...
How to Add, Remove, and Rearrange Columns and Rows in Excel
Adding, removing and rearranging columns is as easy as resizing. You just select your columns or rows, right click ...
How to Resize Rows and Columns in Excel Quickly
Resizing rows and columns in Excel is an easy process. Simply left click in between the columns and drag the mouse ...
Scale Data for Printing in Excel - Fit more onto a Printed Page
This tip shows you how to fit more Excel data onto a page for printing. This does not change the size, shape, or lo ...

Helpful Excel Macros

Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
- This Excel macro allows you to filter a data set on multiple columns and criteria at once. This means that you can filt
Delete Empty Columns
- This macro will delete columns which are completely empty. This means that if there is no data within the entire column
Reverse Row or Column Order in a Worksheet
- This macro reverses the order of a selected row or column in excel. It will completely reverse the data.
Make Text to Uppercase
- This macro will change all text within the selected cells to uppercase. It works only on selected cells within Microsoft
Change Text to Lowercase
- This macro will change all text within the selected cells to lowercase. It works only on selected cells within Microsoft

Similar Topics

Dear All,

Prior to Excel 2007, you could only sort by at most three levels using the dialog box. If using VBA for Excel 2003, is the maximum number of levels still three? I need to sort by six columns. Do I need to sort by columns 4 through 6, and then by 1 through 3 to get the desired effect?



Is there a way to increase the maximum number of columns in Excel 2010 beyond column IV? I know excel lists this as the maximum number of columns, but I do not know if anyone has a work around to that would allow for more columns to be added?

Is there a maximum amount of hidden columns within Excel? I have double-checked protection, and I have enough columns total for the action I'm attempting to do. I am using Excel 2003, and working on a rather large spreadsheet for a forecast. The basics of it is that I have macro's within buttons set-up so that users can hide columns and just view certain columns for approximately 30 columns per week and 5 weeks.
And I can run the hide macro's for up to 4 weeks at a time, but when attempting to hide the 5th week it gives me a "Run time error 1004" Unable to set the Hidden property of the Range class.

Have I perhaps just reached a maximum of hidden columns?

Thank you,

I'm thinking about upgrading to excel 2007 as I have a certain analysis that requires more than 256 columns. My questions is if someone else opens my spreadsheet in excel 2003, what will happen if I had data in more than 256 columns when they open it in their 2003 version. Thanks guys


I am running: Microsoft Office Excel 2003 (11.8316.8221) SP3

My question is this:

Is there a way for me to increase the maximum amount of data that an Excel spreadsheet "cell comment" box will hold?

Whenever I am working inside a .XLS spreadsheet, I frequently make use
of the "cell comment" feature which allows me to make special notes or comments on selected spreadsheet cells. The problem is that sometimes when I am copying and pasting large amounts of data into the cell comments box that holds the comment, Excel seems to allow me to paste only so much data into the cell comment box and then it will not let me add any more comments/data. This seems to indicate that I have reached the maximum amount of data that the cell comment box is allowed to hold.

So again, is there a way for me to increase the maximum amount of data that an Excel spreadsheet "cell comment" box will hold?

All sincere/thoughtful replies are solicited and appreciated!


Rob Sandifer

Hi everyone - huge thanks in advance to anyone that can offer some assistance with this problem.

I have a 6x5 matrix with a series of data in it. It is as simple as this:

Row 13: 0 1 2 3 4
Row 14: 0 1 2 3 4

and this is repeated over for 6 rows. The figures in each cell can increase or decrease (dependant upon another multiplier elsewhere).

I need a formula to work out a % total for this data - but I really need each row to only contribute an equal amount (16.6r or 100/6)and when it reaches that maximum for it to contribute no more. (i.e - if rows 14, 15, 16, 17 and 18 are all 0 - I want the maximum that can come from Row 13 to be 16.7%)

If I simply SUM this data - I could potentially end up with 1000% total (if the figures increase then so will my % total) which would defeat the point.

I hope this makes some sense to someone and you'll be able to help. Please question me if it is not clear.

(Doubt it matters but I'm using Excel 2003)

Hi Guys,
Briefly, I run a spreadsheet that pulls in financial data from a provider(Bloomberg) and ranks trades according to parameters I set. It compares each stock to each other; therefore with excel 2003 I could enter a maximum of 255 stocks(255^2=65025). If I programmed any more stocks I would get an "exceed number of rows limit"

On Friday I installed Excel 2007. This has 1m rows allowing me to increase my securities sample set to 1000(1000^2=1m).

However when I run this it completes 9% of the calculations before I get an error message. This states "exceeds maximum number of rows 65k". I then get a VISUAL BASIC "run time error 9, subscript out of range message"

It seems that the programme does not realise that I am now running excel 2007. I have saved the sporeadsheet in excel2007(as a .xlsm) and I open it in Excel 2007. I have no idea why it is still giving me a row limit message...

Any Ideas or input would be greatly appreciated...


Hi everyone. I've got a dilemma and I need some help if you dont mind. I have a spreadsheet like this:


* A B C D E F G H I J 1 Symbol Date Price Volume * * SYMBOL DATE PRICE VOLUME 2 CAA 01/02/2003 95.20 10 * * * * * * 3 CAB 01/02/2003 96.00 7 * * * * * * 4 CAC 01/02/2003 94.21 5 * * * * * * 5 CAD 01/02/2003 98.83 2 * * * * * * 6 CAA 01/03/2003 96.53 48 * * * * * * 7 CAB 01/03/2003 93.24 15 * * * * * * 8 CAC 01/03/2003 97.00 32 * * * * * * 9 CAD 01/04/2003 91.11 153 * * * * * * 10 CAB 01/04/2003 88.06 32 * * * * * * 11 CAC 01/04/2003 85.00 56 * * * * * * 12 CAA 01/07/2003 75.00 25 * * * * * * 13 CAB 01/07/2003 76.64 25 * * * * * * 14 CAA 01/08/2003 91.00 15 * * * * * *

Excel tables to the web >> Excel Jeanie HTML 4

Columns A to D are sorted by date.

I would like to fill columns G to J with the info described by the headings in this way: the info must be for each date but with the highest volume.

So in this case, the dates that must appear in column H are :


because they are the dates that exist in column B.

For rest of the info that must accompany these dates are those in that row where the volume is highest for that date. So for the date 01/02/2003, the highest Volume in column D for that date is 10, and so what should appear in columns G to J for that date is:


* G H I J 1 SYMBOL DATE PRICE VOLUME 2 CAA 01/02/2003 95.20 10 3 * * * * 4 * * * * 5 * * * * 6 * * * * 7 * * * * 8 * * * * 9 * * * * 10 * * * * 11 * * * * 12 * * * * 13 * * * * 14 * * * *

Excel tables to the web >> Excel Jeanie HTML 4

So on 01/02/2003, symbol CAA has the highest volume for that day of 10 with a price of 95.20.

For those dates wherein one or more symbols have equal volume, what should be used is that symbol which has the earliest 3rd letter. So for example, 01/07/2003 has two symbols (CAA and CAB) that have the same volume of 25. Since the thirld letter of CAA is A while the third letter of CBB is B, we use CAA's info. So, for 01/07/2003, it must be:


* G H I J 5 CAA 01/07/2003 75.00 25

Excel tables to the web >> Excel Jeanie HTML 4

So the result all in all must be like this:


* G H I J 1 SYMBOL DATE PRICE VOLUME 2 CAA 01/02/2003 95.20 10 3 CAA 01/03/2003 96.53 48 4 CAD 01/04/2003 91.11 153 5 CAA 01/07/2003 75.00 25 6 CAA 01/08/2003 91.00 15 7 * * * * 8 * * * * 9 * * * * 10 * * * * 11 * * * * 12 * * * * 13 * * * * 14 * * * *

Excel tables to the web >> Excel Jeanie HTML 4

Whew! I hope that didn't sound too confusing or daunting. I've just got a ton of data and doing it manually would drive me crazy. If there's a procedure or macro or anything that could do this which you guys could suggest, it be would a big big help. Thanks!

Hi Can any one tell me how to limit the number of columns in an excel 2003 spreadsheet, I only want columns a-g to be displayed and no others, I know it can be done but can't figure out how, any help would be much appreciated.

I have a .csv file I'm importing into Excel. It has 150 columns. My VBA code that shows the columns being imported wraps with the line continuation underscore character _. When I run the code, I get a message, something about the maximum number of continuation characters being exceeded. I don't have the code, nor the exact error message with me. I think I removed all the continuation characters and this did not solve the problem, or allow the code to execute, but I don't recall what the error message which resulted from that attempt was.

Is there a maximum number of columns one can import into Excel using VBA? Silly question, right? It can't be as low as 150. Must be something else. Excel 2003.


is it possible to filter only specific columns in excel 2003?

for example I have autofilter on all of my columns A-Z.

what if i just want to have a drop down filter for A-D and then G-K and then N-P, etc. etc.

Any help is much appreciated. From the gurus I've talked to here at work it can't be done. I can only select a few columns in sequence and have the filters there or it breaks the merge apparently of columns. So it's either all the columns with the autofilter to the left/right only but not a few here and then a few over there if that make any sense. Thanks!!

I have a database that I want to run queries against to create a Cube within
Excel 2003. I've tested it out on a small amount of data and it works great.
My question is, what is the maximum size in terms of physical .cub file
size, number of records, number of dimensions, etc. that Excel 2003 has. I'm
trying to figure out if this solution will work for my client or if I need to
get them a full blown analysis services install.

Why should MS Excel daily user switch from Excel 2003 to 2007 (or 2010)?
I'm considering to change from XP to W7 64 bit.

I've been a keen friend of Excel since version 95 and Quattro Pro prior to it. I have created some business applications and databases with some macros for daily personal usage. I have bought DigiDB lisence for Excel 2003.
I keep Excel 2003 running 24x7 on my workstation. Same to Outlook 2003 from Office packet but normally I don't use any other Office components..
I run XP Pro as it's still a flawless environment but likey XP is coming to end due to decreasing support from MS and advanced HDD formatting standard.
So there is no other way but sooner or later to switch to Windows 7 and 64 bit to achieve better photo handling capabilities.
But what about MS Office 2003?
I have searched the web but couldn't find any replies to the question why should I one from Office 2003 Pro to Office 2007 or 2010. More rows and more columns isn't a reason to me.
Any suggestions, should one go to Win 7 64 bit and still keep Office 2003 32 bit?

Hi all,

I am working with Excel 2003 which has a limit of 256 columns. I often import text files into excel using a very simple macro. I specify the text file's name and location in a cell and then run the macro - it opens the text file, copies the data and pastes it into the worksheet, then delimiting the columns using the semi-colons that seperated the data in the original text file.

However, I now have a text file that would convert into excel as around 1,000 columns and about 20 rows. This obviously causes a problem since my limit is 256 columns in Excel 2003.

Is there any way that Excel can transpose my data when it brings it into the spreadsheet from the text file so that I end up with 20 columns and 1,000 rows? Ideally I'd do this in VBA and add the code onto my existing little macro.

Any help greatly appreciated.


I have a worksheet in Excel 2007 that has 400 columns on it - l want to save it so that it can be opened on Excel 2003 but l get a message saying anything over column IV will be lost.

Is there a way to make Excel2003 have more columns? Or is there a better way of doing it?

The reason the sheet is 400 columns wide is that it is a year planner so needs 1 column per day

Thanks in advance

I am doing a mail merge file in Word 2003 that imports from an Excel spreadsheet. The issue I am having is that it is not importing the data in certain columns from the spreadsheet into the Word document. When I bring up the Mail Merge Recipients List in word, and scroll through the data, there are certain fields that are blank and should have data, and since it is only certain columns where the data is not being imported, I'm assuming the issue lies somewhere within my Excel spreadsheet or possibly what I'm using as the column header label for these columns. The data in these columns is numbers, and I've tried reformatting the cells to different types (general, number, accounting) with no success. Any thoughts or suggestions on what is causing this from the Excel gurus out there is appreciated!!

Using Excel 2003

I have a very large spreadsheet, only 2 columns are left without any information (Column IU & Column IV).

The file has subtotals and Groups have been applied to the columns. When I try to minimize a group I am receiving and error box that states :

Cannot shift objects off of sheet. Is there a limit to the number of Groups? I have confirmed that there are still 2 blank columns.

Thanks for any help.

Does anyone know if there are a maximum number of tabs for one work book in 2003 like there are a mximum number of columns on one sheet? Also I have heard that if there are too many sheets then it can damage the integrity of the file as a whole. Is there any support to this?

Thanks for your help!

hi there!

could someone give me a VBA code to sort more than 3 columns using Excel 2003? one code for ascending, and another one for descending... the idea is to manually change the column range selection on the code, depending on the number of columns I want to consider...

I have created a large spreadsheet about 3mb in Excel 2007.

When I save this for use on a 2003 machine, it says that there is data beyond the maximum columns and rows....

If I goto find error, it refers to a cell that is well within the range permitted. I have gone to each sheet and selected goto (F5), special and selected last cell. I can't find anything anywhere near the limit.

What is strange is thta the warning does not appear when I save the file with the sheet in question selected. Instead it only comes up if I am on a different sheet.

I have looked on the net for a solution and some had posts stating that the cell Excel thinks is outside the 2003 range refers to merged cells or has merged dependents, but my spreadsheet does not have this.

It is a major problem because some of our clients use 2003 and when they open it, they get a warning that it is not compataible and data will belost which is not the case.

Can anyone help?

I have two columns. First column contains a sorted list of years and the second column contains values for that year.
Column B Column C
2001 27-330
2002 27-330
2003 27-330
2003 27-230
2003 27-230
2003 27-330
2003 27-280
2003 27-250
2003 27-230
2003 27-230
2003 27-230
2003 27-230
2003 27-230

I would like to count the number of occurrences in column C based on Column B and print it to an array format.
Been able to set up the header and row names, but now need to fill in the array.

Please help!!

Master Workbook Rev 9.xlsm

Heres a good one!

Access 2003 / Excel 2003

I have an access database with a table which is the source for a new database query in excel. The access table has 29 columns and the Excel query in the query view has the same 29 columns. Two of the columns always have NULL data (i.e. they are empty) - this is preserve CSV file layouts (I know.. I know..)

When I return the query results to the spreadsheet, the two columns have been dropped and I only have 27 columns. I can't find anything about this on the web, has anyone else experienced anything similar?


I have a set of columns in a worksheet and i want to reorganize the data in this workesheet by re-sorting the columns. The number of columns in that sheet is over 20o. How to sort this number of columns in Excel 2003?. The process to sorting this number of columns manually is time consuming.


Can anyone tell me the maximum records(rows) and variables (columns) allowed in Excel 2003, version.
Maybe this is repeat but i tried the search and came up with nothing.

How do I restrict what I see on my screen (and specifically, limit the scroll
feature) to the rows and columns I'm actually using in an Excel 2003 Pro