General discussion

Locked

Excel

By sfolsom ·
Say you have a workbook with 15 worksheets in it. I want to take my information and copy from one worksheet to another but the trick is I want the formating that I have done in the other sheet(column widths, color, etc.) to come over so I want have to do anything to it?

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel

by simonchan In reply to Excel

Instead of using the normal paster procedure, you should use the Edit, Paste Special.. command.
Then a window will pop up, and you may choose either Formulas or Values instead of the default, All.

Collapse -

Excel

by sfolsom In reply to Excel

Poster rated this answer

Collapse -

Excel

by sfolsom In reply to Excel

Point value changed by question poster.

Collapse -

Excel

by Lo In reply to Excel

If you want a copy of a a full sheet, you can copy the sheet, Right Click the Sheet's tab, Select Move or Copy, Check the Create a Copy box, select where to copy. Change name or rename after copy as desired.

If you want a copy of all sheets makea copy of the file from DOS or Win Explorer with a different file name or different directory.

Been a while, but I have copied sheets and parts of sheets from one workbook to another. I think doing that formatting and such copied. I think this worked better when I did the full sheet or copied rows or columns (widths and such came with it).

lo

Collapse -

Excel

by sfolsom In reply to Excel

This worked with ease. THANX!

Collapse -

Excel

by sfolsom In reply to Excel

This question was closed by the author

Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums