Powered by

AVS Document Editor
This page is available in EnglishFrançaisDeutschItalianoEspañol
AVS Document Editor
Download
AVS Document Editor
Current Version:  4.2.3.302
Release Date:  12/27/2016
File Size:
125.17 MB

Search and Replace Functions

To search for the needed characters, words or phrases used in the current spreadsheet, click the Search icon icon situated at the left sidebar.

The Find and Replace window will open:

Find and Replace Window
  1. Type in your inquiry into the corresponding data entry field.
  2. Specify search options clicking the Search Options icon icon next to the data entry field and checking the necesary options:
    • Case sensitive - is used to find only the occurrences typed in the same case as your inquiry (e.g. if your inquiry is 'Editor' and this option is selected, such words as 'editor' or 'EDITOR' etc. will not be found).
    • Entire cell contents - is used to find only the cells that do not contain any other characters besides the ones specified in your inquiry (e.g. if your inquiry is '56' and this option is selected, the cells containing such data as '0.56' or '156' etc. will not be found).
    • Within - is used to search within the active Sheet only or the whole Workbook.
    • Search - is used to specify the direction that you want to search: to the right by rows or down by columns.
    • Look in - is used to specify whether you want to search the Value of the cells or their underlying Formulas.
  3. Click one of the arrow buttons on the right. The search will be performed either towards the beginning of the worksheet (if you click the Search Up button button) or towards the end of the worksheet (if you click the Search Down button button) from the current position.

The first occurrence of the required characters in the selected direction will be highlighted. If it is not the word you are looking for, click the selected button again to find the next occurrence of the characters you entered.

To replace one or more occurrences of the found characters click the Replace link below the data entry field. The Find and Replace window will change:

Find and Replace Window
  1. Type in the replacement text into the bottom data entry field.
  2. Click the Replace button to replace the currently selected occurrence or the Replace All button to replace all the found occurrences.

To hide the replace field, click the Hide Replace link.

Download AVS Document Editor Current Version:  4.2.3.302File Size: 125.17 MB

Please note that AVS4YOU programs do not allow you to copy protected material. You may use this software in copying material in which you own the copyright or have obtained permission to copy from the copyright owner.

AVS4YOU is a registered trademark of Online Media Technologies, Ltd., UK. Intel and Core 2 Duo are registered trademarks of Intel Corporation. AMD and Athlon X2 are registered trademarks of Advanced Micro Devices, Inc. Windows 10/8.1/8/7/XP/2003/Vista are registered trademarks of Microsoft Corporation. All other trademarks are the property of their respective owners.