How to find duplicates in excel- 3 ways to check for duplicates

As a part of data analysis , in excel we can find and remove duplicate values. there are different ways to remove duplicates in excel. In this article let us understand how to find duplicates in excel. 3 Different ways to check duplicates: There are three different ways to find duplicates in excel. Conditional formating to find duplicates  Using Remove duplicate function in Data tab  Countif function to find duplicates in a column. Let us understand these there ways. Conditional…

Continue Reading

How to lock cell and protect sheet in excel

Excel provides the facility to protect sheet from updating from users. We can define the cells to be protected and cells to be allowed to be used in the sheet in a same sheet. The cells not protected will be allowed for user for updating the data and the protected cell can’t be altered by the users. The protection can be With password or Without password If the sheet is protected without password, this can be unprotected easily. But if…

Continue Reading

Hide formulas in excel and protect worksheet from update

The Formula bar shows the formula entered in a cell when the cell is selected. Some time you may want to hide this formula from viewing. You can hide formulas in excel sheet without hiding the results of the formula. By doing this the results will appear without any impact in the cell. But the formula will not be visible in the formula bar. In order to do this you can follow the below steps: Steps to hide formulas in excel:…

Continue Reading

Excel text box link to cell to auto update text box or shapes

How to add textbox or shapes? Before learning how excel text box link to cell, if you dont know how to add textbox or shapes in excel, you can refer below steps: To insert textbox, click on Insert on ribbon tab and click on text box. In case if you want to insert shapes to excel sheet, you can go to insert in ribbon tab and click on shapes and select the shape which you want to add. The text box…

Continue Reading

How to insert image into excel comment box

How to add comment to excel cell  & insert image into excel comment box ? Excel provides options to put comments to the cell for easy reference. By default this comment will be popped up when you move mouse cursor near to the comment cell. You can enter separate comment to each cell. You can easily add the comment by right click and insert comment to a particular cell. This will open a comment box and you can enter the text…

Continue Reading

How to customise quick access toolbar…?

If you use some of the excel commands very frequently and if you find it difficult to call from the ribbon, you can add this command to quick access toolbar with the help of customise quick access toolbar. Default quick access toolbar will contains 3 tools save, undo and redo. You can customise the quick access toolbar by adding other commands that you use often. There are different ways to add commands to quick access toolbar. Customise quick access toolbar with dropdown…

Continue Reading

View or Print all formulas in a Sheet

If you want to View or Print all formulas in excel cell, you can select that cell and view the formula in formula bar. You can also view the formula of selected cell by pressing the F2 Key. But if you want to see the formulas in a sheet, you can go to Formulas Tab and click on Show Formulas. It will show all the formulas in that sheet instead of formula results. You can also use the keyboard shortcut…

Continue Reading

Insert table from excel to Gmail or Blogger

If you have information in excel in the form of table and you want to copy and paste it to gmail, or in the blogger compose box, the formatting will not be pasted in gmail compose window. It will paste the data without border and colours.To paste the table with formatting in Gmail, follow these steps:1. Copy the table in Excel workbook you want to paste in Gmail.2. Open a new word document and paste the table you have copied…

Continue Reading

Change the comma separator from lakhs to million

Change the comma separator from lakhs to million: Numbers entered in excel shows the comma separator when the format of the cells are accounting format. Comma separator may be for lakhs or for million based on the region selected in the windows operating system. Sometimes you may want to show the numbers in millions but excel will show in lakhs. If your excel is showing comma for lakhs, this can be changed to million by changing the region in the…

Continue Reading

10 Shortcut Keys in excel to speedup your work.

The shortcut keys will speed up the work by avoiding mouse clicks. Remembering these shortcut keys may be difficult, but by regular practice we can develop the habit of using short cut keys.Following are the 10 shortcut keys to speedup your work. 1 Ctrl+Space and Shift+Space  these are the short cut keys used for selection of cell. Ctrl+Space will select the entire column of selected cells. Shift+Space is used to select the rows of selected cells. 2 Ctrl+Shift+-  Ctrl+Shift+- is…

Continue Reading
Close Menu