Need more columns in worksheet

W

William

How do I get more columns in a worksheet. It only goes up to column
"IV" now, and I want to add 200 more columns. (I have one column for
each day, going back over a year right now).
 
C

CyberTaz

Max Number of Columns per worksheet, 256. If your volume of data is
that extensive, consider storing it by row rather than by column
(65,536 of them), taking advantage of multiple sheets (rather than all
on one sheet), or using a relational database app (like Access)
instead.

Regads |:>)
 
B

Bob Greenblatt

Ack. Is there a way to invert the sheet? Flip all rows to columns &
cols to rows?
Click to expand...
Sure there is. But, will you have less than 256 rows after you convert it.
To transpose the data, select it all and copy it. Move to another worksheet,
and select Edit-paste Special, and click on transpose.
 

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

Two columns followed by single page-width column on same page 0
VBA Coding Help for Beginner 0
List all tables, including document structure 0
Merging from an Excel file with graphics 1
Excel does not accept text format! 0
Format column widths from one table to a separate table on same page 1
Word VBA - Automatic change content of a cell in table using dropdown list 5
adding columns to a worksheet 1

Top