Delete all borders - (Shift + Underline).Ĭall up the menu: format cells - (1), select a font - (Shift + F), select the font size - (Shift + P). Apply the outlines of borders - (Shift + 7). Menu: change the font - (Shift + F), the font size - (Shift + P).
#EXCEL SHORTCUT KEYS 2003 PLUS#
In these combinations, use the Ctrl key plus other keys specified in this subsection in parentheses.įont: Bold - (B), underlined - (U), italic - (3), strikethrough - (5). To format text in the selected cell (cell area), use the Excel shortcut keys shown below. To move between the sheets of an open book - (Ctrl + F6). Go to the cell on the right - (Tab) To the cell on the left - (Shift + Tab) Up one screen - (PageUp) Down one screen - (PageDown) On the next sheet - (Ctrl + PageDown) On the previous sheet - (Ctrl + PageUp) In the data area: to the starting cell - (Ctrl + Home) To the enclosing cell - (Ctrl + End) In the direction of the arrow to the first cell - (Ctrl + Arrow). The following Excel shortcuts are provided for performing navigation. Collapse the text in the cell - (Alt + Enter). Call the table creation dialog - (Ctrl + L). Add a column - (Ctrl + Shift + key plus). Last action: undo - (Ctrl + Z), repeat - (Ctrl + Y). To go to the menu or open the file - (Ctrl + O), save the file - (Ctrl + S), "Save As" - (F12), print - (Ctrl + P). They need to be pressed first and, while holding down, push another (third or fourth) of the hotkey combination. Usually one, two or three of them are service keys - Ctrl, Shift or Alt. Combinations of keys are indicated in parentheses, at the same time one, two, three or even four keys on the keyboard can be pressed. In the description of hot keys, the symbol "+" is used to show the simultaneous pressing of the keys that are on the right and left of the "+" sign. Some of these combinations may not work for localized versions of the application in question.īy pressing these key combinations, the main functions of the program are executed. And in Excel 2003 there are no combinations for working with the ribbon - the Quick Access Toolbar, because this feature appeared only in Excel 2007 and is available in later versions. Consider the popular keyboard shortcuts that are applicable in many versions of this application (from Excel 2003 to Excel 2013). This is even more important for an office program such as Microsoft Excel, which is designed to make it easier for a person to work with arrays of data of various kinds. Hot keys help users to simplify the work and speed it up, replacing several actions with one.