LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to appy range names to formulas which use single cells in rang Dima Excel Worksheet Functions 5 August 10th 08 09:55 AM
convert a range of cells into individual worksheets? KL in OK Excel Discussion (Misc queries) 1 January 23rd 08 01:11 AM
Sum Array Range & Individual Cells Native Excel Discussion (Misc queries) 1 December 5th 07 08:10 PM
creating a simple formula for a range of cells Christopher[_2_] Excel Discussion (Misc queries) 3 February 21st 07 08:04 AM
Excel should lock individual cells or range only centrality Excel Worksheet Functions 1 June 30th 06 08:06 PM


All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"