Hide row and column references

jgoulart · Mar 10th, 2002, 12:31 PM

How can I hide the row and column references in excel. I'm not sure exactly what they are called but I'm talking about the row numbers and column labels.

John

waggy30 · Mar 10th, 2002, 12:33 PM

Goto Tools: Options: View Tab, and untick the box 'Row and Column Headers'

Mudface · Mar 10th, 2002, 12:35 PM

In VBA, use: -

ActiveWindow.DisplayHeadings = False

(make sure you turn it back on

).

[ This Message was edited by: Mudface on 2002-03-10 11:36 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 10th, 2002, 12:31 PM	#1
jgoulart Board Regular Join Date: Feb 2002 Location: John G Posts: 62	How can I hide the row and column references in excel. I'm not sure exactly what they are called but I'm talking about the row numbers and column labels. John

Mar 10th, 2002, 12:33 PM	#2
waggy30 New Member Join Date: Mar 2002 Location: England Posts: 46	Goto Tools: Options: View Tab, and untick the box 'Row and Column Headers'

Mar 10th, 2002, 12:35 PM	#3
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	In VBA, use: - ActiveWindow.DisplayHeadings = False (make sure you turn it back on ). [ This Message was edited by: Mudface on 2002-03-10 11:36 ]