Excel - Find & Replace and Formatting

1. Open the ExcelPractice4JohnDoe spreadsheet.
2. On the Home tab, in the Editing group, click on the Find and Select button.

1. Click on the Find option from the pop-up menu.

1. Click in the Find what text box and key in Poole. Click the Find all button. 

1. After the Find all button is clicked, Excel will search for the word Poole in the spreadsheet. Excel will display the results of the search.

1. Click the close button to exit the Find and Replace dialog box.

1. On the Home tab, in the Editing group, click on the Find and Select button.

1. Click on the Replace option from the pop-up menu.

1. Click in the Find what text box, remove the word Poole and key in Smith. Click in the Replace with text box and key in Smyth.  Click the Replace All button. 

1. After the Replace All button is clicked, Excel will replace all occurrences of Smith with Smyth. Excel will display the results of the Replace All.  Click on the OK button to close the results dialog box.

1. Click on the close button to exit the Find and Replace dialog box.

1. Click on Cell A1.
2. On the View tab, in the Window group, click on the Freeze Panes button.

1. Click on the Freeze Top Row option. This will freeze Row 1.  Row 1 will always be viewable.  Use the scroll bar or the down arrow key to move down in the spreadsheet to see that Row 1 stays visible.

1. On the View tab, in the Window group, click on the Freeze Panes button, select the Unfreeze Panes option.

1. Click on Cell C2. On the View tab, in the Window group, click on the Freeze Panes button, select the Freeze Panes option.  Use the scroll bars or the arrow keys to move around in the spreadsheet to see that Row 1 and Columns A and B stay visible.

1. Click on Cell A1. On the Home tab, in the Editing group, click on the Sort & Filter button, select the Sort A to Z option.  This will put the spreadsheet in alphabetical order by last name.

1. On the Home tab, in the Editing group, click on the Sort & Filter button, select the Filter option.

1. After the filter option is selected, the filter chevrons are made visible. Scroll to left until Day 2 is visible (Cell D2).  Click on the Cell D2 down chevron.  Click on the Select All option (this is will remove of all the checks.  Click on the 94 option.  Click on the OK Button.  The applied filter will show the people that had a 94 on day two.  

1. On the Insert tab, in the tables group, click on the Table button.

1. On the Create Table dialog box click OK.

1. Click on the file tab, click the Save As option, select a location to save you file, change the filename to ExcelPractice4FirstNameLastName (replace your FirstNameLastName with your name).