Usually, in this context, it means you are about to create a formula using one of more cells. It can also be used to indicate that whatever follows it is a cell reference. +a1 means column row 1.
One source claimed The plus sign is significant only if the content of the cell does not start with =. It that case it makes the text a formula. If you type A1+B1, it’s just a string. But +A1+B1 is a formula.
Then the minus sign is displayed on the left of selected rows, or displayed at the top of the selected columns. Click the minus sign, the selected rows or column are hidden immediately. And click the Plus sign, the hidden rows or columns are showing at once.
What happens when I double click a cell in Excel?
As shown below with this setting switched on, if I double click in cell G15, it highlights the cells in G6 and G11 as the formula is G11 x G6. It will also jump to other sheets if the formula links to another sheet. Depending on your settings, double clicking a cell to follow the formula might not work, but instead allow you to edit the cell.
When you double click on a border of a selected cell, you go to the end of the list depending on which side of the selected cell you double clicked on. How do you disable this?
What is the dollar sign used for in Excel?
A very useful and common symbol used in Excel is the dollar sign within a formula. Note that this does not indicate currency; rather, it’s used to “fix” a cell address in place in order that a single cell can be used repetitively in multiple formulas by copying formulas between cells.
By adding a dollar sign ( $ ) in front of the column header (C) and the row header (3), when copying the formula down to Rows 7–15 in the example below, the first part of the formula.
Why is my formula not working when I double click?
Depending on your settings, double clicking a cell to follow the formula might not work, but instead allow you to edit the cell. Depending on what you prefer below how to switched it on or off. Time needed: 1 minute. The default setting when you double click a cell is it allows you to edit the cell without going to the formula bar.
Why does my Excel formula jump to other sheets?
It will also jump to other sheets if the formula links to another sheet. Depending on your settings, double clicking a cell to follow the formula might not work, but instead allow you to edit the cell. Depending on what you prefer below how to switched it on or off.