Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preserve borders during copy and paste?
Is it possible to preserve your border and font formats in a document when
pasting data from another worksheet which does not have the same font size and border style. Currently when I copy and paste, the font and borders of the data from which I am copying overrides the formatting of the sheet that I am pasting to. I would like the format of the sheet I am pasting the data on to preserve it's formatting regardless of the format of the copied data. Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preserve borders during copy and paste?
Perhaps Copy and Paste SpecialValuesOKEsc
Or Paste SpecialFormulas and Number Formats Or Paste SpecialValues and Number Formats. Gord Dibben MS Excel MVP On Tue, 11 Jul 2006 14:39:20 GMT, "aarotu" <u23988@uwe wrote: Is it possible to preserve your border and font formats in a document when pasting data from another worksheet which does not have the same font size and border style. Currently when I copy and paste, the font and borders of the data from which I am copying overrides the formatting of the sheet that I am pasting to. I would like the format of the sheet I am pasting the data on to preserve it's formatting regardless of the format of the copied data. Thank you |
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) | |||
copy & paste formula between spreadsheets - not working | Excel Worksheet Functions | |||
Copy / Paste Warning | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) |