In Excel 2007, how does one view horizontal and vertical rulers?
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! |
In Excel 2007, how does one view horizontal and vertical rulers?
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 -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Deeny H" wrote in message ... 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! |
In Excel 2007, how does one view horizontal and vertical ruler
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 "Bernard Liengme" wrote: 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 -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Deeny H" wrote in message ... 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! |
All times are GMT +1. The time now is 05:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com