Change Commas to Dots and Vice Versa in Excel
The majority of English-speaking countries, including Australia, the UK, and the USA, use commas to separate groups of thousands and dots to separate…
Author: Tomasz Decker
Spreadsheet and Python enthusiast.
Select Only the Visible Cells in Excel
When we work with an Excel spreadsheet, sometimes some columns are becoming too wide to fit on the screen or maybe there are…
Change the Axis Scale in an Excel Chart
Excel’s charts are impressive, but some of the automated features in Excel may not be ideal for your specific needs. For this reason,…
Change Horizontal Axis Values in Excel
In this tutorial, I’m going to show you how to change data labels on the x-axis in Excel charts. This procedure is a…
Open CSV Files Safely with Excel
The CSV file format is a common data storage format that is used to store tabular data. It is often used for exchanging…
Convert HEX Values in Excel
Every day we deal with numbers with decimal notation, but there can be these rare occasions when we need to use other systems,…
Save Excel Sheet as a CSV file with UTF-8 encoding
In Excel, you can save a spreadsheet as a CSV file directly from the Excel menu. Saving it in Excel 2016, 2019, 2021,…
Calculate the Amount of Time Between Two Dates in Excel
If you want to calculate the time between two dates, you have to remember that’s a bit more complicated than calculating the difference…
Repeat Excel Spreadsheet Column Headings at Top of Page
If you have a long list of data that spans multiple pages, you can print column headers with the first part of the…
Freeze or Fix Column or Row Headings in Excel
When you have to work with a large Excel spreadsheet, you can easily lose track of exactly what kind of information is included…
