Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drag and drop
If I drag data to another cell, it takes away the formatting in the old cell.
For example, say I have a cell formatted to show negative numbers in parenthesis (eg: -4 = (4.00)) and I drag that to another cell, if I enter new data in the original cell I dragged from, the formatting is gone. Is there a way to avoid this without creating a macro? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drag and drop
If I understand what you mean by "drag and drop" correctly, you can hold
down the Ctrl key while dragging the cell to its new location (actually, just before you "drop" it will do) and that will copy the cell contents plus its formatting there while leaving the original data and formatting behind. Rick "sramsey" wrote in message ... If I drag data to another cell, it takes away the formatting in the old cell. For example, say I have a cell formatted to show negative numbers in parenthesis (eg: -4 = (4.00)) and I drag that to another cell, if I enter new data in the original cell I dragged from, the formatting is gone. Is there a way to avoid this without creating a macro? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
drag and drop
When I balance my gl accounts, I pull the data in column B one cell to the
right to column C to show that they balance. That clears the data from the cell I dragged from. If I enter data back into column B after I've moved the original data, the formatting that used to be there has gone back to default number formatting. To drag and drop, I just click on the selected cells' border and move them over. "Rick Rothstein (MVP - VB)" wrote: If I understand what you mean by "drag and drop" correctly, you can hold down the Ctrl key while dragging the cell to its new location (actually, just before you "drop" it will do) and that will copy the cell contents plus its formatting there while leaving the original data and formatting behind. Rick "sramsey" wrote in message ... If I drag data to another cell, it takes away the formatting in the old cell. For example, say I have a cell formatted to show negative numbers in parenthesis (eg: -4 = (4.00)) and I drag that to another cell, if I enter new data in the original cell I dragged from, the formatting is gone. Is there a way to avoid this without creating a macro? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
drag and drop
Okay, that is what I thought you meant by "drag and drop". So did you try
using the Ctrl button when you let go of the mouse button at the end of your dragging? This will copy the data, along with its formatting, to the new location and leave the old data and formatting in the original location as well. You can then highlight the original cells and press Delete to remove the data but leave the formatting behind there as well. Rick "sramsey" wrote in message ... When I balance my gl accounts, I pull the data in column B one cell to the right to column C to show that they balance. That clears the data from the cell I dragged from. If I enter data back into column B after I've moved the original data, the formatting that used to be there has gone back to default number formatting. To drag and drop, I just click on the selected cells' border and move them over. "Rick Rothstein (MVP - VB)" wrote: If I understand what you mean by "drag and drop" correctly, you can hold down the Ctrl key while dragging the cell to its new location (actually, just before you "drop" it will do) and that will copy the cell contents plus its formatting there while leaving the original data and formatting behind. Rick "sramsey" wrote in message ... If I drag data to another cell, it takes away the formatting in the old cell. For example, say I have a cell formatted to show negative numbers in parenthesis (eg: -4 = (4.00)) and I drag that to another cell, if I enter new data in the original cell I dragged from, the formatting is gone. Is there a way to avoid this without creating a macro? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
drag and drop
Thank you! Is that the only way? Can you avoid using the control key and
deleting? "Rick Rothstein (MVP - VB)" wrote: Okay, that is what I thought you meant by "drag and drop". So did you try using the Ctrl button when you let go of the mouse button at the end of your dragging? This will copy the data, along with its formatting, to the new location and leave the old data and formatting in the original location as well. You can then highlight the original cells and press Delete to remove the data but leave the formatting behind there as well. Rick "sramsey" wrote in message ... When I balance my gl accounts, I pull the data in column B one cell to the right to column C to show that they balance. That clears the data from the cell I dragged from. If I enter data back into column B after I've moved the original data, the formatting that used to be there has gone back to default number formatting. To drag and drop, I just click on the selected cells' border and move them over. "Rick Rothstein (MVP - VB)" wrote: If I understand what you mean by "drag and drop" correctly, you can hold down the Ctrl key while dragging the cell to its new location (actually, just before you "drop" it will do) and that will copy the cell contents plus its formatting there while leaving the original data and formatting behind. Rick "sramsey" wrote in message ... If I drag data to another cell, it takes away the formatting in the old cell. For example, say I have a cell formatted to show negative numbers in parenthesis (eg: -4 = (4.00)) and I drag that to another cell, if I enter new data in the original cell I dragged from, the formatting is gone. Is there a way to avoid this without creating a macro? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
drag and drop
I don't have experience enough to say for sure, but if you want to drag and
drop, then I believe so. Rick "sramsey" wrote in message ... Thank you! Is that the only way? Can you avoid using the control key and deleting? "Rick Rothstein (MVP - VB)" wrote: Okay, that is what I thought you meant by "drag and drop". So did you try using the Ctrl button when you let go of the mouse button at the end of your dragging? This will copy the data, along with its formatting, to the new location and leave the old data and formatting in the original location as well. You can then highlight the original cells and press Delete to remove the data but leave the formatting behind there as well. Rick "sramsey" wrote in message ... When I balance my gl accounts, I pull the data in column B one cell to the right to column C to show that they balance. That clears the data from the cell I dragged from. If I enter data back into column B after I've moved the original data, the formatting that used to be there has gone back to default number formatting. To drag and drop, I just click on the selected cells' border and move them over. "Rick Rothstein (MVP - VB)" wrote: If I understand what you mean by "drag and drop" correctly, you can hold down the Ctrl key while dragging the cell to its new location (actually, just before you "drop" it will do) and that will copy the cell contents plus its formatting there while leaving the original data and formatting behind. Rick "sramsey" wrote in message ... If I drag data to another cell, it takes away the formatting in the old cell. For example, say I have a cell formatted to show negative numbers in parenthesis (eg: -4 = (4.00)) and I drag that to another cell, if I enter new data in the original cell I dragged from, the formatting is gone. Is there a way to avoid this without creating a macro? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drag and drop editing | Excel Discussion (Misc queries) | |||
I cannot drag/drop in the spreadsheet | Excel Discussion (Misc queries) | |||
Drag and drop Web services | Excel Discussion (Misc queries) | |||
Drag and drop | New Users to Excel | |||
drag and drop to get a lot of wordarts? | Excel Discussion (Misc queries) |