Cut and Paste with Formatting?

bobmc · Apr 9th, 2002, 05:33 PM

Hi gang...this one's probably pretty easy, but my little brain hasn't found it yet.

I need to copy approx. four pages of a workbook to another workbook. The problem is that all of the formatting within those four pages is lost when I try to paste it into the other workbook.

Any ideas? Help is GREATLY appreciated!

Thanks.

Anne Troy · Apr 9th, 2002, 06:14 PM

Bob. Right-click the sheet tab and copy the WHOLE sheet. Then delete what you DON'T want.

Apr 9th, 2002, 06:14 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Bob. Right-click the sheet tab and copy the WHOLE sheet. Then delete what you DON'T want. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 05:33 PM	#1
bobmc Board Regular Join Date: Mar 2002 Posts: 142	Hi gang...this one's probably pretty easy, but my little brain hasn't found it yet. I need to copy approx. four pages of a workbook to another workbook. The problem is that all of the formatting within those four pages is lost when I try to paste it into the other workbook. Any ideas? Help is GREATLY appreciated! Thanks.