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 a sheet grows larger thereby making it inconvenient to use. … Continue reading →

In this article we will learn how we can convert uppercase into lowercase text in Microsoft Excel 2010. If you want to change the text from uppercase or improper case to lowercase, you don’t need to lot of retyping in … Continue reading →

In this article we will learn how to apply conditional formatting in cell. To apply Conditional formatting based on text, we use the Conditional Formatting option in Microsoft Excel. Conditional Formatting: – It is used to highlight the important points … Continue reading →

The Data Validation is used for making the data error free. It is a technique in Microsoft Excel by which we can control the input by providing the drop down list to users. What is the use of Input Message? Input … Continue reading →

You can find specific text, numbers, and formulas in current worksheet and all worksheet of a workbook by using the key “CTRL + F”. You can replace text, formulas, and numbers by using the key “CTRL + H” in Microsoft … Continue reading →

To select specific cells that only contain text, we can use the Go-To option or Conditional Formatting in Excel. Let’s take an example and understand how and where we can use these functions. We have data in range A1:C10 which … Continue reading →

In this article we will learn counting how many times specific character appears in excel 2010. To return the count of specific character in a cell we need to use a combination ofthe “LEN”, “TRIM”, and “SUBSTITUTE” functions.. LEN:Returns the number … Continue reading →

To extract the last word from the text in a cell we will use the “RIGHT” function with “SEARCH” & “LEN” function in Microsoft Excel 2010. RIGHT:Return the last character(s) in a text string based on the number of characters … Continue reading →

To extract the first, middle and last name we use the formulas “LEFT”, “RIGHT”, “MID”, “LEN”, and “SEARCH” in Excel. LEFT: Returns the first character(s) in a text string based on the number of characters specified. Syntax of “LEFT” function: … Continue reading →

Problem: Rounding the prices in column A to the nearest nickel (5 cents), dime (10 cents), quarter (25 cents), and dollar. Solution: Use the ROUND function in the following formulas: Nearest Nickel Formula =ROUND(A2*20,0)/20 Nearest Dime Formula =ROUND(A2*10,0)/10 Nearest Quarter … Continue reading →