In Excel 2007, how does one view horizontal and vertical rulers?

D

Deeny H

When I try to click on rulers (it is checked but grayed out), I cannot get my
vertical ruler or horizontal scroll bar to appear. What am I doing wrong?
Thanks!
 
B

Bernard Liengme

1) View | Worksheet View | Page Layout 'so you see the worksheet with
headers etc
2) View| Show/Hide | check Ruler ' now both rules are present
You may need to scroll down a little to see numbers on the vertical ruler
best wishes
 
D

Deeny H

Bernard, you are a genius!! Thank you so very much for your help. Is there
any way I can save the view with the ruler and scroll as the default view?

Thanks again!

DeenyH
 

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

Similar Threads

Excel Finding rulers in Excel 2007 0
Rulers in word 2007 2
Horizontal and Vertical Rulers 1
Disappearing Rulers 1
Excel should have vertical and horizontal rulers. 1
How to switch off pop-up rulers? 5
How to I show the horizontal scroll bar in Excel? 2
How do i fix the horizontal and vertical position of a slide? 1

Top