ExcelBanter - Standard Balance Sheet format in Microsoft Office Excel 2003(2)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Standard Balance Sheet format in Microsoft Office Excel 2003(2) (https://www.excelbanter.com/excel-worksheet-functions/17447-standard-balance-sheet-format-microsoft-office-excel-2003-2-a.html)

heberling

Standard Balance Sheet format in Microsoft Office Excel 2003(2)

How do I add more lines to the Balance Sheet format? Thank you.

Gord Dibben

This particular Template has sheet protection enable.

Go to ToolsProtection and "Unprotect Sheet"

No password is required.

Now you can add more rows starting at row 26.

Make sure to copy the formula in I25 down.

Also change the formulas in G26 and G27 to include the new rows.

Gord Dibben Excel MVP

On Sun, 13 Mar 2005 13:11:03 -0800, heberling
wrote:

How do I add more lines to the Balance Sheet format? Thank you.

BillyBoy

"Gord Dibben" wrote:

This particular Template has sheet protection enable.

Go to ToolsProtection and "Unprotect Sheet"

No password is required.

Now you can add more rows starting at row 26.

Make sure to copy the formula in I25 down.

Also change the formulas in G26 and G27 to include the new rows.

Gord Dibben Excel MVP

On Sun, 13 Mar 2005 13:11:03 -0800, heberling
wrote:

How do I add more lines to the Balance Sheet format? Thank you.

Thanks my friend .. You just solved my problem also..

RABBITS

HOW DO I COPY THE FORMULA WITHOUT COPYING THE DATA?

"BillyBoy" wrote:

"Gord Dibben" wrote:

This particular Template has sheet protection enable.

Go to ToolsProtection and "Unprotect Sheet"

No password is required.

Now you can add more rows starting at row 26.

Make sure to copy the formula in I25 down.

Also change the formulas in G26 and G27 to include the new rows.

Gord Dibben Excel MVP

On Sun, 13 Mar 2005 13:11:03 -0800, heberling
wrote:

How do I add more lines to the Balance Sheet format? Thank you.

Thanks my friend .. You just solved my problem also..

RABBITS

IF I MAKE A WORK BOOK WITH MULTIPLE SHEETS, CAN I THEN MERGE THOSE WORKSHEETS
INTO ONE WORKBOOK?

"Gord Dibben" wrote:

This particular Template has sheet protection enable.

Go to ToolsProtection and "Unprotect Sheet"

No password is required.

Now you can add more rows starting at row 26.

Make sure to copy the formula in I25 down.

Also change the formulas in G26 and G27 to include the new rows.

Gord Dibben Excel MVP

On Sun, 13 Mar 2005 13:11:03 -0800, heberling
wrote:

How do I add more lines to the Balance Sheet format? Thank you.

All times are GMT +1. The time now is 09:02 AM.