Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rows not formatting all the way down
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~ |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rows not formatting all the way down
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" wrote: 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 -- Don Guillett SalesAid Software "Angie" wrote in message ... 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~ |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rows not formatting all the way down
Using the manual method I suggested also copied the formats
select range to copy copy right clickinsertshift down -- Don Guillett SalesAid Software "Angie" wrote in message ... 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" wrote: 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 -- Don Guillett SalesAid Software "Angie" wrote in message ... 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~ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting for Rows based on one cell's outcome | Excel Discussion (Misc queries) | |||
Weird formatting on inserted rows | Excel Discussion (Misc queries) | |||
Unknown formatting on inserted rows...? | Excel Discussion (Misc queries) | |||
Conditional formatting for rows? | New Users to Excel | |||
How to get more than 3 rows in Conditional Formatting | Excel Discussion (Misc queries) |