How to Show Zeros as Blank Cells In Excel
January 12, 2021
Background Zeros are almost inevitable in a workbook. Sometimes you may change the appearance of the zero. Do you have the following ask? Display zero as blank cells Show zero as dash Hide zero without actually deleting zero In this
How to Create Drop Down List with Color (Excel)
January 12, 2021
I have a drop-down list and I want the cell to be formatted to a specific color depending on the selected value. Numerous Excel users From time to time, I get this questions from my followers on Instagram. They want
How to Merge Cells Across Multiple Rows/Columns
January 4, 2021
In this article, I will show you how to merge cells across multiple rows and columns simultaneously.
How To Change The Default Number Of Sheets In Excel
January 2, 2021
In this article, I will show you how to change the default number of sheets in Excel. I will also introduce you a great tool to create as many sheets as you want.
How to Hide Excel Sheet so it can’t be Found easily
December 24, 2020
In this article, I will show you 3 ways to make Excel sheets very hidden. They are Manually Hiding Sheets, Tweaking Page Properties and Disabling “Show sheet tabs”, respectively.
How to Enable Developer tab in Excel?
December 23, 2020
In this article, I will show you one of the VBA 101 skills – enabling Developer tab. With Develop tab, you get access to a bunch of new commands that allows you to work with VBA.
Categories
.
- Array Formula (3)
- Data validation (3)
- Excel Formula & Functions (34)
- Excel Skills (37)
- Excel Tips and Tricks (38)
- Finance (5)
- Formatting (8)
- Option Pricing (3)
- Pivot table (3)
- Sharing (8)
- Shortcuts (13)
- Solver (1)
- Technical (6)
- VBA (18)
