Menu
may i know how to enable (CELL A1 in SHEET1)
=INDIRECT('SHEET2.A1')
to drag through columns and rows accordingly without having to type it out one by one
533
Using Excel INDIRECT function to lock a cell reference Enter any value in any cell, say, number 20 in cell A1. Refer to A1 from two other cells in different ways: =A1 and =INDIRECT("A1")
Formula Method The most obvious way to increment a number in Excel is to add a value to it. Start with any value in cell A1, and enter "=A1+1" in cell A2 to increment the starting value by one. Copy the formula in A2 down the rest of the column to continuously increment the preceding number.
Now there are three kinds of cell references that you can use in Excel: Relative Cell References. Absolute Cell References. Mixed Cell References.
Sometimes CELL function can be useful here, e.g.
=INDIRECT("'Sheet1'!"&CELL("address",A1))
That can be dragged down or across
50
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
