The selection pulldown menu houses all commands to fastly reach some cells or to automaticly select some spreadsheet elements

Screen shot: Selection pulldown menu

Le Selection menu contains the following options:

• "Paste Function..." inserts a function name in the edit bar. It opens the 'Paste Function dialog box'.
   
• "Reach Cell..." changes the active cell by its coordinates and move the displayed area of the spreadsheet to make the active cell visible. It opens the 'Reach Cell' dialog box.
   
• "Reach Active Cell" moves the displayed area of the spreadsheet to have the active cell visible. When you use the slider to scroll through the spreadsheet, the active cell remains the same.
   
• "Reach Last Cell" changes the active cell to the last cell and move the displayed area of the spreadsheet to make the active cell visible. The last cell is the lowest and rightmost cell containing data in the whole spreadsheet
   
• "Select used area" selects the smallest area of cell containing data (text, value or formula).
   
• "Select all cells" selects the whole spreadsheet and the cell at position A1 becomes the active cell. Same effect can be obtained by clicking on the spreadsheet'sheader origin (intersection of the horizontal header bar and the vertical header).
   
• "Select all frames" Selects all the frames contained in the spreadsheet. If a frame unfortunatly slipped out of the spreadsheet, this is the only way to get it back