Insert extra columns

A

Alan

Is there any way that one can insert extra columns in
Excel? I need about 500 columns whereas Excel only has
255.
 
D

David McRitchie

Hi Alan,
You cannot exceed 255 columns that is a specification limit.

For this and other specification limits see
HELP (or F1) --> Index (tab) --> specification

There are other spreadsheet packages that do handle more
columns, but they aren't Excel.

In Excel you would have to use two spreadsheets.

If you do not currently have more than 255 rows and never intend to
you can transpose the rows and columns. It probably won't look
very good as you most likely have your long descriptions in column
A of the rows, but it would provide a means of keeping your data
in a spreadsheet if you will never need to exceed 255 columns
once the data has been transposed. See TRANSPOSE in help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Two columns followed by single page-width column on same page 0
Space at end of multi page list to accommodate new entries 1
Excel --> Word 4
Mail Merge Directory Conditional Page Break 0
Two columns : Continuous two columns vs Parallel two Column 1
Insert multiple objects at once ? 3
Merging from an Excel file with graphics 1

Top