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

Rulers in word 2007 2
[Excel 2010] how to get a horizontal scroll bar form control 2
Horizontal Line Graphic 2
Vertical Ruler is checked under the View Menu 1
Menu Macro Not Executing - Need Help 1
Horizontal and Vertical Rulers 2
Disappearing Rulers 1
Horizontal and Vertical Rulers 1

Top