How do you look at two columns in a row and determine differences in Excel

To determine the difference among two rows of information within an Microsoft Excel spreadsheet choose the version you have installed of Excel and follow the directions.

Microsoft Excel to The Office 365

1. You can open the Excel spreadsheet with the information you want to examine.
2. Pick all cells within the two columns with the information to be to be compared.

• How do you pick one or more cell from spreadsheet programs.

1. On the Ribbon located on the Home tab, look for Editing in the section for Editing. Click on the section, then click Find and Select.
2. Within the drop-down menu select Go To Special..

1. Within the Go To Special pop-up window Click row differences and then select “OK”. Excel chooses the difference among the two columns.

1. To emphasize the differences, keep them unchecked, and then select on the paint bucket icon within the font menu, and then select the color you wish to highlight. Additionally, you can right-click and choose your paint bucket, which will highlight cells.

Microsoft Excel 2007 & 2010

1. Start the Excel spreadsheet that contains the data you wish to analyze.
2. Choose all cells in the two columns that contain the data to be to be compared.

• How do you pick one or more cell from the spreadsheet application.

1. On the Ribbon you will find the Home tab, click Find and Choose and then click Go to.
2. Within the Go To pop-up window, choose the row that is different and then Click “OK. Excel will select the differences of the two columns.
3. To draw attention to the differences, keep them unchecked, then select on the paint bucket icon within the font menu, and then select the color you wish to highlight. Additionally, you can right-click and choose an area of the bucket that you want to draw attention to.

Microsoft Excel 2003

1. Start the Excel spreadsheet that contains the information you wish to examine.
2. Pick all cells in each of the columns with the information to be to be compared.

• How do you pick one or more cell within the spreadsheet program.

1. In the menu for files located at near the bottom of the window, select “Edit,” and then select Go To..
2. On the Go to special pop-up, choose the row that is different Then Click “OK”. Excel will select the differences of the columns.
3. To draw attention to the differences, keep them in the list, then select to select the paint bucket icon on the font menu. Select the color you wish to highlight. You can also right-click to select your paint bucket, which will highlight cells.