Rows not formatting all the way down

[Guest]

Hi there I am a HUGE excel fan and thought I was sort of a guru. But quickly
found out that I am not. I am working on a budget/expense plan and I have
been working on one for HOURS.

Only to discover that the rows (categories) that I actually added in on my
own did not format all the way down.

What am I doing wrong?

To add the row (category) I do this:

i. Click on the number of the row below. (That row should be highlighted)
ii. Right click and click 'Copy'
iii. Right click again and click 'Insert Copied Cells'
iv. Now fill in the blanks with your new category
v. This will keep all the formulas working.

But it hasnt been working. Please please help me, I am so frazzled~

 

[Don Guillett]

I just highlighted a selection of cells
copy
insert >shift down

Sub Macro4()'Recorded action above
'
' Macro4 Macro
' Macro recorded 1/20/2007 by Don Guillett
'

'
Range("A24:F24").Select
Selection.Copy
Selection.Insert Shift:=xlDown
End Sub

Sub Macro4_Cleanedup()
With Selection
.Copy
.Insert Shift:=xlDown
End With
Application.CutCopyMode = False
End Sub

 

[Guest]

Thank you Don.

After some review I had to hit ctrl and the ` sign and was able to see the
formulas I then had to reformat each line I had entered manually.

Why is that?

Thanks again for your help.

 

[Don Guillett]

Using the manual method I suggested also copied the formats
select range to copy
copy
right click>insert>shift down