Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I maintain format of worksheets when combining several?
I've combined several worksheets under one file name and would like to keep
the size, format of each one, i.e., size of columns. What happened was the widest columns applied to all worksheets. Please advise on how I can keep/maintain the size of columns of each worksheet. Thank you. |
#2
|
|||
|
|||
How did you "combin[e them] under one file name?"
-- Vasant "OC" wrote in message ... I've combined several worksheets under one file name and would like to keep the size, format of each one, i.e., size of columns. What happened was the widest columns applied to all worksheets. Please advise on how I can keep/maintain the size of columns of each worksheet. Thank you. |
#3
|
|||
|
|||
I copied the other worksheets, pasted them on this one worksheet and use the
latter's file name as the name for the "new" worksheet which now has all the other worksheets. "Vasant Nanavati" wrote: How did you "combin[e them] under one file name?" -- Vasant "OC" wrote in message ... I've combined several worksheets under one file name and would like to keep the size, format of each one, i.e., size of columns. What happened was the widest columns applied to all worksheets. Please advise on how I can keep/maintain the size of columns of each worksheet. Thank you. |
#4
|
|||
|
|||
Well, if you pasted all the information into a single worksheet, there is no
way to change the size of a column for different sections of the worksheet; you would have to use the width of the widest section for the entire worksheet. -- Vasant "OC" wrote in message ... I copied the other worksheets, pasted them on this one worksheet and use the latter's file name as the name for the "new" worksheet which now has all the other worksheets. "Vasant Nanavati" wrote: How did you "combin[e them] under one file name?" -- Vasant "OC" wrote in message ... I've combined several worksheets under one file name and would like to keep the size, format of each one, i.e., size of columns. What happened was the widest columns applied to all worksheets. Please advise on how I can keep/maintain the size of columns of each worksheet. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
How do I format all worksheets in a workbook at one time ? | Excel Discussion (Misc queries) | |||
save a new number format for other worksheets | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |