Latest Posts From Mukesh Dipto
Method 1 - Use the Excel NETWORKDAYS Function to Calculate Working Days Between Two Dates Case 1.1 - Calculate Working Days Between Two Dates Excluding Only ...
Mukesh Dipto
Method 1 - Automatically Copy Rows in Excel to Another Sheet Using Filters In the following dataset, we will copy all rows from the data range (B4:D10) except ...
Sometimes we need to share our Excel worksheet with users or clients. Suppose we want them to only be able to view the worksheet but not copy and paste any ...
Case 1 - Subtract Less Than 24 Hours from Time in Excel Method 1.1 - Apply Fundamental Method to Subtract Hours From the dataset, we can see we have ...
Method 1 - Fundamental Percentage Formula in Excel for a Marksheet If we want to determine what percentage of A is B we will use the following ...
Method 1 - Calculate Daily Interest in Excel to Find Simple Interest Suppose you have invested $1,000,000 at an annual interest rate of 5%. Let’s see how much ...
Method 1 - Input Argument Manually to Exclude a Cell in Excel AVERAGE Formula In the sample dataset, we have Sales Amounts for different persons on different ...
We are going to use the same sample dataset for both methods, which represents Student Names, Marks, and Subjects. Method 1 - Move Rows Up without Overwriting ...
Method 1 - Activate Automatic Hyperlinks Option to Convert Text to Hyperlink in Excel In the following dataset, we can see the URLs of 5 companies. ...
Method 1 - Use the Mouse Click to Copy a Hyperlink in Excel In the following dataset, we will copy the hyperlink of the company “Exceldemy”. We will ...
Method 1 - Remove a Single Cell’s Hyperlink from Excel We will remove the hyperlink only for “Exceldemy”. STEPS: Select cell C5. ...
Method 1 - Use the Conventional Undo Command to Remove Sort in Excel To demonstrate this method, we will use the following dataset. We have filter ...
Method 1 - Use the Filter Shortcut Option Under the Data Tab to Filter Data Suppose you have the following dataset. Steps: Select any cell from ...
Method 1 - Use VBA Replace to Find a Word and Replace We have the following dataset of six students and their status of present or absent in the class. We'll ...
The following dataset showcases sales amounts in January. Method 1 - Setting 7 Days As a Week to Group a Pivot Table by Week This is the pivot ...
See Our Reviews at
Hello Ruby,
Thanks for your query. If you do not want to see the formula for a blink then you have to do it by protecting the worksheet. You can try the following code:
Sub HideFormulasDisplayValues()
With ActiveSheet
.Unprotect
.Cells.Locked = False
.Cells.SpecialCells(xlCellTypeFormulas).Locked = True
.Cells.SpecialCells(xlCellTypeFormulas).FormulaHidden = True
.Protect AllowDeletingRows:=True
End With
End Sub
Thanks for your feedback sir.
The range is (>=50 and <=80). In Excel COUNTIF function by default omit the upper end value.
So, the formula is basically showing the result for the values less than 80.