column width

[afoster]

Hello everyone,

this is my first time posting and i'm really learning a lot in this
forum. I have a question and i hope someone could please help me.

I'm currently entering information on a excel spreadsheet that i
created that is 7 pages long. i've been told recently that the
spreadsheet needs to be reduced to 3 pages. i've reduced the font, but
my problem is i'm not sure how to make excel change each page to
reflect different column widths for each page. i've merged various
cells, and that has helped a little, but for the most part, each column
seems to still take on the same width as the first page. whenever i
attempt to widen a column on (say, for example, page 3), it changes the
width of all of the columns on all of the other pages before and after
as well when i only wanted to change the column width of one particular
page. each page has different information that requires the column
width to be various sizes and i'm truly at a loss as to how i can
remedy this. is there any way each page can be independent of the
others as far as the columns are concerned?

please help me if you can.......thanks

 

[Dave Peterson]

When you write about pages, does this mean printed pieces of paper?

Or is it separate worksheets within your workbook?

If all your data is in a single worksheet, then you've seen that columnwidth
goes all the way down all the rows.

You can try to merge cells to make it look different in certain parts, but it is
the columnwidth--not the cell width.

On the other hand, if you're actually writing about separate worksheets within
the same workbook, make sure you don't have the worksheets grouped (multiple
sheets selected at the same time) when you adjust the columnwidths.

xl tries to help by displaying [Group] in the title bar. If you see this, you
can rightclick on any of the grouped sheets and select "Ungroup Sheets".

 

[D Warcken]

Ithink what I would do is separate each "page" into a separate
worksheet within that workbook. You could use the "move or copy"
command in the edit menu (be sure to check "copy"). That would preserve
your already entered data and then you could change the column widths
in each sheet however you wanted.