Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the Excel formula for adding 1 column with several rows? | New Users to Excel | |||
HELP - Excel 2003 VERY SLOW vs 2002 | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Excel 2003 and Labels (NOT Address Labels) | Excel Discussion (Misc queries) |