Category: Excel Features

Lesson#130: Paste special with skip blanks

Here I am having an example to show you the Paste Special with skip blanks. Serials are incomplete in both columns. In column A even numbers are absent and in column B odd numbers are absent. If you have to

Tagged with:

Lesson#129: An overview on Formula Auditing

Hello friend! I am going to share some information about Formula Auditing in Microsoft Excel. In the Formula ribbon you can get a group of features named Formula Auditing. It includes Trace Precedents Trace Dependents Remove Arrows Show Formulas Error

Tagged with:

Lesson#122: Cell formatting in a protected sheet

Excel doesn’t accept to format cells which are protected, if they aren’t allowed for users. To format unprotected or protected cells users must allow before protecting a sheet. When you are protecting a sheet just see these options. The third

Tagged with:

Lesson#121: How to make some cells unprotected when protecting a sheet

OK, I am having a sheet here which calculate the age when birth date is provided. I need to protect the sheet before giving it to users. So none of them change the structure or formula. But I also need

Tagged with: ,

Lesson#118: Format only cells that contain

Have you seen this Conditional Formatting option – Format only cells that contain? If not then you must remember that this option make many works of yours easier with Conditional Formatting. Then you need to go to Conditional Formatting>New Rule Then

Tagged with:

Lesson#116: How to name a range in excel

This post will teach you the basic concept of Name Manager. Here I will show how to name a range in excel. You can also create name for range, reference or formula to work in the spreadsheet easily. Above picture

Tagged with: ,

Lesson#115: Information functions with Conditional Formatting

Here I will share a general tips about Conditional Formatting and some Information functions. These functions are ISBLANK, ISERR, ISERROR, ISEVEN, ISFORMULA, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, ISTEXT. You can use these functions to highlight specified type of values among an array. ISBLANK function highlights blank cells among an array of values.

Tagged with:

Lesson#113: How to highlight cells with errors in it

I will show you how to highlight cells with errors among an array of values. Here I am having an array of values and among them I have some cells which contains errors. If you need to highlight those cells

Tagged with: ,

Lesson#109: Tricks to make a dancing chart in excel

 Here I will show you funny trick to make a dancing chart in excel. For that you have to follow some steps. 1. Make a range of data names like A, B, C, D….. 2. Then put values against these

Tagged with: ,

Lesson#108: How to divert user to another cell in workbook when clicked

 Hi friend. Here I will show a method to divert a user to anywhere in workbook when a link is clicked. For this some steps are required. Right click on the cell where the link has to be created. Then

Tagged with:
Top