| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
Hi all,
Under the paste special option there is a option to past "all except borders". is there a way to only paste the borders and nothing else? Cheers, Neil |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special
Doesn't appear to be such a possibility. The closest if Paste Formats, but
that grings over the content formatting (number, date, etc.) and background fill. -- TedMi |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special
paste special | format | ok
On Apr 10, 3:34*pm, Neil Pearce wrote: Hi all, Under the paste special option there is a option to past "all except borders". *is there a way to only paste the borders and nothing else? Cheers, Neil |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special
Sounds like I'll have create a Macro that copies and 'special pastes: format
only' the selected area, and then reset the format of the selected area back to the required state. Thanking-you for the help chaps. Cheers, Neil "muddan madhu" wrote: paste special | format | ok On Apr 10, 3:34 pm, Neil Pearce wrote: Hi all, Under the paste special option there is a option to past "all except borders". is there a way to only paste the borders and nothing else? Cheers, Neil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| 'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
| PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
| In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
| Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions | |||
Hybrid Mode
