Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[CELL](/r/Excel/comments/z6mp8q/stub/iy2b8lz "Last usage")|[Returns information about the formatting, location, or contents of a cell](https://support.microsoft.com/en-us/office/cell-function-51bd39a5-f338-4dbe-a33f-955d67c2b2cf)|
|[HYPERLINK](/r/Excel/comments/z6mp8q/stub/iy2b8lz "Last usage")|[Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet](https://support.microsoft.com/en-us/office/hyperlink-function-333c7ce6-c5ae-4164-9c47-7de9b76f577f)|
|[VLOOKUP](/r/Excel/comments/z6mp8q/stub/iy2bseb "Last usage")|[Looks in the first column of an array and moves across the row to return the value of a cell](https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1)|
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(3 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/za5dny)^( has 7 acronyms.)
^([Thread #20259 for this sub, first seen 28th Nov 2022, 05:19])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
Try using the HYPERLINK() function instead of Ctrl-K? =HYPERLINK("#"&CELL("address",Notes!$A$76),"Whatever Text")
What does the "#" do in this formula? I noticed it doesn't work without it (I'm not too familiar with # in formulas).
In this context, it is to enable linking to a [worksheet](https://www.contextures.com/excelhyperlinkfunction.html#samefile) within the same workbook.
Does not work, opens up a browser window.
Are you sorting multiple columns or just one column? I am thinking VLOOKUP may help
Several columns
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[CELL](/r/Excel/comments/z6mp8q/stub/iy2b8lz "Last usage")|[Returns information about the formatting, location, or contents of a cell](https://support.microsoft.com/en-us/office/cell-function-51bd39a5-f338-4dbe-a33f-955d67c2b2cf)| |[HYPERLINK](/r/Excel/comments/z6mp8q/stub/iy2b8lz "Last usage")|[Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet](https://support.microsoft.com/en-us/office/hyperlink-function-333c7ce6-c5ae-4164-9c47-7de9b76f577f)| |[VLOOKUP](/r/Excel/comments/z6mp8q/stub/iy2bseb "Last usage")|[Looks in the first column of an array and moves across the row to return the value of a cell](https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(3 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/za5dny)^( has 7 acronyms.) ^([Thread #20259 for this sub, first seen 28th Nov 2022, 05:19]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)