permanently

Many questions: 1) Does this option behave differently in different versions of Excel? 2) Does it matter whether it is on Window 7 or Windows 7 or should it behave the same on both 3) Microsoft Help only explains the feature but offers no assistance on how to permanently deselect it by using...

I have a large sheet that contains a lot of duplicate values that need to be looked at then possibly removed. When I use the conditional format tool to highlight duplicates I can manually go through and determine if they should be kept or deleted. The problem is because the sheet is so large...

Does anybody know how to permanently uncheck the "my list has headers" box under sort? I frequently a small number of columns and have an unpleasant surprise when the box clicks itself back on. It's very annoying and I'd rather click it on when I want rather than have to unclick it often. It...

I have a worksheet that has hundreds of columns to the right of the columns I use. It causes problems and I would like to permanently delete those columns and many rows so that when I push Ctrl + End the last cell in the worksheet is not referenced. Is it possible to permanently delete columns...

Greetings all :) hope you survived new year :P I have a 2 part question: Is there a way to permanently display track changes in a separate tab WITHOUT using VBA + is has the latest changes written My current formula present in cell B54 checks the name of the employee and the month and if...