Backstory:

I work in the financial industry and I’m in excel for about 6 hours a day doing a variety of tasks, mostly balance sheets for clients. Typically I am able to locate an answer after a few google searches, but I am having upmost difficulty finding a solution to this specific problem, maybe because it is so niche. 

The Problem: 

I often reference a cell in a separate “Balance Sheet” tab within the same excel file with no issues. The cell on the balance sheet has a note identifying what the value represents (i.e. the cell will have $10.00 value and the note will say “Cash in Pocket”). When going to reference the cell, lets say ‘H11’ is the cell I want to reference, sometimes I will have to click on cell ‘H10’ and use my keyboard arrows to shift down to H11. (when the note is displayed on the cell, sometimes it prevents a simple click on the cell). With all this being said, sometimes when I click the cell it will read “$H$10” instead of “H10”. (I know the ‘$’ means that this cell reference is locked). The $ prevents me from using the arrows on the keyboard to move down to the correct cell. 

The Question: 

What setting could I adjust to ensure that the ‘$’ doesn’t automatically appear when I click the cell? 

​Backstory:I work in the financial industry and I’m in excel for about 6 hours a day doing a variety of tasks, mostly balance sheets for clients. Typically I am able to locate an answer after a few google searches, but I am having upmost difficulty finding a solution to this specific problem, maybe because it is so niche.  The Problem: I often reference a cell in a separate “Balance Sheet” tab within the same excel file with no issues. The cell on the balance sheet has a note identifying what the value represents (i.e. the cell will have $10.00 value and the note will say “Cash in Pocket”). When going to reference the cell, lets say ‘H11’ is the cell I want to reference, sometimes I will have to click on cell ‘H10’ and use my keyboard arrows to shift down to H11. (when the note is displayed on the cell, sometimes it prevents a simple click on the cell). With all this being said, sometimes when I click the cell it will read “$H$10” instead of “H10”. (I know the ‘$’ means that this cell reference is locked). The $ prevents me from using the arrows on the keyboard to move down to the correct cell.  The Question: What setting could I adjust to ensure that the ‘$’ doesn’t automatically appear when I click the cell?   Read More

​