Juniper Systems Allegro CX Manual - Manual (Page 132)

132 Allegro CX Owner’s Manual
Cut, Copy, Paste, Paste Special, Clear (All, Content, Formats), Fill
(Right, Down, Series) cells, Insert/Delete Rows/Columns
Set row height and column width, hide/unhide rows and
columns, autofi t row heights and column widths.
Insert function, Quick sum, Pointing
Format: Number format (General, Financial, Percentages,
date/time, user defi ned), Alignment (General, Left, Center,
Right, Center across selection, Top, Center, Bottom, Wrap Text,
Merge Cells), Font, Size, Color, Background Color, Bold, Italic,
Underline, Borders (Left, Right, Top, Bottom, Outline), Protection
(Locked, Hidden) Zoom (25% - 200%) and full screen mode
Freeze Titles (row and column freezing)
Formula bar or in place editing
Show/hide: Column and row titles, Gridlines, Zero values
Sheets: New, Rename, Delete
Sort (Ascending, Descending, up to 3 keys), Go to cell, Find/
Replace
Simple charts (Bar, Line, Pie, XY)
Names (defi ne and insert)
Protection (Protect/Unprotect Sheet, Protect/Unprotect
Workbook)
Custom lists (e.g. Monday, Thursday, Wednesday...)
Auto fi lter
Automating Tasks - user defi ned tasks (simple macros)
Insert sound or hyperlink (cell reference, Web page or E-mail
address) in a cell
Password protection
Group and outline
Data validation
Goal seek
Data validation, dropdown boxes
Group and outline
External references (example: [BOOK.XLS]Sheet1!A5)
Merge cells
Goal seek
‰
‰
‰
‰
‰
‰
‰
‰
‰
‰
‰
‰
‰
‰
‰
‰
‰
‰
‰
‰
‰
‰
‰
‰
‰