Select the list; go under Data tab and Data tools section. Choose “Remove duplicates”. Now you can choose which columns are searched for duplicates. Press “OK”. A message will let you know how many duplicates were found.
Continue readingCategory Archives: Excel 2007
How to change the starting point of text inside a cell? | Excel 2007
First select a cell or cells you wish to edit. For changing the starting point of the text inside a cell, go under Home tab into Alignment section. Notice that there are two buttons which include blue arrows pointing left and right in the section. They are called “Decrease Indent” and “Increase Indent”. Decreasing takes text to the left and increasing to the right.
Continue readingHow to see above average numbers within the list? | Excel 2007
First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Top/Bottom Rules” and “Above Average …” From the appearing menu select the style you wish to apply. Notice that some only apply to text or background whilst others format both of those. If you are satisfied, click on “OK”.
Continue readingHow to quickly apply the percentage style? | Excel 2007
Select the cell or cells and go under Home tab into Number section. To apply a percentage style onto a cell, click on the button with a percentage sign on it.
Continue readingHow to have cells automatically formatted if they fall into specific date? | Excel 2007
Select the cells you want to be analyzed and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Highlight Cell Rules” and “A Date Occurring …” From the new menu choose the date from which the cells are formatted and from the right sided drop-down menu select the style you wish to apply. Notice that some only apply to text or background whilst others format both of those. If you are satisfied, click on “OK”.
Continue readingHow to change the placement of the text inside a cell? | Excel 2007
First select a cell or cells you wish to edit. For changing the placement of the text inside a cell, go under the Home tab into Alignment section. Notice that there are six buttons in two rows just left in the section. The top row aligns text from top to bottom in the cell and the bottom row from left to right.
Continue readingHow to have only part of the text inside a cell edited in a different way? | Excel 2007
First make sure the format of the cell is determined as “Text”. In Number section under the Home tab you can specify the format your data is presented in. Make sure the correct cells are selected and choose “Text” from the menu. Next double click on the cell. Now you will be able to select part of the text and apply needed editing styles.
Continue reading