How to Clear Filter in Excel? Shortcut!
Excel filters are quite useful when you’re trying to analyze a large amount of data. Excel allows you to quickly apply filter your data based on one or more than …
Steve Scott
How to Strikethrough in Excel (5 Ways + Shortcuts)
While strikethrough is mostly used in Office applications such as Microsoft Word or Outlook, a lot of users also use it in Excel. One common use case where you may …
Fill Blank Cells with 0 in Excel
Sometimes you will have a data set that has blank cells in it that you need to fill with a 0. I have often found this to be a case …
How to Delete Hidden Rows or Columns in Excel?
Excel allows hiding rows in columns in case you don’t want to delete them, but also don’t want them to be visible in your worksheet. And in case you need …
Fill Blank Cells with Dash (-) in Excel
Blank cells are often a part of the data that you download from databases or from the web. Or it could be a result of the data not being available/entered …
How to Highlight Blank Cells in Excel?
Many times, when you download a data set from the web or from a database, it would have blank cells in it. It is often required to handle these blank …
How to Subtract Percentage in Excel (Decrease Value by Percentage)?
Most Excel users, who work with numbers, also have to deal with percentages in Excel. One of the everyday tasks is to subtract percentage values in Excel. A common example …
How to Show Ruler in Excel? (Excel Ruler Greyed Out)
When working with Excel, you may sometimes have a need to align objects or size the rows and columns to precision. One way to do this is by using the …
How to Insert Sheet Name into Header or Footer in Excel?
Excel allows you to specify the header and footer in a worksheet, which can be quite useful if you need to print your data in the worksheet. A lot of …
Apply Comma Style Number Format in Excel
The comma style is quite commonly used when people work with financial data in Excel. It helps improve the readability of your data as it adds commas between digits (and …
How to Remove Gridlines in Excel (Shortcut + VBA)
By default, light gray colored gridlines are visible in the worksheet area in the Excel file. These gridlines are like a border around each cell that shows you the outline …
Formula Bar in Excel – Show/Hide Formula Bar!
In this Excel tutorial, I will tell you everything you need to know about the Formula bar in Excel. A lot of Excel users use the formula bar, and it …