how do i increase the rows in a excel balance sheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i've prepare a balance sheet for my company.In the excel balance sheet i
can't enter more then 12 rows. what can i do/
 
dass said:
i've prepare a balance sheet for my company.In the excel balance sheet i
can't enter more then 12 rows. what can i do/
Click to expand...


Could you be a bit more specific? Excel (at least in 2003 and prior) has
over 60 THOUSAND rows. What EXACTLY do you mean by "can't enter more than 12
rows"?
 
Excel 95 and earlier had 16,384 = 2^14 rows.
Excel 97 through Excel 2003 had 65,536 = 2^16 rows.
Excel 2007 has 1,048,576 = 2^20 rows.

These numbers cannot be altered in any way (either up or down). In
particular, Gordon is correct that the issue is not the number of rows in
Excel, but rather what the OP is trying to do relative to the setup of the
template, which goes beyond the information provided by the OP.

Jerry
 
Jerry W. Lewis said:
Excel 95 and earlier had 16,384 = 2^14 rows.
Excel 97 through Excel 2003 had 65,536 = 2^16 rows.
Excel 2007 has 1,048,576 = 2^20 rows.

These numbers cannot be altered in any way (either up or down). In
particular, Gordon is correct that the issue is not the number of rows in
Excel, but rather what the OP is trying to do relative to the setup of the
template,
Click to expand...

We don't even know that the OP is using a template!
(I never used to, for balance sheets......)
 
Hi Gord

I think the OP is referring to the Balance Sheet template included
(certainly with XL2003)
This is not a Balance Sheet in the strict Accounting terminology that
you (and I) might expect, as it is not a statement of the Assets and
Liabilities of the business.

All it is, is a simple account Balance, made up of Receipts and
payments.
The Template is shown as 12 rows.

In order to insert extra rows, just choose Tools>Protection>Unprotect
Sheet
There is no password.
 
Roger Govier said:
Hi Gord

I think the OP is referring to the Balance Sheet template included
(certainly with XL2003)
This is not a Balance Sheet in the strict Accounting terminology that you
(and I) might expect, as it is not a statement of the Assets and
Liabilities of the business.

All it is, is a simple account Balance, made up of Receipts and payments.
The Template is shown as 12 rows.

In order to insert extra rows, just choose Tools>Protection>Unprotect
Sheet
There is no password.
Click to expand...

Ah. Thanks for the insight..... :-)
 
Back
Top