Can someone please tell me how to put the actual category names in place of the A B C D etc??????? a
K Karen Apr 18, 2007 #1 Can someone please tell me how to put the actual category names in place of the A B C D etc??????? a
D dlw Apr 18, 2007 #2 a b c d are fixed column headings, you need to put your names below them, in a1, b1, c1, etc, if you want you can shade them to look nice, too.
a b c d are fixed column headings, you need to put your names below them, in a1, b1, c1, etc, if you want you can shade them to look nice, too.
G Gord Dibben Apr 18, 2007 #3 Karen Cannot be done Use row 1 for your titles then select A2 and Window>Freeze Panes so row 1 is always in view. Tools>Options>View. Uncheck Row and Column Headers if you don't want to see them. Gord Dibben MS Excel MVP
Karen Cannot be done Use row 1 for your titles then select A2 and Window>Freeze Panes so row 1 is always in view. Tools>Options>View. Uncheck Row and Column Headers if you don't want to see them. Gord Dibben MS Excel MVP