Blogs

2014/10/27

1. KEEP DATA HIDDEN IN PRINTOUTS. You can prevent specific rows and columns from printing by hiding them. 
2. Select the rows or columns you want to hide.

• Right-click the selection and then click Hide.
• When you have finished printing, unhide all rows or columns by manually selecting the rows or columns on either side of the hidden one(s). Then right-click any cell and select Unhide.
  
  

1. IDENTIFY DUPLICATE VALUES.
2. Select the column that holds the duplicate values.

• On the Home tab, in the Styles group, click Conditional Formatting, point to Highlight Cell Rules, and then click Duplicate Values.
• Choose formatting for duplicate values and click OK. 
• Scroll through your spreadsheet to review the highlighted duplicate values.
  Tip: To group duplicates together, sort the column(s).
  
  
  

1. REMOVE DUPLICATE VALUES. When you remove duplicate values, only the values in the selected range of cells or table are affected. Values outside this range of cells or table are not altered or moved. 
               
2. Select the range of cells, or click in a table.

• On the Data tab, in the Data Tools group, click Remove Duplicates.
• In the Remove Duplicates window, do one of the following: 
• Under Columns, select one or more columns. To clear all columns, click Unselect All.
• Click OK. Excel displays a message indicating how many duplicate values were removed, how many unique values remain, or that no duplicate values were found.
• Click OK.
   
  
  

• On the View tab, in the Workbook Views group, click Normal to return to the Normal view.
  
  
  
  

1. CHANGE THE COLUMN WIDTH TO AUTOMATICALLY FIT THE CONTENTS (AUTO FIT). To auto fit all columns on the worksheet at once, click the Select All button and then double-click any boundary line between two column headings. 
   
2. Submitted by: Janice Stoudt