ruller bar

[JERRY]

I am having difficulty with measuring the width and heigth of cells. I can't
figure out the formula if I want to set the height to .5 inch and the
width to 1.5 inch. Under View, Ruller bar is checked but greyed out. I can't
get any ruller bar (horizontal or vertical) to come up. I am stumped???

Any held would be appreciated

Jerry

 

[Tyro]

To see the ruler, you have to be in Page Layout view Or Page Break Priview
view.

Tyro

 

[Gord Dibben]

Is this "ruler" something new in Excel 2007?

Is "Page Layout View" something new in Excel 2007?


Gord Dibben MS Excel MVP

 

[Tyro]

Yes, it is. It shows you exactly how the spreadsheets will print, like print
preview. You can work entirely in Page Layout View.

Tyro

 

[Bernard Liengme]

Page Layout is on the Ribbon (cf Page Break View in Xl2003)
I think the ruler is a total figment
best wishes

 

[Tyro]

I should clarify. The ruler is like the ruler in Word.

Tyro

 

[Gord Dibben]

Thanks Bernard.

Gord

 

[Gord Dibben]

Thanks.

One of these days<g>

Have the CD sitting there awaiting my decision.


Gord

 

[Tyro]

Page Layout View is totally new in Excel 2007. It allows you to work with
your sheet, like a document in Word with rulers.
I think the ribbon is so much better than the drill down menus in previous
versions. Everything I had is there, including my custom toolbars and menus.
The ribbons is very intuitive. Great in my humble opinion.

Tyro

 

[Tyro]

Professor Liengme.

Would you take a look at a worksheet consolidation problem I have with the
consolidated sheet being out of sequence?
Thanks

Tyro

 

[Bernard Liengme]

Sure, send the file to my private email not the group

 

[Tyro]

I sent an e-mail to the address below and it failed to go through.
Tyro

 

[Dave Peterson]

Did you follow Bernard's note:

I sent an e-mail to the address below and it failed to go through.
Tyro

 

[Tyro]

Why bother putting caps in, if they have to be removed?

 

[Dave Peterson]

By munging his email address, Bernard was trying to make it difficult for
spambots to glean his email from these newsgroups.

A real human will be able to follow the instructions <vbg> and send a message.
Bernard is hoping that the spambots don't get sophisticated enough to do the
same.

MS explains it here:
http://www.microsoft.com/library/ga...ales/help/help_en-US.htm#AboutEmailAndPrivacy

 

[Tyro]

My email works fine with or without caps

tyro

By munging his email address, Bernard was trying to make it difficult for
spambots to glean his email from these newsgroups.

A real human will be able to follow the instructions <vbg> and send a
message.
Bernard is hoping that the spambots don't get sophisticated enough to do
the
same.

MS explains it here:
http://www.microsoft.com/library/ga...ales/help/help_en-US.htm#AboutEmailAndPrivacy

 

[Tyro]

now I have to send to him for the 3rd time.

Tyro

 

[Tyro]

I thought he meant make TRUENORTH truenorth
He should have said, remove truenorth from my emal address and make it
(e-mail address removed)

tyro

now I have to send to him for the 3rd time.

Tyro

 

[Tyro]

I don't use my real email address here. Too smart to do so. No spam bot
bothers me.

 

[Tyro]

I am a real human being. You are a jerk. No <vbg>