A hot key is a special combination of keyboard keys than when pressed at the same time will invoke a program. The following is the list of available hot keys:
Hot Key |
Action |
Ctrl+N |
Create a new, empty file. |
Ctrl+O |
Open an existing file. |
Ctrl+W |
Close active file. |
Shift+Ctrl+W |
Close all files. |
Ctrl+Q |
Quit the application. |
Ctrl+S |
Save changes to the current file. |
Shift+Ctrl+S |
Save changes to a new file. |
Ctrl+P |
Print the current file or selected values. |
Ctrl+F |
Display the Find and Replace dialog. Enables you to enter the search value. |
F3 |
Find next occurrence of the search value. |
Ctrl+F3 |
Find previous occurrence of the search value. |
Ctrl+C |
Copy the selected values to the Windows Clipboard |
Ctrl+X |
Cut the selected values to the Windows Clipboard. |
Ctrl+V |
Paste the contents in the Windows Clipboard to the selected cell or cells. |
Ctrl+Up Arrow |
Move to the top most cell in the active column. |
Ctrl+Down Arrow |
Move to the bottom most cell in the active column. |
Ctrl+Left Arrow |
Move to the left most cell in the active row. Same as pressing the Home key. |
Ctrl+Right Arrow |
Move to the right most cell in the active row. Same as pressing the End key. |
Home |
Move to the left most cell in the active row. Same as pressing Ctrl+Left Arrow. |
Ctrl+Home |
Move to the top left most cell. |
End |
Move to the right most cell in the active row. Same as pressing Ctrl+Right Arrow. |
Ctrl+End |
Move to the bottom right most cell. |
Ctrl+A |
Select all cells. |
Ctrl+Shift+Up Arrow |
Select all values from the active cell to the top most cell. |
Ctrl+Shift+Down Arrow |
Select all values from the active cell to the bottom most cell. |
Ctrl+Shift+Left Arrow |
Select all values from the active cell to the left most cell. |
Ctrl+Shift+Right Arrow |
Select all values from the active cell to the right most cell. |
Ctrl+Alt+Up Arrow |
Move the active row up 1 level. |
Ctrl+Alt+Down Arrow |
Move the active row down 1 level. |
Ctrl+Alt+Left Arrow |
Move the active column 1 column to the left. |
Ctrl+Alt+Right Arrow |
Move the active column 1 column to the right. |
Ctrl+Enter |
Display cell editor dialog. |
Ctrl+G |
Go to a cell. |
F12 |
Freeze first row and make read-only. |
F8 |
Program options. |
F1 |
Display online help. |
Ctrl+H |
Hide columns. |
Ctrl+U |
Unhide (show) columns. |
Ctrl+I |
Insert column to the left. |
Shift+Ctrl+H |
Hide rows. |
Shift+Ctrl+U |
Unhide (show) rows. |
Shift+Ctrl+I |
Insert row above. |
