![]() |
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 |
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 . |
All times are GMT +1. The time now is 02:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com