View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AndrewEdmunds AndrewEdmunds is offline
external usenet poster
 
Posts: 20
Default Creating names for individual cells over a range

Hello,

I have a three column balance sheet (actual, budget, prior year). I wanted
to define the names of all of the cells in that balance sheet through the row
and column headings. What I did to attemp to do this was I highlighted the
balance sheet with my row headings in the far left column and my column
headings in the top row. I selected Insert - names - create and when the box
came up I selected create names from the top row and left column. So if I
wanted to use cash from the actual column, I couldn't figure out what cell
reference to use. If I use =cash, the entire cash row is selected, if I use
Actual, the entire actual column is selected. I didn't know how to point to
actual - cash so the individual cell is selected. Am I using the wrong
method, or am I not typing in the right cell reference.
--
Thank You
Andrew Edmunds