LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 390
Default cell names in functions

Hi there,

cell names are great to identify the cells, but when used in a formula, I
can not drag them like normal cell references (ie: A1), they seem to be more
like th efixed type (ie $A$1), but I can not unlock those (F4 key does not
hold for these references), does anyone know the solution for this?

Obviously, I can select th ecell name in the formula, replace it with a
normal reference and drag this, but I think it is quite inconvenient...
Besides, after this, the formula keeps refering to a cell reference, not to a
cell name.

Thanks in advance,

Max
 
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
IF functions and Names Ranges JaB Excel Discussion (Misc queries) 1 January 18th 07 12:30 PM
working with names and functions ngg Excel Worksheet Functions 3 November 30th 06 10:39 PM
Excel functions names should be in English for all Localized versi furia Excel Worksheet Functions 0 May 16th 06 03:58 PM
Tracking worksheet names in functions locutus243 Excel Worksheet Functions 8 December 5th 05 08:56 PM
are variable table-array names in functions possible? JimH Excel Discussion (Misc queries) 2 April 7th 05 09:51 PM


All times are GMT +1. The time now is 07:11 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"