Sheet Format

LarryLi · Apr 4th, 2002, 02:43 PM

When I copy a sheet to a new work book, the sheet format in the new book will not change. However, when I copy the same sheet to an existing work book, sometimes the sheet format (such as column width) would be changed. Why?

Thanks.

Jack in the UK · Apr 4th, 2002, 04:39 PM

HI

Excel drops the formatting only taking the cell data??? way it works

FIX i use format painter to correct this easy as one click and reset ...

HTH

Jack in the UK · Apr 4th, 2002, 04:42 PM

Hi

Eh! what am i saying copy paste should be all ok, formula and such will return answer only not the formatting... sorry mislead you there...

Vlookup are common for this as they carry cells with lots of data typed say 6 lines all diff colours this will be lost and end up all default (black)

Apr 4th, 2002, 04:39 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	HI Excel drops the formatting only taking the cell data??? way it works FIX i use format painter to correct this easy as one click and reset ... HTH __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Apr 4th, 2002, 04:42 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi Eh! what am i saying copy paste should be all ok, formula and such will return answer only not the formatting... sorry mislead you there... Vlookup are common for this as they carry cells with lots of data typed say 6 lines all diff colours this will be lost and end up all default (black) __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

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

Apr 4th, 2002, 02:43 PM	#1
LarryLi New Member Join Date: Apr 2002 Location: New York Posts: 1	When I copy a sheet to a new work book, the sheet format in the new book will not change. However, when I copy the same sheet to an existing work book, sometimes the sheet format (such as column width) would be changed. Why? Thanks.