how to extend columns pass IV

[freakyboy88]

*hi! i'm new here and i need help on how to extend the columns in excel
normal extendsion is A to IV but i was wondering if u could extend the
columns beyond that using vbas and marcos?
if some one would please tell me it'd be great
thanks a lot*

 

[Anne Troy]

The answer is NO. Here's a couple workarounds:
--put the data vertically so you don't need so many columns
--combine some of the columns, like last name and first name or some other
columns that make sense when combined
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"freakyboy88" <[email protected]>
wrote in message
news:[email protected]...

 

[JE McGimpsey]

No you can't. XL (all versions) is limited to 256 columns.

You *can* use multiple sheets. You can also, if you have less than 256
rows of data, transpose it to use rows instead of columns...