ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Creating Column and Rows labels in excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/108554-creating-column-rows-labels-excel-2003-a.html)

Alicia

Creating Column and Rows labels in excel 2003
 
Hello, Can anyone provide me with step by step instructions on how to create
a column and a row labels in excel 2003?

Gord Dibben

Creating Column and Rows labels in excel 2003
 
From Excel 2003 Help............

Convert existing row and column labels to names

Select the range you want to name, including the row or column labels.
On the Insert menu, point to Name, and then click Create.
In the Create names in box, designate the location that contains the labels by
selecting the Top row, Left column, Bottom row, or Right column check box.
Note A name created by using this procedure refers only to the cells that
contain values and does not include the existing row and column labels.

Specifying labels When you select cells in labeled ranges to create formulas,
Microsoft Excel can insert the labels in place of the cell references in your
formulas. Using labels can make it easier to see how a formula is constructed.
You can use the Label Ranges dialog box (Insert menu, Name submenu, Label
command) to specify the ranges that contain column and row labels on your
worksheet.


Gord Dibben MS Excel MVP

On Tue, 5 Sep 2006 08:49:02 -0700, alicia
wrote:

Hello, Can anyone provide me with step by step instructions on how to create
a column and a row labels in excel 2003?




All times are GMT +1. The time now is 08:22 PM.

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