Page layout

[Morgan_Child]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Hi,

Imagine one page of an Excel worksheet. Now, imagine that the page is divided into a top and bottom portion by a red stripe of color.

OK.

The width of the columns in the top portion of the page is, say, one inch. Is there a way for me to have the columns in the bottom portion of the page be, say, one and a half inches? So: One page with columns of different widths at the top and bottom.

I hope you can imagine what I'm trying to say; if so, please reply in the simplest of terms with step-by-step directions.

Thank you very much.

 

[CyberTaz]

The only way would be to used merged cells, which is a certain path to
self-destruction of the file.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[richardf]

Excell can't do this. It's one of the many things that Bill Gates' Little Helpers haven't thought of. There is a DTP suite which includes a spreadsheet application that can easily do what you want - but it isn't Excel - so I better not mention it here.

 

[CyberTaz]

You're welcome to mention whatever you wish as long as it's appropriate &
on-topic. This is a user-to-user newsgroup where our singular purpose is to
assist one another in any way we can. Granted, the main focus is on the use
of MS software [Excel in this particular case] but it isn't uncommon to
suggest software from other developers for any particular situation ‹ MS
knows full well & accepts that there software doesn't cover all the bases.

In fact, I'd really like to know what "DTP suite" you're referring to. If
the OP had given a more thorough description of what s/he were trying to
accomplish perhaps it would be a viable suggestion.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[richardf]

You're welcome to mention whatever you wish as long as it's appropriate &

on-topic. This is a user-to-user newsgroup where our singular purpose is to
assist one another in any way we can. Granted, the main focus is on the use
of MS software [Excel in this particular case] but it isn't uncommon to
suggest software from other developers for any particular situation � MS
knows full well & accepts that there software doesn't cover all the bases.

In fact, I'd really like to know what "DTP suite" you're referring to. If
the OP had given a more thorough description of what s/he were trying to
accomplish perhaps it would be a viable suggestion.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Excell can't do this. It's one of the many things that Bill Gates' Little
Helpers haven't thought of. There is a DTP suite which includes a spreadsheet
application that can easily do what you want - but it isn't Excel - so I
better not mention it here.

I did once mention the name of the DTP referred to in my posts. Pretty soon there appeared a post saying "This subject is closed" That's why I don't mention it. What bugs me about Excel is - it seems unable to do simple, obvious things. Like allow different column widths on one page. Like allow me to hide individual cells, or ranges, or sheets, from the printer but show them on the screen. And this Little Beauty! My German DTP suite allows me to hand-edit individual cell values WITHOUT ERASING THE CELL FORMULA. This is done by writing a "second formula" into cells.(There are TWO formula bars for all cells) Any cell with a second formula does not update on "Calculate" unless the second formula is returning "true" So if you want cells not to update, you might write for the "Second formula" something as simple as 2>3. And further (and better!!), any cell which holds a "second formula" can have its value edited by hand without erasing either of the cell's two formulae. These 2 features allow the user to do magic. e.g. Hide parts of a single sheet from "Calculate" (without using "ifs"); update sheets sequentially by changing the value in a "master" cell which send values to the "second formulae"; enter experimental cell values by hand to check calculations etc.

 

[CyberTaz]

<snip>

I did once mention the name of the DTP referred to in my posts. Pretty soon
there appeared a post saying "This subject is closed" That's why I don't
mention it.

<snip>

The thread may have been closed but I'll guarantee it wasn't because of any
mention of competitive product. It's **rare** that a thread gets closed in
these forums... And when it happens it's usually for a very good reason.

Regards |:>)
Bob Jones
[MVP] Office:Mac