examples Archives | Page 37 of 39

Switch Axes in Excel

Let’s say you have data on the hours you spent on your work in a week. The data is separated into each day,…

When you create a chart, sometimes you will find blank cells in rows. If you insert a line chart there your data won’t…

Normally, when you make a reference to a cell that is empty, Excel will show zero inside this cell. It’s usually helpful, so…

In order to insert a square symbol in Excel, you have to do the following.

Let’s say that you want to create a table in order to add new images. The problem is that the images won’t behave…

In order to import in Excel 365 and earlier versions a CSV file that uses UTF-8 encoding, you have to follow these steps.

When you have a large amount of data in your spreadsheet, you will notice that often the cell is too narrow to make…

I wrote before about inserting rows with VBA. This time, I will show you how you can insert a new row using keyboard shortcuts….

Excel allows you to sort cells in alphabetical order. To achieve this, we will use normal and custom sorting. In the following example,…

When you work with Excel, sometimes you may encounter data in rows, which you want to present in columns and vice versa. Copying…