Quick question....(any Excel geeks out there??)

[iamme]

In Excel, I am making a simple balance sheet that has a debit, credit, then a formula that subtracts the two, resulting in the balance. Is there anyway I can have the formulas in the next line "auto-create" when I've entered one line? (for example, line two will be completely blank, until line 1 has been filled out.)

The reason is that when I pre-fill the formulas, and try to print, Excel wants to print out every page that has a formula in it......regardless if the debit/credits have been entered.

Is there an easy way to do this? (besides manually setting which pages to print within the Print dialogue box).

TIA

 

[iamme]

lil bump for assistance

 

[RBlount]

I don't know how to print the pages from printing but I use the following fomula to make a cell appear to be blank when no data is in the the formula cells:

Assume A1 and B1 are the data cells and the formula should be A1-B1.

=if(a1="","",a1-b1)

Essentially, if A1 is blank the result is blank then the result is blank. Otherwise the result is shown.

If anything just recycle the blank pages that print

-Rob

 

[KingNothing]

Click once to highlight the cell, then drag the little + sign down to auto-create the formulas. Excel's pretty smart about doing this sort of thing...for instance if you're making a schedule and you type in a few times separated by half an hour, select that list, and then drag the + down, Excel will fill in more times in half-hour increments.

 

[chin311]

support.microsoft.com jk

my boss is awesome at excel, im trying to learn what i can...

 

[VTHodge]

If you want the cell to remain truly blank until needed, you could use a macro.

DeleteRowOnCell

The macro DeleteBlankRows will delete a row if the entire row is blank. This macro will delete the entire row if a the cell in the specified column is blank. Only this column is checked. Other columns are ignored. This macro was suggested by Dana DeLouis, in the Excel programming newsgroup. Thanks, Dana !

Public Sub DeleteRowOnCell()

On Error Resume Next
Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
ActiveSheet.UsedRange

End Sub

To use this macro, select a columnar range of cells, and then run the macro. If the cell in that column is blank, the entire row will be deleted. To process the entire column, click the column header to select the entire column.

Source

For more tips try this great site: Mr. Excel

 

[iamme]

i guess more than deleting rows, i need to add a row with the formula after i input into the previous row. does that make sense?

like right after i input into row 1, the formula in row 2 would be generated. after i put into row 2, row 3 will be automatically generated.

the person i am making this for isn't really Excel savy, so i want to make things user friendly for him

 

[iamme]

anyone else?

 

[jepatbentley]

Leave the formula in as many sells as you want and set your print area before you print.
To set the Print Area, highlight what you want printed and then go to the file menu and expand the one that says "Print Area" and click on "Set Print Area"

 

[brunswickite]

this is ONtopic