I'm very raw at Excel- when I do reports the width of columns stays the same on all pages. I want different widths on page 2 than page one, page 3 different than page 2, etc- how is that done- probably pretty simple I hope- THANKS Gary from Ohio
I'm very raw at Excel- when I do reports the width of columns stays the same on all pages. I want different widths on page 2 than page one, page 3 different than page 2, etc- how is that done- probably pretty simple I hope- THANKS Gary from Ohio
Not simple. Column widths in Excel are the same all the way down a worksheet. You would need to print page 1, resize the columns, print page 2, ...
Entia non sunt multiplicanda sine necessitate
You will need to do it one spreadsheet at a time I mean adjusting column widths for your projects.
thanks for the input. to clarify- doing a one page spreadsheet at a time means each sheet would have no cell references usable from & to the other pages, correct?
I'm doing a 6 page spreadsheet that has 25 year loan amortizations, & dozens of variables all throughout the 6 pages & all using variables from the other pages. But the report is basically unviewable when the column widths of the 1st page have to stay the same through the next 5 pages. It seems Excel is too cumbersome to use- am I correct?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks