# Excel Tips

## How to Round a Number to Closest ten in Excel

Rounding a number in Excel is very easy. There are situation wherein we need to round a number to closest 10 or 100. For example, if we have a number 115 then 120, if we have 112 then 110. For this there is a dedicated function in Excel called MROUND which comes useful for such [...]

## How to Create Pie of Pie or Pie of Bar Charts in Excel

The Pie charts well known for representing size relationship between the parts and entire thing. For example, if a company has multiple units, if you represent the profit of each unit in Pie Charts, it shows profit per unit in percentage. Sum of all slices/units is the total profit of the company.  Sometimes, we have [...]

## Find matching value in a row and return column name in Excel

When we work in excel sheets, we are required to find matching value in a row and return the Column name. For example, we need to calculate lowest priced store from the price table of multiple stores for multiple products. Another example can be finding the primary reason for exits from the exit feedback form [...]

## How to Use Checkbox in Excel Worksheet

Checkbox in excel is a very handy tool for creating the checklist or simple user forms. There is no need of any Excel VBA knowledge to insert Checkbox into a excel sheet. This is increase the speed at which user enters data as well as it reduces the chances of misspellings which will give trouble [...]

## How to unhide first row or Column in a Excel Worksheet

At times, in Excel worksheet the first row(Row 1) or first column(column A) doesnot show up. It is tricky to unhide  the first row or column as there is no easy way to do it. Based on the situation, you need to apply different method to access the first row or column. So here is the quick [...]

## How to Remove spaces from a cell in Excel

In today excel tip let us discuss on how to remove leading space and trailing space in a cell of Excel worksheet.  By default there are three excel functions which are very useful in removing the space in a cell. The Excel function we are going to use cleanup the cell are CLEAN, TRIM and [...]

1 2 3 7 8