Program search:

 

Software Category:

All categories Browser/Internet Business/Productivity Communication Developer Tools Email Entertainment Graphics Multimedia Miscellaneous Networking Security and Privacy Server Tools System Utilities Web Authoring

Platform :   Windows  Macintosh  Linux  Web apps  Other  All 

Shortcut	Command	How useful(?)
Navigation and selection shortcuts OpenOffice Calc
Ctrl+Home	Moves the cursor to the first cell in the sheet (A1).	+       –
Ctrl+End	Moves the cursor to the last cell on the sheet that contains data.	+       –
Home	Moves the cursor to the first cell of the current row.	+       –
End	Moves the cursor to the last cell of the current row in a column containing data.	+       –
Ctrl+Left Arrow	Moves the cursor to the left edge of the current data range. If the column to the left of the cell that contains the cursor is empty	+       –
Ctrl+Right Arrow	Moves the cursor to the right edge of the current data range. If the column to the right of the cell that contains the cursor is empty	+       –
Ctrl+Up Arrow	Moves the cursor to the top edge of the current data range. If the row above the cell that contains the cursor is empty	+       –
Ctrl+Down Arrow	Moves the cursor to the bottom edge of the current data range. If the row below the cell that contains the cursor is empty	+       –
Ctrl+Shft+Arrow	Selects all cells containing data from the current cell to the end of the continuous range of data cells	+       –
Ctrl+ Page Up	Moves one sheet to the left. In the page preview it moves to the previous print page.	+       –
Ctrl+Page Down	Moves one sheet to the right. In the page preview it moves to the next print page.	+       –
Page Up	Moves the viewable rows up one screen.	+       –
Page Down	Moves the viewable rows down one screen.	+       –
Alt+Page Up	Moves the viewable columns one screen to the left.	+       –
Alt+Page Down	Moves the viewable columns one screen to the right.	+       –
Shft+Ctrl+Page Up	Adds the previous sheet to the current selection of sheets. If all the sheets in a spreadsheet are selected	+       –
Shft+Ctrl+Page Down	Adds the next sheet to the current selection of sheets. If all the sheets in a spreadsheet are selected	+       –
Ctrl+*	Selects the data range that contains the cursor. A range is a contiguous cell range that contains data and is bounded by empty row and columns. The * key is the multiplication sign on the numeric key pad.	+       –
Ctrl+/	Selects the matrix formula range that contains the cursor. The / key is the division sign on the numeric key pad.	+       –
Enter - in a selected range	By default	+       –

Function key shortcuts OpenOffice Calc
F1	Displays the OOo help browser. When the help browser is already open F1 jumps to the main help page.	+       –
Shft+F1	Displays context help.	+       –
Ctrl+F1	Displays the note that is attached to the current cell.	+       –
F2	Switches to Edit mode and places the cursor at the end of the contents of the current cell. If the cursor is in an input box in a dialog that has a minimize button	+       –
Ctrl+F2	Opens the Function Wizard.	+       –
Shft+Ctrl+F2	Moves the cursor to the input line where you can enter a formula for the current cell.	+       –
Ctrl+F3	Opens the Define Names dialog.	+       –
F4	Shows or hides the Database Sources menu.	+       –
Shft+F4	Rearranges the relative or absolute references (for example	+       –
F5	Shows or hides the Navigator.	+       –
Shft+F5	Traces dependents.	+       –
Shft+Ctrl+F5	Moves the cursor to the Name box.	+       –
F7	Checks spelling in the current sheet.	+       –
Ctrl+F7	Opens the Thesaurus if the current cell contains text.	+       –
Shft+F7	Traces precedents.	+       –
F8	Turns additional selection mode on or off. In this mode	+       –
Ctrl+F8	Highlights cells containing numeric values (not text).	+       –
F9	Recalculates all of the formulas in the sheet.	+       –
Ctrl+F9	Updates the selected chart.	+       –
F11	Opens the Styles and Formatting window where you can apply a formatting style to the contents of the cell or to the current sheet.	+       –
Shft+F11	Creates a document template.	+       –
Shft+Ctrl+F11	Updates the templates.	+       –
F12	Groups the selected data range.	+       –
Ctrl+F12	Ungroups the selected data range.	+       –
Alt+Down Arrow	Increases the height of current row.	+       –
Alt+Up Arrow	Decreases the height of current row.	+       –
Alt+Right Arrow	Increases the width of the current column.	+       –
Alt+Left Arrow	Decreases the width of the current column.	+       –
Alt+Shft+Arrow Key	Optimizes the column width or row height based on the current cell.	+       –

---