Copying and Pasting from One Sheet to Another

G

Guest

I have two sheets in my spreadsheet, and I copy rows from sheet one to sheet
two. Each sheets cells have different formatting (i.e. different fonts, font
size, color etc). When I copy from Sheet One and paste into Sheet Two, the
formatting does not convert over to Sheet Two's format, it stays in the
format defined in Sheet One. Is there some way that when I paste into Sheet
Two, the data gets converted into the format in Sheet Two?

Thanks
 
G

Guest

One way to do this is with "Edit" - "Paste Special" - "Values". The paste
will not change the cell formating.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the columns from one sheet and paste it in another sheet 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Lookups - how to obtain data from a master spreadsheet into another 5
Copy Data from One sheet to Different Sheets 1
Another question 5
Extracting data from multiple new workbooks via one master workboo 1
Help with copying a sheet from One workbook to another workbook 1
copying one sheet to another workbook 3

Top