Resources
How to round time values in Excel
Excel has numerous rounding functions as expected from a spreadsheet software. However, rounding time values may not be as straightforward as rounding numbers. In this guide, we’re going to show you how to round time values in Excel. [button...
How to save each sheet as CSV in Excel
In this guide, we’re going to show you how to save each sheet as CSV in Excel. Excel to CSV Saving...
How to format axis labels individually in Excel
In this guide, we’re going to show you how to format axis labels individually in Excel. As...
How to replace blank cells in an Excel Table
Using blanks instead of repeating values is a common approach to express the hierarchy between columns. You may recognize the structure from Pivot Tables from older Excel versions. Although you can use the formulas to populate these empty cells, it may become...
How to trigger a macro by hovering over a cell in Excel
Apparently, Excel doesn't have a hover (mouse over) event support for cells. However, we can use the HYPERLINK function to mimic this functionality, thanks to mouse-over support for hyperlinks in Excel. In this guide, we’re going to show you how to trigger a macro by...
How to highlight selected row and column in Excel
It is common to lose your way in a big table of data. Even though Excel's freezing features help you to display selected row and column's primary data, no feature can beat highlighting to express the selected data. In this guide, we’re going to show you how to...
How to generate unique random numbers in Excel
Although Excel doesn't lack functions to generate random numbers, there is no built-in option to generate unique numbers. On the other hand, we can assume that it would be very uncommon to get same number from Excel's random number functions. Anyways, we can eliminate...
How to hide formula errors in Excel
Errors may be inevitable in worksheets containing complex formulas. Thankfully, you do not need to investigate and correct each of them. It is OK to hide errors you expect and not to correct them to improve the look and feel of your worksheet. In this guide, we’re...
How to set different colors to positive and negative numbers in area charts in Excel
In this guide, we’re going to show you how to set different colors to positive and negative numbers in area charts in Excel. [button...