ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I add more columns to the 256 that Excel allows? (https://www.excelbanter.com/excel-discussion-misc-queries/46748-how-do-i-add-more-columns-256-excel-allows.html)

Rob

How do I add more columns to the 256 that Excel allows?
 
I am using all 256 columns in Excel but would like to use even more... is it
possible to add more columns or is that it?

Anne Troy

That's it. Consider using another sheet, or transposing your data
(Edit--Copy, go to a new sheet, Edit--Paste Special, Transpose, OK.)
************
Anne Troy
www.OfficeArticles.com

"Rob" wrote in message
...
I am using all 256 columns in Excel but would like to use even more... is
it
possible to add more columns or is that it?




Ian

That's it, though you can have multiple sheets of 256 columns each, if
that's any help.

--
Ian
--
"Rob" wrote in message
...
I am using all 256 columns in Excel but would like to use even more... is
it
possible to add more columns or is that it?




Rob

I have created a large family tree and I need to go further sideways on one
sheet without breaking up the connections. Oh well... thanks anyway.

"Anne Troy" wrote:

That's it. Consider using another sheet, or transposing your data
(Edit--Copy, go to a new sheet, Edit--Paste Special, Transpose, OK.)
************
Anne Troy
www.OfficeArticles.com

"Rob" wrote in message
...
I am using all 256 columns in Excel but would like to use even more... is
it
possible to add more columns or is that it?





Anne Troy

Rob... just place a hyperlink to the next worksheet, right? Continue it
right on sheet2.
************
Anne Troy
www.OfficeArticles.com

"Rob" wrote in message
...
I have created a large family tree and I need to go further sideways on one
sheet without breaking up the connections. Oh well... thanks anyway.

"Anne Troy" wrote:

That's it. Consider using another sheet, or transposing your data
(Edit--Copy, go to a new sheet, Edit--Paste Special, Transpose, OK.)
************
Anne Troy
www.OfficeArticles.com

"Rob" wrote in message
...
I am using all 256 columns in Excel but would like to use even more...
is
it
possible to add more columns or is that it?







Rob

Thanks anyway.

"Ian" wrote:

That's it, though you can have multiple sheets of 256 columns each, if
that's any help.

--
Ian
--
"Rob" wrote in message
...
I am using all 256 columns in Excel but would like to use even more... is
it
possible to add more columns or is that it?





Rob

It's part of of a web page: http://scarisbrick.name/FamilyTree.htm and,
although I understand what you mean, I don't think it would look right on the
web page. Thanks again.

"Anne Troy" wrote:

Rob... just place a hyperlink to the next worksheet, right? Continue it
right on sheet2.
************
Anne Troy
www.OfficeArticles.com

"Rob" wrote in message
...
I have created a large family tree and I need to go further sideways on one
sheet without breaking up the connections. Oh well... thanks anyway.

"Anne Troy" wrote:

That's it. Consider using another sheet, or transposing your data
(Edit--Copy, go to a new sheet, Edit--Paste Special, Transpose, OK.)
************
Anne Troy
www.OfficeArticles.com

"Rob" wrote in message
...
I am using all 256 columns in Excel but would like to use even more...
is
it
possible to add more columns or is that it?








All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com