How to round date values in Excel

How to round date values in Excel

Excel has extensive array of rounding functions as expected from a spreadsheet software. However, rounding date values is not as straightforward as rounding numeric values. In this guide, we’re going to show you how to round date values in Excel. Download Workbook...
How to round time values in Excel

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. Download Workbook Date and time...
How to save each sheet as CSV in Excel

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. Download Workbook Excel to CSV Saving an Excel worksheet as a CSV file is an easy task. All you need to do is to use Save As section in File menu and select the CSV as the file type. This...
How to format axis labels individually in Excel

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. Download Workbook As you have already known that there is no way to select an individual item in a chart axis. This is because Excel populates axis points on the fly based on data...
How to replace blank cells in an Excel Table

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 generate unique random numbers in Excel

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

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...