Excel – How to fill cell reference down column without changing cell reference

microsoft excelworksheet-function

I have a column of cells, all of which I want to equal the value in another cell. I highlight the cell and type = and then do that again below, and then I highlight the cells and drag down but the column of cells equals a parallel column of values. I want it to fix to one cell. Does this make sense? I'm sure it's easy but I cannot figure it out.

Best Answer

If the cell you want to reference is A3, make your formula: =$A$3

The dollar signs make the cell reference absolute, so they won't be adjusted relative to where you paste.

Related Solutions

Excel – How to Dynamically Reference Named Table Column

You nearly had it with INDIRECT(), but your logic was a little off. Try this instead:

=COUNT(INDIRECT("Table1["&A1&"]"))

The key to remember is that INDIRECT() only takes text (i.e., a string) for the first argument. Thus, you have to pass all parts of the table reference to the function as text.

Best Answer

Related Solutions

Excel – How to Dynamically Reference Named Table Column

Related Question