ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how do i title columns (https://www.excelbanter.com/new-users-excel/9893-how-do-i-title-columns.html)

lawdogg

how do i title columns
 


gls858

If you don't have a blank row above your cols make sure
your cursor is in the first row. On the toolbar click Insert
then Row. You should now have a blank row across the top of your
sheet simply click in the cell and type.

gls858

Gord Dibben

If you mean change the A,B,C to something more meaningful such as "Name",
"Address", "City" etc., you can't.

You can use row 1 for your titles then select A2 or B2 if you also want column
A frozen and WindowFreeze Panes.

Now go to ToolsOptionsView and uncheck "Row and Column Headers".


Gord Dibben Excel MVP


On Tue, 25 Jan 2005 15:17:08 -0800, "lawdogg"
wrote:




All times are GMT +1. The time now is 11:16 AM.

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