Extracting data from Text without Using Formulas in Microsoft Excel 2010

In this article, we will learn how to extract characters from text without using formulas. We use the “Text to Column” wizard to extract character...

Displaying the Format Cells Dialog Box in Microsoft Excel 2010

In this article, we will learn how we can display the format cells dialog box in Microsoft Excel 2010. We can find this option by right clicking with ...

Reducing file size in Microsoft Excel

In this article, we will learn how we can reduce the used area in a sheet in Microsoft Excel. The vertical scroll bar gets shorter as the used area of...

Color Unique Record in a Range in Microsoft Excel

In this article, we will learn how to color unique record in a range. We use the Conditional Formatting option along with COUNTIF function in Microsof...

Preventing Moving to the Next Cell after Typing in Microsoft Excel 2010

In this article, we will learn how we can prevent moving to the next cell after typing in Microsoft Excel 2010. Let’s take an example to understa...

Hiding Gridlines on the Screen while Printing in Excel 2010

In this article, we will learn how to hide gridlines on the screen while printing in excel. To hide gridlines on the screen, we need to follow the ...

Adding Data, Charts or Other Information to a Cell Comment in Microsoft Excel 2010

In this article, we will learn how to add data, charts or other information to a cell comment. You can use the Format Comment option in Microsoft Exce...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube