Hi,

this option is only available in Page Layout view.

1. Choose View, Page Layout in the Workbook Views group
2. Or click the Page Layout button on the right side of the Status bar - the
2nd of the 3 buttons beside the Zoom controls.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Rodney" wrote:

Cant get the ruler to display in 2007 excel and the "tick box" in options is
ticked but faint. Help please ?

--
Rodney