Software

Ask something
Discussion Locked

Excel

0 helpful
6 replies

by sfolsom

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

6 replies

by simonchan

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.

by lo

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

This discussion is closed to new replies.