Microsoft Excel sheet is the most used sheet in the world. Almost in every office it is used to prepare data. Sometimes, excel has private or sensitive data. To secure
Change Case in Excel You have come across with this situation many times in routine life, that you have large list of names with all Uppercase or Lowercase. It is
HOW TO HIGHLIGHT DUPLICATES IN EXCEL Very often, while we are working in excel, we get duplicate data. To identify the duplicate data there is a tool in excel
How to use “Text to Columns” in excel Many times we get data in one cell like full name with address and we need to separate it in different
How to Add (Sum) data in Excel In Microsoft office, Excel plays a vital role. It has vast range of formula, in excel we can add (sum) the data
How to import text file in excel. In our day to day life it happens many times that we receive data in text (txt.) format to edit or modify, but
How to keep excel cell data visible in one cell (How to wrap text) In excel, wrap text is used to keep excel cell visible in one cell, in
How to change text orientation in Excel. In this lesson I will tell you how to use text orientation in excel. Text orientation is used in many ways to
How to make all data in 1 format in excel (Format Painter) Sometimes we make a sheet collecting data from different sheets. Sheets may have data in different formats,
Usually we copy the cell data by pressing “Ctrl+C” and paste pressing (Ctrl+V). When formula are used in cells, formula are pasted, but we need only cell data instead of
How to Merge 2 or more Cell into 1. While working in excel we need to merge 2 or more cells into 1. Mainly when are to make a
How to Insert Column/Row in Excel Sometimes we need to add text in written data and want to Insert Row or Column. To Insert Column/ Row there are several
Sometimes we have to combine the data of cell in large number which is not possible to do manually. In this Situation this formula can be very helpful. First of
