ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Extend Excel Workbook Columns to 366 (https://www.excelbanter.com/excel-worksheet-functions/68614-extend-excel-workbook-columns-366-a.html)

ExcelERATOR

Extend Excel Workbook Columns to 366
 
Excel Workbook does not have enough columns. There should be at least enough
for 367 (one for each day of the year - 365 plus the quarter plus the title).
At present I am creating a spreadsheet of an application that requires about
280 columns but I'm limited to 256. This is very frustrating. I will
probably have to end up creating over two worksheets which is an immense
amount more work.

At the minimum there should be an option that allows you to create an
exceptional oversize spreadsheet occasionally by nominating the columns and
rows you need. To have 65,000 odd rows is pretty (goddamn) useless when all
you need is a few extra columns.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Chip Pearson

Extend Excel Workbook Columns to 366
 
The next version of Excel will have 16,384 columns and 1,048,576
rows.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ExcelERATOR" wrote in
message
...
Excel Workbook does not have enough columns. There should be
at least enough
for 367 (one for each day of the year - 365 plus the quarter
plus the title).
At present I am creating a spreadsheet of an application that
requires about
280 columns but I'm limited to 256. This is very frustrating.
I will
probably have to end up creating over two worksheets which is
an immense
amount more work.

At the minimum there should be an option that allows you to
create an
exceptional oversize spreadsheet occasionally by nominating the
columns and
rows you need. To have 65,000 odd rows is pretty (goddamn)
useless when all
you need is a few extra columns.

----------------
This post is a suggestion for Microsoft, and Microsoft responds
to the
suggestions with the most votes. To vote for this suggestion,
click the "I
Agree" button in the message pane. If you do not see the
button, follow this
link to open the suggestion in the Microsoft Web-based
Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions





All times are GMT +1. The time now is 12:53 PM.

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