ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formatting Question (https://www.excelbanter.com/excel-worksheet-functions/15525-formatting-question.html)

Kent

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

Bob Tarburton

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