| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Standard Balance Sheet format in Microsoft Office Excel 2003(2)
How do I add more lines to the Balance Sheet format? Thank you.
|
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
"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.. |
|
#4
|
|||
|
|||
|
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.. |
|
#5
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i create an access code sheet to number my office files an. | New Users to Excel | |||
| Can a macro format a hidden sheet? | Excel Discussion (Misc queries) | |||
| Conditional format sheet data | Excel Worksheet Functions | |||
| Values in 'Balance sheet' template are in $ I want £ but there is. | Excel Discussion (Misc queries) | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Linear Mode
