Trying to format multiple columns at once and the formula box pops up

I just upgraded to Excel 2016 and every time I try to format 2 columns at once, a formula box pops up. When I try to close it, Excel asks if I want to save my workbook, then it closes. Can anyone help me fix this?

I am running Excel2016 and have not encountered this.
My first reaction here would be to re-install and see if it goes away (it only takes 10 minutes)

But let's see if it is a more general issue:
Please detail all the steps you are taking to see if I can replicate
eg
left click on F / {shift} / left click on G to select columns F & G
right click and select Format Cells
...
etc

When does the formula box pop up?

thanks

It happens every time I try to select several cells (columns and rows), right click, select what I want to format (numbers, borders, etc.) and then the formula bar will pop up. If you close the formula bar window, it asks to save the document and then closes the file.

Very odd behaviour. Cannot replicate.
Full re-install of Office2016 is the quickest way to try to sort this.
Can you report back after doing that and confirm that your problem has gone away.
thanks

I reinstalled Office2016 and I still have the formula bar popping up when I go to format cells. I have searched every setting I can think of and can't find anything that would make a formula bar pop out when I do this. Any other ideas?

Any other forum members experienced this - especially any Americans?

@LilSisKin - which version of Windows are you running?
Does this happen in new files created in Excel2016 or only in old files created in previous versions of Excel?

Running Windows 7. It's occurring in old and newly created Excel files.

I just had it happen again. I selected 3 columns of data to delete, right clicked to delete columns and the formula bar popped up.

I too am running Windows7 with Excel2016. My version does not benefit from your "special" feature!

At this point you could try 3 things:
1 Select columns manually ctrl + space bar and then use shift to extend the number of columns
2 Use vba to select columns
3 Swap out your mouse - your mouse could be sick and sending bad instructions

My money is on the mouse

I will give them all a whirl.

This problem is unique to you - there would have been a big outcry otherwise. So it may take a bit of "trial & error" and doggedness to resolve.
I should have said shift and an arrow key to extend the selection (in point 1 /on post#11)