Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kent
 
Posts: n/a
Default 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   Report Post  
Bob Tarburton
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell formatting behaviour question derek Excel Discussion (Misc queries) 3 February 22nd 05 10:17 PM
Excel Macro Question about Conditional Formatting David Britton via OfficeKB.com New Users to Excel 3 February 10th 05 02:23 PM
Cell / Date Formatting Question when result = -0- seve Excel Discussion (Misc queries) 3 January 17th 05 02:29 AM
conditional formatting question chris Excel Worksheet Functions 2 January 5th 05 03:51 PM
Area Chart Formatting Question Avrilon Charts and Charting in Excel 3 December 2nd 04 09:14 PM


All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"