Latest Posts From Mukesh Dipto
Method 1 - Use Go To Special Dialogue Box to Find Blank Cells in Excel In the below screenshot, we have the attendance of 6 students for 3 days. We can see ...
Mukesh Dipto
In this article, we will demonstrate two methods to apply the Advanced Filter to copy data to another sheet in Excel. In the first method, we will use the ...
Solution 1 - Unprotect Workbook Structure While Delete Sheet in Excel is Not Working Overview If you’re unable to delete a sheet in Microsoft Excel, the ...
In this tutorial, we will learn how to create a formula in Excel to change the date by 1 year. While you are working with date type information you might need ...
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 ...
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 ...
While working in Microsoft Excel we might need to concatenate different multiple results from a particular dataset. In this article, we will demonstrate 2 easy ...
In this tutorial, we will learn how to convert Hours and Minutes to decimal in Excel. While working with time-related data we don’t need to keep the input in ...
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 ...
In this tutorial, we will cover how to print landscape in Excel. When we print something from an Excel worksheet by default, Microsoft Excel prints that ...
- « Previous Page
- 1
- …
- 3
- 4
- 5
- 6
- 7
- Next Page »
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.