which shows the address of the current selection or active cell
Answers
Answered by
1
ᴇᴠᴇʀʏ ᴄᴇʟʟ ɪɴ ᴛʜᴇ sʜᴇᴇᴛ ʜᴀs ɪᴛs ᴏᴡɴ ᴀᴅᴅʀᴇss. ᴡᴇ ᴄᴀɴ ғɪɴᴅ ᴛʜᴇ ᴀᴅᴅʀᴇss ʙʏ ᴛʏᴘɪɴɢ = ᴀᴅᴅʀᴇss(ʀᴏᴡ(), ᴄᴏʟᴜᴍɴ()) ɪɴ ᴛʜᴇ ᴀᴄᴛɪᴠᴇ ᴄᴇʟʟ ᴀɴᴅ ᴘʀᴇss ᴛʜᴇ “ᴇɴᴛᴇʀ ᴋᴇʏ”. ᴀɴᴅ ᴛʜᴇɴ ᴡᴇ ᴄᴀɴ ғɪɴᴅ ᴛʜᴇ ᴀᴅᴅʀᴇss ᴍᴏᴠᴇs ᴛᴏ ᴛʜᴇ ғᴏʀᴍᴜʟᴀ ʙᴀʀ ᴀɴᴅ ᴅɪsᴘʟᴀʏs ᴛʜᴇ ʀᴇϙᴜɪʀᴇᴅ ᴀᴅᴅʀᴇss ɪɴ ᴛʜᴇ ᴄᴇʟʟ.
Similar questions