T T-®ex Sep 2, 2005 #1 Hi! I'd like to know if it's possible to hide the column (and row) "headers" in Excel... If it is, how do I do it?
Hi! I'd like to know if it's possible to hide the column (and row) "headers" in Excel... If it is, how do I do it?
N Norman Jones Sep 2, 2005 #2 Hi T-®ex, Tools | Options | View | deselect 'Row & Column headers' If you need to do this programmatically, try something like: ActiveWindow.DisplayHeadings = False
Hi T-®ex, Tools | Options | View | deselect 'Row & Column headers' If you need to do this programmatically, try something like: ActiveWindow.DisplayHeadings = False
T Tempy Sep 2, 2005 #3 Hi T-®ex, I used the code below Range("Headers").EntireRow.Hidden = True - For a Named range Rows("1:1").EntireRow.Hidden = True Columns("A:A").EntireColumn.Hidden = True Tempy
Hi T-®ex, I used the code below Range("Headers").EntireRow.Hidden = True - For a Named range Rows("1:1").EntireRow.Hidden = True Columns("A:A").EntireColumn.Hidden = True Tempy