Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drag to fill a formula - problem!
I have a column of names in capitals and want to use the PROPER formula to
convert these to Proper case in the column next to it. However, the spreadsheet has been sent to me and seems to have a 'bug'. If I fill in the first entry, then try to drag and fill for the remainder, it repeats the first name in every cell. There is no constant $ in the formula. I tested the formula on a completely new spreadsheet using random, not copied, names and it works fine. Is there something I should check to get my column to fill properly? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drag to fill a formula - problem!
Try recalculating the sheet.
"Annie1904" wrote: I have a column of names in capitals and want to use the PROPER formula to convert these to Proper case in the column next to it. However, the spreadsheet has been sent to me and seems to have a 'bug'. If I fill in the first entry, then try to drag and fill for the remainder, it repeats the first name in every cell. There is no constant $ in the formula. I tested the formula on a completely new spreadsheet using random, not copied, names and it works fine. Is there something I should check to get my column to fill properly? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drag to fill a formula - problem!
Thanks - the calculation was on manual - I changed it to automatic and that
has worked. "Barb Reinhardt" wrote: Try recalculating the sheet. "Annie1904" wrote: I have a column of names in capitals and want to use the PROPER formula to convert these to Proper case in the column next to it. However, the spreadsheet has been sent to me and seems to have a 'bug'. If I fill in the first entry, then try to drag and fill for the remainder, it repeats the first name in every cell. There is no constant $ in the formula. I tested the formula on a completely new spreadsheet using random, not copied, names and it works fine. Is there something I should check to get my column to fill properly? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drag to fill row with column values | Excel Discussion (Misc queries) | |||
if you drag the fill handle will it decrement the series | Excel Discussion (Misc queries) | |||
if you drag the fill handle will it decrement the series | Excel Discussion (Misc queries) | |||
What is keyboard shortcut equivalent to drag the fill handle | Excel Discussion (Misc queries) | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) |