Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting Question
Hello,
Is there a way to prevent when you cut & copy a row in a worksheet that it does not cut your borders, formulas, etc. and you have to go back and re-add the lines and formulas? Thank You very much. Kent Hansen |
#2
|
|||
|
|||
One way:
When you copy use Ctrl+C and double tap the C. This should bring up your clipboard Now, before you move, you can simply delete the field you copied without changing formatting. Ctrl+V will be disabled when you delete, but what you copied wil be availble on the clipboard. Just watch out for whether you want to use absolute references or not in your formulas. -----Original Message----- Hello, Is there a way to prevent when you cut & copy a row in a worksheet that it does not cut your borders, formulas, etc. and you have to go back and re-add the lines and formulas? Thank You very much. Kent Hansen . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell formatting behaviour question | Excel Discussion (Misc queries) | |||
Excel Macro Question about Conditional Formatting | New Users to Excel | |||
Cell / Date Formatting Question when result = -0- | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Worksheet Functions | |||
Area Chart Formatting Question | Charts and Charting in Excel |