ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel (https://www.excelbanter.com/excel-discussion-misc-queries/139400-excel.html)

Karen

Excel
 
Can someone please tell me how to put the actual category names in place of
the A B C D etc??????? a

dlw

Excel
 
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.

"Karen" wrote:

Can someone please tell me how to put the actual category names in place of
the A B C D etc??????? a


Gord Dibben

Excel
 
Karen

Cannot be done

Use row 1 for your titles then select A2 and WindowFreeze Panes so row 1 is
always in view.

ToolsOptionsView. Uncheck Row and Column Headers if you don't want to see
them.


Gord Dibben MS Excel MVP

On Wed, 18 Apr 2007 07:20:03 -0700, Karen
wrote:

Can someone please tell me how to put the actual category names in place of
the A B C D etc??????? a




All times are GMT +1. The time now is 06:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com