#Lock the formula bar in excel for mac pdf

I tried it on several new/different spreadsheets but it keeps happening. I ran a scan for viruses and none were found. Has anyone ever seen this before? I have no idea what is going on. It is like the act of putting the cursor in the formula activates it to work properly but until it is activated that C cell shows the value of the cell which it was dragged down from. When I click on the Column C cells and then it shows the formula up top in the formula bar and if I put my cursor anywhere in the formula bar and hit Return the formula does not change however the correct value then appears in the Column C cell. For instance, the formula in C2 is =A2/B2 however the value of that cell showed 542 which was not the correct math/value.īut it gets even more weird. And when I went to check to see if the formula was correctly dragged it was. So I dragged that formula down and it showed 542 in all column C cells which is not correct. The math was correct it showed 542 in the C1 cell.

#Lock the formula bar in excel for mac pdf

No more restrictions to extract pages and copy & paste PDF text. The formula bar allows the users to input formulas easily into a cell in Excel. then in column C, I made the formula C1=A1/B1. Microsoft Excel 2016 has a easy button feature on the main top toolbar that allows users to view or hide the formula bar from the toolbar. I typed in values for column A rows 1 through 10 then values for column B rows 1 through 10.

I know that I could get him to just click save each time before really looking at the results, but that is just a band aid to the problem. I can also just click the top cell after filling in the formula and then drag the bottom right of the cell downward and it will do the same of filling in the correct formula, but have the incorrect value. Mine has Office 2010, so I think there might be an issue with the file itself.Īlso, not just copy and paste. I am trying this on his workstation and mine. When I click save, it will change the display value to 80.

Right click A3, Copy, right click B3, paste When copying a cell with a formula in it of '=D6+C6' and pasting it into the next cell down, it will display the same value in the cell as the calculated value from above, but has the correct formula displayed in the formula bar of '=D7+C7'. I have a co-worker's file that he is having trouble with.