Forum Discussion

Mary_Addams's avatar
Mary_Addams
Copper Contributor
Feb 20, 2022

Excel - is acting wierd

Whats going on? While I was away from my computer, a new version of excel showedup! NOW everything is strange! - It changed the colors onky spreadsheets, but worst of all things are not working as ...
excel
Formulas and Functions
suyashthomson's avatar
suyashthomson
Copper Contributor
Feb 20, 2022

Hi Mary_Addams ,

 

Causes of Excel Freeze Panes Not Working:

 

The causes of this issue are when your Excel worksheet is in the page layout view, when Windows protection is turned on and when the Excel sheet is protected by the earlier versions of Excel. Because of all these issues, Excel Freeze Panes does Not Work properly.

To fix this issue, you can follow the below link.

 

https://ms-office.us.com/why-freeze-panes-not-work-in-excel-and-how-to-fix-this-issue/

 

Copying of formula correctly:

 

From the Menu section, go to Formula -> Calculation Options -> Change option from Manual to Automatic.

 

In addition, make sure your advanced options (File –> Options –> Advanced) have “Enable fill handle” checked. You might also run into drag-to-fill issues if you are filtering. Try removing all filters and dragging again.

 

I hope the two issues you are facing will solve with the above solutions.

 

Thanks,

SuyashThomson

Resources