Keybinding Reference

This appendix lists the keyboard shortcuts which are defined by default in Gnumeric.

Keybindings are combinations of keystrokes which tell an application to run a task. These can greatly speed-up the user's interactions with an application. Some of the most common ones are Ctrl+s to save a file or Ctrl+q to quit the application. Gnumeric also comes with keybindings to make your spreadsheet experience faster.

Normally, keybindings are next to a command in a menu. For example, if Save has Ctrl+s next to it, that means that Ctrl+s can be typed at the same time to save your file. However, some keystrokes aren't listed in the menus. They are as follows:

  • F2 sets the current cell for editing. The cursor is inserted at the end of the current text.

  • Ctrl-O opens the Load file dialog window.

  • Ctrl-F3 opens the Define Name dialog window.

  • F4 repeat the last action.

  • Ctrl-G opens the Go to dialog window which allows you to jump to a specified cell.

  • Ctrl-H opens the Search and Replace dialog where you can search through your spreadsheets for text strings and replace them with something else.

  • Ctrl-F opens the Search Center. The Search Center allows you to search through your spreadsheets for text strings.

  • Ctrl-~ Formats the current selection as a 'General'.

  • Ctrl-$ Formats the current selection as the default currency

  • Ctrl-# Formats the current selection with default date style

  • Ctrl-^ Formats the current selection as superscript

  • Ctrl-@ Formats the current selection with the default time format

  • Ctrl-! Formats the current selection as an integer (a number with no decimal places).

  • Ctrl-& Adds a thin border around the current selection

  • Ctrl-_ Formats the current selection as subscript

  • Ctrl-B or Ctrl-2 Toggles the boldness of the font in the current selection.

  • Ctrl-I or Ctrl-3 Toggles the italics of the font in the current selection.

  • Ctrl-U or Ctrl-4 Toggles single underlining of the current selection.

  • Ctrl-5 Toggles strikethrough of the current selection.

  • Shift-Ctrl-G Changes the keyboard focus to the current cell indicator described in Current Cell Indicator.

  • Ctrl-a Select all cells on the currently focused sheet.