416-621-9348 cgreaves@chrisgreaves.com
Home Services Products

Find/Replace - Ctrl+H

Displays the Find and Replace dialog box.

Open the RevenueExpenses.xls workbook.

In the "CASH" worksheet use Ctrl-H to open the Edit-replace dialog box.

For our simple example, opt to replace each occurrence of "2" by "3", but note:

Edit-Replace will replace "2" in data strings as well as in formula strings, so a formula such as "=B42" will become "=B43", and could create serious errors in your calculations!

Loading

Toronto and Mississauga, Sunday, December 05, 2010 3:10 PM

Copyright © 1996-2010 Chris Greaves. All Rights Reserved.