Home

Persistent tags in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1007165%22%20slang%3D%22en-US%22%3EPersistent%20tags%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1007165%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20any%20feature%20in%20excel%20to%20have%20persistent%20tag%20for%20ROW%2C%20COLUMN%20and%20CELL%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1007165%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1007175%22%20slang%3D%22en-US%22%3ERE%3A%20Persistent%20tags%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1007175%22%20slang%3D%22en-US%22%3E%24F%242%20fixes%20both%20colum%20and%20row%20%24F2%20fixes%20the%20column%20and%20lets%20the%20row%20change%20when%20you%20drag%20the%20formula%20F%242%20fixes%20the%20row%20and%20lets%20the%20column%20change%20when%20you%20drag%20the%20formula%20Is%20it%20this%20you%20were%20asking%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1007183%22%20slang%3D%22en-US%22%3ERE%3A%20Persistent%20tags%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1007183%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F302344%22%20target%3D%22_blank%22%3E%40Celia_Alves%3C%2FA%3E%26nbsp%3BThanks%20for%20the%20quick%20reply.%20But%20I%20am%20not%20asking%20for%20same.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20wondering%20if%20I%20can%20give%20a%20persistent%20property%20%2C%20I%20can%20use%26nbsp%3B%3C%2FP%3E%3CP%3EExample%20-%20ID%20property%20of%20Cell.%20I%20can%20assign%20some%20thing.%3C%2FP%3E%3CP%3ERange(%22a1%22).Cells.ID%20%3D%201234%3C%2FP%3E%3CP%3EHowever%20if%20I%20close%20my%20workbook%20and%20open%20it.%20the%20value%20of%20ID%20is%20gone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1007377%22%20slang%3D%22en-US%22%3ERE%3A%20Persistent%20tags%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1007377%22%20slang%3D%22en-US%22%3EWould%20using%20a%20Name%20for%20the%20cell%20work%20for%20what%20you%20need%3F%20Google%20%22how%20ro%20create%20names%20in%20Excel%22%20and%20%22how%20to%20use%20named%20ranges%20in%20Excel%20formulas%22.%3CBR%20%2F%3EHere%20is%20an%20example%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftrumpexcel.com%2Fnamed-ranges-in-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftrumpexcel.com%2Fnamed-ranges-in-excel%2F%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
amitabhjain
Occasional Contributor

Is there any feature in excel to have persistent tag for ROW, COLUMN and CELL?

3 Replies
$F$2 fixes both colum and row $F2 fixes the column and lets the row change when you drag the formula F$2 fixes the row and lets the column change when you drag the formula Is it this you were asking?

@Celia_Alves Thanks for the quick reply. But I am not asking for same. 

I was wondering if I can give a persistent property , I can use 

Example - ID property of Cell. I can assign some thing.

Range("a1").Cells.ID = 1234

However if I close my workbook and open it. the value of ID is gone.

 

Would using a Name for the cell work for what you need? Google "how ro create names in Excel" and "how to use named ranges in Excel formulas".
Here is an example:
https://trumpexcel.com/named-ranges-in-excel/

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies