| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy&paste cells w/o affecting borders
XL2003
I am trying to create a template that another user will be entering information. The other user likes to copy and paste information from one cell to another a lot. When she does this the borders copy with it and no longer line up (double lines against solid, etc). Is there a way I can allow her to copy and paste data from one cell to another without affecting the borders? I assume there is an option somewhere with a box that needs checked! LOL Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy&paste cells w/o affecting borders
Paste Special is what you need. Choose to paste just formulae or values (or
a few other options) "Conker10382" wrote: XL2003 I am trying to create a template that another user will be entering information. The other user likes to copy and paste information from one cell to another a lot. When she does this the borders copy with it and no longer line up (double lines against solid, etc). Is there a way I can allow her to copy and paste data from one cell to another without affecting the borders? I assume there is an option somewhere with a box that needs checked! LOL Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy&paste cells w/o affecting borders
Great. That is exactly what I am looking for. Is there any way to make "All
except Borders" the default paste? I'm sure she won't remember to do Paste Special everytime. Thanks again. "bigwheel" wrote: Paste Special is what you need. Choose to paste just formulae or values (or a few other options) "Conker10382" wrote: XL2003 I am trying to create a template that another user will be entering information. The other user likes to copy and paste information from one cell to another a lot. When she does this the borders copy with it and no longer line up (double lines against solid, etc). Is there a way I can allow her to copy and paste data from one cell to another without affecting the borders? I assume there is an option somewhere with a box that needs checked! LOL Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change the color/type of the borders I put on cells? | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
