beautypg.com

Tools menu options, Go to, Find – Juniper Systems Allegro CX Manual User Manual

Page 143: Replace, Sort, Filter, Protection > protect/unprotect sheet/workbook

background image

Allegro CX Owner’s Manual 143

Tools Menu Options

The following functions are available from the Tools menu option.

Go to

The Go to option selects specifi ed cell or range.

Find

The Find option fi nds a cell in the current sheet containing the
specifi ed text. You can search by rows or columns, look in values or
formulas, search case sensitive/insensitive, and search entire cells.

Replace

The Replace option fi nds a cell as outlined above and replaces the text
as specifi ed.

Sort

The Sort option sorts a selected range of cells: ascending or
descending, case sensitive/insensitive, sorts rows or columns,
exclude header row from sort.

Filter

The Filter option toggles the auto fi lter on and off.

Protection > Protect/Unprotect Sheet/Workbook

The Protection option allows you to turn the Protect Sheet and Protect
Workbook
feature on and off.

Go to Format | Cells | Protection to lock/unlock and hide/unhide
cells. Use Protect Sheet or Protect Workbook to activate these
settings.