column width

A

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

:)
 
D

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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top