Import the CSV File That Uses UTF-8 Encoding
In order to import in Excel 2016 and earlier versions a CSV file that uses UTF-8 encoding, you have to follow these steps.
Category: examples
Text Wrapping
When you have a large amount of data in your spreadsheet, you will notice that often the cell is too narrow to make…
Insert a Row with a Keyboard Shortcut
I wrote before about inserting rows with VBA. This time, I will show you how you can insert a new row using keyboard shortcuts….
Alphabetize in Excel
Excel allows you to sort cells in alphabetical order. To achieve this, we will use normal and custom sorting. In the following example,…
How to Switch Columns to Rows in Excel
When you work with Excel, sometimes you may encounter data in rows, which you want to present in columns and vice versa. Copying…
Keep Leading Zeros
When you copy data to your workbook you may find that when a number has zeros at the beginning, Excel will strip these…
Privacy Warning Error
When you try to save your macro-enabled worksheet sometimes you may experience the following error. Privacy warning: This document contains macros, ActiveX controls,…
Group Rows and Columns
Grouping and then collapsing data in Excel can improve readability. It is especially handy when you deal with lots of data. Take a…
Degree Symbol
The degree symbol can be used in geometry or in determining geographical coordinates. This special symbol can be inserted. There are a few…
Text to Rows
There is an Excel tool that converts text to columns taking data from a single column and splitting it into multiple columns. But you won’t…
