change column headings to inches

[still learning]

Hi
i'm using 365
I sort a remember that in older versions of excel, I was able to change the A,B,C, and the 1,2,3,to inches.
Was I dreaming?
I'm trying to make a business card and i don't want to keep changing the fonts and printing them till i get the size right.


mike

 

[Yongle]

File tab \ Options \ Advanced tab \ do down to DISPLAY section \ select INCHES as Ruler Unit in dropdown
( displays within the rulers in Page Layout view )

 

[still learning]

Hi Yongle
I tried that.
nothing in the workbook or worksheet changed. I still have letters on top and numbers down the side
I also tried closing the program and opening it again after i changed it to inches.
in the tab view (File.Home, Insert, etc.) there is a box for ruler, but is not accessible.


mike

 

[SpillerBD]

You need to in Page Layout View

 

[still learning]

I must be doing something wrong
I went to
File
Options
Advance
Display
The drop down box has 4 options:
Default
Inches
Centimeters
Millimeters
the other 2 display sections have no drop down box (Display options for workbook) (Display options for worksheet)
I also clicked on OK to exit