The Toolbar missing is one of the common issues in Excel. When Toolbar disappears, it becomes very difficult for the users to perform different tasks. Now, we ...

We can detect blank cells and replace them with text using different methods in Excel. Excel VBA is one of the methods. In this section, we will show 3 VBA ...

Sometimes we want to extract the information from the MS Word file into MS Excel. As we know, Excel is based on rows and columns. So, the data of the word file ...

This article will show you how to copy table from Excel to Word with gridlines with proper illustrations. Download Practice Workbook Download this ...

When we print or send any MS Excel file, we convert that file into a PDF and apply the required formatting to that file. When we share any MS Office file with ...

This article is all about determining the sum of numeric values to the end of a column in Excel. We can perform this using different functions and other ...

You can split date and time using both Excel formula or other Excel features. In this tutorial, we will show how you can separate date and time using Excel ...

If you have a date and time in the same cell and need to separate them into two different columns, you are in right place! In this article, I will show you 7 ...

This article will show how to separate decimal numbers from text in Excel. The following image highlights the purpose of this article. Download ...

An Excel file may contain lots of complex and detailed information. To read and view them easily, Excel has the facility to group similar items, expand, and ...

In this article, we will show how to remove unnecessary tab space from your Excel spreadsheet with 5 easy methods. Download Practice Workbook Download ...

Manually Generating random numbers is tiresome work. However, we can produce random numbers using different Excel functions. In this article, we will discuss 2 ...

In any business organization, large or small, you need to know some bookkeeping basics, e.g. how to calculate profit or loss. Profit is the difference between ...

Inserting rows, columns, and cells is very common in Microsoft Excel. But, in various situations, we see that the Insert Column option is greyed out from Excel ...

In Microsoft Excel, we store data randomly. Then we process that data according to our needs and get the desired result. Excel has some built-in features ...