ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "limit row count" (https://www.excelbanter.com/excel-discussion-misc-queries/92544-limit-row-count.html)

Ramezan Nejad

"limit row count"
 
There is 65536 rows in excel as default i want decrease the default row's
count.
Please tell me how can i do this?
As in column?

Bob Phillips

"limit row count"
 
You can't, you get no more, no less. You could hide all rows beyond your
data (FormatRowHide).

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ramezan Nejad" <Ramezan wrote in message
...
There is 65536 rows in excel as default i want decrease the default row's
count.
Please tell me how can i do this?
As in column?




[email protected]

"limit row count"
 
There's no way, other that to get a copy of Excel 12, which has just
been released in beta. Excel 12 has over a million rows and over
16,000 columns.

Ramezan Nejad wrote:
There is 65536 rows in excel as default i want decrease the default row's
count.
Please tell me how can i do this?
As in column?




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

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