change column headings to inches

still learning

Well-known Member
Joined
Jan 15, 2010
Messages
543
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

Well-known Member
Joined
Mar 11, 2015
Messages
4,883
Office Version
365
Platform
Windows
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

Well-known Member
Joined
Jan 15, 2010
Messages
543
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
 

still learning

Well-known Member
Joined
Jan 15, 2010
Messages
543
I must be doing something wrong :banghead:
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
 

Forum statistics

Threads
1,085,031
Messages
5,381,303
Members
401,733
Latest member
Kabasa007

Some videos you may like

This Week's Hot Topics

Top