Microsoft Office Tutorials and References
In Depth Information
Replace Data In addition to simply finding data, you can also find and
replace it. To do so, click the Replace tab in the Find and Replace dia-
You can freeze columns, rows, or both so that column letters and row numbers remain in
view as you scroll instead of scrolling off the screen with the rest of the worksheet. This
is particularly helpful with larger worksheets.
Click the View tab.
Click the Freeze Panes button.
Select Freeze Panes from the menu to free both columns and rows.