permanently

  1. Geeta2014

    MS Excel>Options>Advanced>When calculating This Workbook: Permanently Deselect Update Links to OtherDocuments

    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...
  2. O

    highlight duplicates permanently

    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...
  3. M

    How to permanently turn off "my list has header" box when sorting?

    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...
  4. E

    Too Many Columns

    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...
  5. M

    permanently sheet track changes + monthly extract

    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...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
  • IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top