Propagating a formula which references a named cell

		Microsoft Office Forums > Microsoft Excel > Excel
Propagating a formula which references a named cell

FAQ

Mark Forums Read

Thread Tools

Display Modes

06-03-2015, 08:06 AM

Pecoflyer

Windows 7 64bit Propagating a formula which references a named cell

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Go to the Name Manager ( formula ribbon), select the name and remove the $ sign from the row reference in the "refer to" field

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula in cell b1 using cell a1 if a1 is over certain number	pumkinbug87	Excel	5	12-03-2013 12:34 PM
Macro to change cell references	SaneMan	Excel Programming	6	10-01-2013 02:49 PM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM
Can't use a zero in a named cell	TechEd	Excel	2	10-16-2012 10:06 PM
Formula that references cell with text in different workbook	no1texan	Excel	3	07-17-2012 05:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:22 PM.