Data Types in Excel

Data Types in Excel

In Excel, there are five basic data types. These are Number, Date and Time, Text, Logical (boolean), and Error. As an Excel user, knowing the different data types is important …

Read more

How to Get Sheet Names in Excel?

How to Get Sheet Names in Excel

You may want to get the worksheet’s name while working with Excel. For example, when creating a report that includes multiple worksheets, you may have the sheet name as a …

Read more

How to Add Leading Zeros in Excel?

How to Add Leading Zeros in Excel

We usually need to enter zeros before phone numbers, zip codes, product codes, and account numbers.  Even if we enter leading zeros when we type in Excel, all leading zeros …

Read more

How to Remove Add-Ins from Excel?

How to Remove Add-Ins from Excel

Microsoft Excel already has some amazing features and functionalities that come in-built with it.  To add to it, you can also add some add-ins that can further enhance the functionality …

Read more

Excel Fill Series Not Working

Excel Fill Series Not Working

The Excel Fill Series feature allows you to automatically fill in data in the cells, based on the value or patterns in other cells. This is a useful feature that …

Read more

How to Swap Columns in Excel?

How to Swap Columns in Excel

As we use Excel, we may need to swap columns or exchange the position of two or more columns. For example, you may want to bring together two columns to …

Read more