Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Filtering Columns for Unique Values
Printing Multiple Worksheets on a Single Page
Excel will handle up to 256 columns and 65,536 rows of information. Unfortunately, you cannot increase these dimensions, nor can you reverse them. (Reversing them would allow you up to 65,536 columns and 256 rows.) The dimensions are "hard-coded" into Excel.
There is talk that in the next version of Excel this dimensional limit will be removed; the truth of such rumors waits to be seen. In the meantime, there is a way you can fudge this, however. You can change the alignment of information in your cells by 90 degrees, change the height and width of the cells, and then print your information in landscape mode. While this does not technically change the number of dimensions, it does provide the illusion of more columns.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2076) applies to Microsoft Excel versions: 97 2000 2002 2003
Save Time! ExcelTips has been published weekly since late 1998. Past issues of ExcelTips are available in convenient ExcelTips archives. Have your own enhanced archive of ExcelTips at your fingertips, available to use at any time!