How to cut in excel with keyboard. Microsoft Excel: keyboard shortcuts

There are several different tools for deleting a row in Excel. The deletion itself in Excel can be different. You can delete only the contents of the row cells by selecting the row and pressing the Delete key, while the cells remain in their places and continue to store information about the format (fonts, fills, and so on), or you can delete the row as such when all cells of the selected row are deleted. and their place is taken by the cells located in the row below.

Deleting a Line Using the Context Menu

The easiest way to delete a row in Excel is by using the right-click context menu. To delete a line, you must first select it, then call the context menu and select the "Delete" item from it. The row is deleted with a shift up, that is, the cells of the selected row disappear, and the entire table field located under the deleted row is shifted up. Similarly, you can delete several selected lines; for this, while selecting lines, you must hold down the Ctrl key. After the lines are selected, the context menu is called and the "Delete" item is selected.

Delete a line from the keyboard with hotkeys

A faster way to delete a line or multiple lines is to use the keyboard shortcut key combination. To delete a line from the keyboard using hot keys, you just need to press Ctrl + "-", that is, two keys, one of which is Ctrl, and the second is "-". It should be noted that a line (or several lines) must be preselected. The command deletes the selection with an upward shift. Its use allows you to save a little time and get rid of unnecessary movement that invokes the context menu.You can further speed up the process of deleting a line using hotkeys, but for this you have to do two things. First, save the macro in your personal macro book, and second, assign the execution of this macro to a specific keyboard shortcut.

1. Save the macro

The macro code for deleting the line containing the selection marker. Using the code below, you can delete a line without using a mouse manipulator. The command determines the line number in which the selection marker (active cell) is located and deletes this line with an upward shift. In this case, you do not need to select the line before deleting.

Sub Udalenie_Stroki_S_Aktivnoy_Yachejkoj () "macro deletes the row containing the active cell Rows (ActiveCell.Row). Delete Shift: \u003d xlUp End Sub

In order to transfer this program code to your computer, move the mouse cursor over the field with the program code, click on one of the two buttons in the upper right corner of this field, copy the program code and paste it into the project module on your computer (more about how to save the program code of a macro ).

2. Assign a keyboard shortcut to the macro

About, how to set a keyboard shortcut to a macro written separately. It should be noted that you should be careful with your choice of keys, as some of the shortcuts are already used by Excel. In addition, the application distinguishes between the alphabet of a given letter, so to ignore the keyboard layout when running a macro, you can create a copy of the macro with a different name and assign a keyboard shortcut to it using the same button, but in a different layout.

Macro for conditionally deleting rows

There are more advanced tools for deleting lines, using which you do not need to use your own eyes and attention to find the lines you want to delete. An example is macro that searches and deletes lines containing user-specified text , and excel add-in deleting rows , with many different conditions and the ability to set these conditions in a convenient dialog box.

Hotkeys are a function that, by typing a certain key combination on the keyboard, offers quick access to some features of the operating system, or a separate program. Microsoft Excel also has this tool. Let's find out what keyboard shortcuts are available in Excel and what you can do with them.

First of all, it should be noted that in the list of hot keys presented below, a single "+" sign will serve as a symbol that denotes a keyboard shortcut. If the "++" sign is indicated, this means that on the keyboard you need to press the "+" key together with another key that is indicated. Function keys are named as they are named on the keyboard: F1, F2, F3, etc.

Also, it should be said that the service keys should be pressed first. These include Shift, Ctrl and Alt. And after that, while holding these keys, press the function keys, buttons with letters, numbers, and other symbols.

General settings

The general management tools of Microsoft include the basic features of the program: opening, saving, creating a file, etc. The hotkeys that provide access to these functions are as follows:

• Ctrl + N - create a file;
• Ctrl + S - save the book;
• F12 - select the format and location of the book to save;
• Ctrl + O - open a new book;
• Ctrl + F4 - close the book;
• Ctrl + P - print preview;
• Ctrl + A - select the entire sheet.

Navigation keys

There are also hotkeys to navigate through a sheet or book.

• Ctrl + F6 - move between several books that are open;
• Tab - move to the next cell;
• Shift + Tab - move to the previous cell;
• Page Up - move up to the size of the monitor;
• Page Down - move down to the size of the monitor;
• Ctrl + Page Up - move to the previous sheet;
• Ctrl + Page Down - move to the next sheet;
• Ctrl + End - move to the last cell;
• Ctrl + Home - move to the first cell.

Hotkeys for Computing Activities

Microsoft Excel is used not only for simple construction of tables, but also for computational actions in them, by entering formulas. For quick access to these actions, there are corresponding hot keys.

• Alt + \u003d - activation of autosum;
• Ctrl + ~ - display of calculation results in cells;
• F9 - recalculation of all formulas in the file;
• Shift + F9 - recalculation of formulas on the active sheet;
• Shift + F3 - Call the Function Wizard.

Data editing

Hotkeys for editing data allow you to quickly fill the table with information.

• F2 - edit mode for the marked cell;
• Ctrl ++ - add columns or rows;
• Ctrl + - - deletes selected columns or rows in a Microsoft Excel spreadsheet;
• Ctrl + Delete - delete the selected text;
• Ctrl + H - "Search / Replace" window;
• Ctrl + Z - undo the last action performed;
• Ctrl + Alt + V - Paste Special.

Formatting

One of the important design elements of tables and cell ranges is formatting. In addition, formatting also affects the computational processes in Excel.

• Ctrl + Shift +% - enable percent format;
• Ctrl + Shift + $ - monetary expression format;
• Ctrl + Shift + # - date format;
• Ctrl + Shift +! - number format;
• Ctrl + Shift + ~ - general format;
• Ctrl + 1 - activates the cell formatting window.

Other hotkeys

In addition to the hotkeys that were specified in the above groups, Excel has such important keyboard shortcuts for calling functions:

• Alt + ’- select a design style;
• F11 - create a diagram on a new sheet;
• Shift + F2 - change a comment in a cell;
• F7 - check text for errors.

Of course, not all options for using hotkeys in Microsoft Excel were presented above. Nevertheless, we paid attention to the most popular, useful, and demanded ones. Of course, the use of hot keys can greatly simplify and speed up work in Microsoft Excel.

Even if you're familiar with Microsoft Excel, you may be surprised at the number and variety of keyboard shortcuts you can use to speed up your work and generally make things more convenient.

So, no one expects you to memorize all these keyboard shortcuts? Of course not! Every need is different, so some will be more beneficial to you than others. And even if you choose a few new combinations, it's worth it.

General program hotkeys

First, let's take a look at some common keyboard shortcuts for managing books.

• Ctrl + N : create a new book
• Ctrl + O: open an existing book
• Ctrl + S: save the book
• F12: open the "Save As" dialog
• Ctrl + W: close the book
• Ctrl + F4: Close Excel
• F4: Repeat the last command or action.
• Shift + F11: add a new sheet
• Ctrl + Z: undo action
• Ctrl + Y: repeat action
• Ctrl + F2: switch to preview mode
• F1: open the help panel
• Alt + Q: go to the field "Tell me what you want to do"
• F7: check spelling
• F9: calculate all sheets in all open books
• Shift + F9: calculate active worksheets
• Alt or F10: turn hints on or off
• Ctrl + F1: show or hide the feed
• Ctrl + Shift + U: expand or collapse the formula bar
• Ctrl + F9: minimize workbook window
• F11 : Create a bar chart based on the selected data (on a separate sheet)
• Alt + F1: create inline bar chart based on selected data (same sheet)
• Ctrl + F: search in a spreadsheet or find and replace
• Alt + F: open the "File" tab menu
• Alt + H: go to the "Home" tab
• Alt + N: open the "Insert" tab
• Alt + P: switch to the Page Layout tab
• Alt + M: go to the "Formulas" tab
• Alt + A: go to the "Data" tab
• Alt + R: go to the "Overview" tab
• Alt + W: switch to the "View" tab
• Alt + X: switch to add-ons tab
• Alt + Y: go to the "Help" tab
• Ctrl + Tab: switch between open books
• Shift + F3: insert function
• Alt + F8: creating, running, editing or deleting a macro
• Alt + F11: open the Microsoft Visual Basic for Applications editor

Move around a worksheet or cell

You can use keyboard shortcuts to easily navigate your entire worksheet, within a cell, or throughout your entire workbook.

• Left / Right Arrow: move one cell left or right
• Ctrl + Left / Right Arrow: move to the farthest cell to the left or right in a row
• Up / Down Arrow: move one cell up or down
• Ctrl + up / down arrow: move to the top or bottom cell in a column
• Tab: move to next cell
• Shift + Tab: move to the previous cell
• Ctrl + End: jump to the bottom-right cell
• F5: go to any cell by pressing F5 and typing the cell coordinate or cell name.

• Home: go to the leftmost cell in the current row (or go to the beginning of a cell when editing a cell)
• Ctrl + Home: go to the beginning of the worksheet
• Page Up / Down: move one screen up or down on a sheet
• Alt + Page Up / Down: move one screen to the right or left on the sheet
• Ctrl + Page Up / Down: go to previous or next worksheet

Selecting cells

You may have noticed from the previous section that you use the arrow keys to move between cells and the Ctrl key to change this movement. Using the Shift key to change the arrow keys expands the selected cells. There are also several other combos to speed up the selection.

• Shift + Left / Right Arrow: expanding the selection cell to the left or right
• Shift + Space: select the whole line
• Ctrl + space: select the entire column
• Ctrl + Shift + Space: select the whole worksheet

Editing cells

Excel also provides some keyboard shortcuts for editing cells.

• F2: cell editing
• Shift + F2: add or edit a cell comment
• Ctrl + X: cut cell content, selected data, or selected range of cells
• Ctrl + C or Ctrl + Insert: copy the contents of a cell, selected data, or a selected range of cells
• Ctrl + V or Shift + Insert: Paste the contents of a cell, selected data, or a selected range of cells
• Ctrl + Alt + V: open the Special Attachment dialog box
• Delete: delete cell content, selected data, or selected range of cells
• Alt + Enter: insert a hard return inside a cell (when editing a cell)
• F3: Insert cell name (if cells are specified in the sheet)
• Alt + H + D + C: Delete column
• Esc: undo an entry in a cell or formula bar
• Enter: Fill in an entry in a cell or formula bar

Formatting cells

Ready to format some cells? These keyboard shortcuts make your work easier!

• Ctrl + B: add or remove bold font to cell content, selected data, or selected range of cells
• Ctrl + I: add or remove italics to cell content, selected data, or selected range of cells
• Ctrl + U: add or remove underline of cell content, selected data, or selected range of cells
• Alt + H + H: choose a fill color
• Alt + H + B: add border
• Ctrl + Shift + &: apply outline border
• Ctrl + Shift + _ (underline): remove outline border
• Ctrl + 9: hide selected rows
• Ctrl + 0: hide selected columns
• Ctrl + 1: open the Format Cells dialog box
• Ctrl + 5: apply or remove strikethrough text
• Ctrl + Shift + $: apply currency format
• Ctrl + Shift +%: apply percentage format

The more you use keyboard shortcuts, the easier it is to memorize them. And no one expects you to remember them. Hopefully you've found some new ones that you can use to make your Excel life a little better.

This article describes Excel keyboard shortcuts (often also called Excel keyboard shortcuts) for the version of Microsoft Excel 2013, but most of the keyboard shortcuts apply to previous versions of Microsoft Excel: Excel 2010, Excel 2007, Excel 2003 (except for the shortcut keys for the Function Ribbon).

Hotkeys in Excel are shortcuts or keyboard shortcuts that you can use to quickly invoke various necessary actions and navigate the program. With the frequent implementation of the same type of work operations, using hot keys can significantly save your working time.

In localized versions of Microsoft Excel, some keyboard shortcuts may not work.

Excel shortcuts for working with the Ribbon

In new versions of Microsoft Office programs, starting with the 2007 version, the user interface has changed significantly. The so-called Ribbon has appeared at the top of the screen, containing tabs on which functional buttons are located.

Bookmarks and some buttons can be activated by keyboard shortcuts. To view these combinations, just press the Alt button.

Excel shortcut keys with Ctrl key

Excel hotkeys using function keys (F1-F12)

Other useful Excel keyboard shortcuts

Here are some useful keyboard shortcuts as well as function keys for Excel 2016, including keyboard shortcuts that you can use to access the Ribbon.

Frequently used keyboard shortcuts in Excel

This list lists the most common keyboard shortcuts for Excel 2016.

CTRL + W - Closing the spreadsheet.
CTRL + O - Opening a spreadsheet.
ALT + H - Go to the Home tab.
CTRL + S - Saving a spreadsheet.
CTRL + C - Copying.
CTRL + V - Insert.
CTRL + Z - Cancel the operation.
DELETE key - Deleting the contents of cells.
ALT + H, H - Choice of fill color.
CTRL + X - Cutting out.
ALT + N - Go to the Insert tab.
CTRL + B - Highlighting in bold.
ALT + H, A, C - Aligning the contents of cells in the center.
ALT + P - Go to the Page Layout tab.
ALT + A - Go to the Data tab.
ALT + W - Go to the View tab.
SHIFT + F10 or the shortcut menu key - Format a cell from the context menu.
ALT + H, B - Adding borders.
ALT + H, D, C - Column deletion.
ALT + M - Go to the Formula tab.

Using ribbon access keys

To navigate to a tab on the ribbon, press one of the following access keys.

ALT + Q - Opening the helper field on the ribbon and entering a search term to get help or open help.
ALT + F - Opening the File page and using Backstage view.
ALT + I - Opening the Home tab and formatting text and numbers, or using the search tool.
ALT + C - Open the "Insert" tab and insert pivot tables, charts, add-ins, sparklines, pictures, shapes, headers or labels.
ALT + H - Opening the "Page Layout" tab to work with themes, page settings, scale and alignment.
ALT + L - Opening the Formulas tab to insert, track and customize functions and calculations.
ALT + Ë - Opening the "Data" tab for connecting to data, sorting, filtering, analyzing and performing other actions.
ALT + P - Opening the Review tab to check spelling, add notes, and protect sheets and books.
ALT + O - Open the "View" tab to view page breaks, select view modes, show and hide grid lines and captions, change the scale, manage windows and areas, and view macros.

Working with ribbon and menu tabs using the keyboard

ALT or F10 (Use the access keys or arrow keys to move to another tab) - Select the active ribbon tab and activate the access keys.
TAB or SHIFT + TAB - Move focus to commands on the ribbon.
DOWN ARROW, UP ARROW, LEFT ARROW, or RIGHT ARROW - Move down, up, left or right between items on the ribbon.
SPACE or ENTER - Activation of the selected button.
ARROW TO DOWN - Opening the list for the selected team.
ALT + DOWN ARROW - Opens the menu for the selected button.
DOWN ARROW key - Selecting the next command after opening a menu or submenu.
CTRL + F1 - Hiding and showing the ribbon.
SHIFT + F10 or the shortcut menu key - Opens the context menu.
LEFT ARROW key - Go to a submenu in an open or selected menu.

Move through cells with keyboard shortcuts

SHIFT + TAB - Move to the previous cell in a worksheet or the previous option in a dialog box.
UP ARROW key - Go up the sheet one cell.
DOWN ARROW key - Move down the sheet one cell.
LEFT ARROW key - Move through the sheet one cell to the left.
RIGHT ARROW key - Move through the sheet one cell to the right.
CTRL + arrow key - Jump to the edge of the current data area on the sheet.
END arrow key - Switch to go to end mode. move to the next nonblank cell in the same column or row (it becomes active), exit the transition mode to the end. If the cells are empty, move to the last cell in the column or row.
CTRL + END - Move to the last cell on the sheet, located in the lowest used row of the rightmost used column.
CTRL + SHIFT + END - Expansion of the selection to the last cell of the sheet (lower right corner).
HOME + SCROLL LOCK - When the SCROLL LOCK mode is on, go to the cell in the upper left corner of the window.
CTRL + HOME - Go to the beginning of a line on a sheet. HOME Go to the beginning of the sheet.
PAGE DOWN - Move one screen down a sheet.
CTRL + PAGE DOWN - Go to the next sheet of the book.
ALT + PAGE DOWN - Move one screen to the right in the sheet.
PAGE UP - Move one screen up the sheet.
ALT + PAGE UP - Move one screen to the left in the sheet.
CTRL + PAGE UP - Go to the previous sheet of the book.
TAB - Move one cell to the right on the sheet. In a protected sheet, the transition between unprotected cells.

Select and perform actions using keyboard shortcuts

CTRL + A or CTRL + SHIFT + SPACEBAR - Selection of the whole sheet.
CTRL + SHIFT + PAGE DOWN - Selection of the current and next sheets of the book.
CTRL + SHIFT + PAGE UP - Selection of the current and previous sheets of the book.
SHIFT + arrow key - Expansion of the selected area by one cell.
CTRL + SHIFT + arrow key - Expand the selection to the last nonblank cell in the same row or column as the active cell, or, if the next cell is empty, to the next nonblank cell.
Activate selection mode and expand the selected range using the arrow keys. To turn off the mode, press the combination again. F8 - Activate selection mode and expand the selected range using the arrow keys. To turn off the mode, press the combination again.
SHIFT + F8 - Add non-contiguous cells or a range to a selection using the arrow keys.
ALT + ENTER - Start a new line in the current cell.
CTRL + ENTER - Fill the selected cells with the current value.
SHIFT + ENTER - Finish typing in the current cell and move to the cell above.
CTRL + SPACEBAR - Selecting the entire column on the sheet.
SHIFT + SPACEBAR - Selection of the entire line on the sheet.
CTRL + SHIFT + SPACEBAR - If an object is selected, selection of all objects on the sheet.
CTRL + SHIFT + HOME - Expansion of the selection to the beginning of the sheet.
CTRL + A or CTRL + SHIFT + SPACEBAR - Selection of the current area if the sheet contains data. Press the combination again to highlight the current area and its total rows. Press the combination a third time to select the entire sheet.
CTRL + SHIFT + asterisk (*) - Selection of the current area around the active cell or selection of the entire pivot table report.
HOME - If a menu or submenu is displayed on the screen, select the first command in it.
CTRL + Y - Repetition of the last command or action, if possible.
CTRL + Z - Undo the last action.

Formatting cells with keyboard shortcuts

CTRL + 1 - Formatting a cell using the Format Cells dialog box.
CTRL + SHIFT + F or CTRL + SHIFT + P - Formatting fonts using the Format Cells dialog box.
F2
SHIFT + F2 - Add or change notes to a cell.
CTRL + SHIFT + plus sign (+) - Insert blank cells using the "Insert" dialog box.
CTRL + minus sign (-) - Displays the Delete Cells dialog box to delete the selected cells.
CTRL + SHIFT + COLON (:) - Insert the current time.
CTRL + SHIFT + COLON (:) - Insert the current date.
CTRL + IMPACT SIGN (`) - Switch between display modes on the sheet of cell values \u200b\u200band formulas.
CTRL + APOSTROPHE (‘) - Copy the formula in the top cell to the current cell or to the formula bar.
CTRL + X - Moving selected cells.
CTRL + C - Copy selected cells.
CTRL + V - Insert content at the insertion point with replacement of the selected content.
CTRL + ALT + V - Pasting content using the Paste Special dialog box.
CTRL + I or CTRL + 3 - Applying or removing italics.
CTRL + B or CTRL + 2 - Apply or remove boldface style.
CTRL + U or CTRL + 4 - Underline text or remove underline.
CTRL + 5 - Apply or remove strikethrough formatting.
CTRL + 6 - Switch between the modes of hiding objects, displaying objects and displaying outlines of objects.
CTRL + SHIFT + AMPERSAND (&) - Insert structure frame into selected cells.
CTRL + SHIFT + UNDERLINE (_) - Removing the frame of the structure from the selected cells.
CTRL + 8 - Show or hide structure symbols.
CTRL + 9 - Hide selected lines.
CTRL + 0 - Hide selected columns.
CTRL + D - Using the Fill Down command to copy the contents and format of the top cell of the selected area to all the bottom cells.
CTRL + R - Using the "Fill Right" command to copy the content and format of the leftmost cell of the selected area to all cells to the right.
CTRL + SHIFT + TILDE (~) - Application of a common number format.
CTRL + SHIFT + DOLLAR SIGN ($) - Apply currency format with two decimal places (negative numbers are displayed in parentheses).
CTRL + SHIFT + PERCENTAGE SIGN (%) - Application of percentage format without fractional part.
CTRL + SHIFT + COVER (^) - Applying an exponential number format with two decimal places.
CTRL + SHIFT + NUMBER SIGN (#) - Applying date format with day, month and year.
CTRL + SHIFT + @ SIGN - Applying a time format with hours and minutes and AM or PM indices.
CTRL + SHIFT + EXCLAMATION MARK (!) - Applies a number format with two decimal places, a thousands separator and a minus sign (-) for negative values.
CTRL + K - Create or modify a hyperlink.
F7 - Check spelling on the active sheet or in the selected range.
CTRL + Q - Display of express analysis parameters for selected cells containing data.
CTRL + L or CTRL + T - Displays the "Create Table" dialog box.

Working with data, functions, and the formula bar with keyboard shortcuts

CTRL + SHIFT + STAR (*) - Highlighting the entire pivot table report.
F2 - Change the active cell and place the insertion point at the end of the content. If editing is disabled for a cell, the insertion point is placed in the formula bar. While editing a formula, you can turn point mode on or off to use the arrow keys to create a link.
CTRL + SHIFT + U - Expand or collapse the formula bar.
ESC - Cancel input to a cell or formula bar.
Enter - Finish typing in the formula bar and move to the cell below.
CTRL + END - Move the cursor to the end of the text in the formula bar.
CTRL + SHIFT + END - Selects all text in the formula bar from the cursor position to the end.
F9 - Calculate all sheets of all open books.
SHIFT + F9 - Calculate the current sheet.
CTRL + ALT + F9 - Calculation for all sheets of all open workbooks, regardless of whether they have been changed since the last calculation.
CTRL + ALT + SHIFT + F9 - Checking dependent formulas and calculating for cells in all open workbooks, including cells not marked for calculation.
ALT + SHIFT + F10 - Displays a menu or error check button message.
CTRL + A - Displays the "Function arguments" dialog box if the cursor is located to the right of the function name in the formula.
CTRL + SHIFT + A - Insert a parenthesized list of arguments if the cursor is to the right of a function name in a formula.
CTRL + E - Calling the function Instant fill to automatically detect the pattern in adjacent columns and fill the current column.
F4 - If a cell or range reference is selected in a formula, iterate over all combinations of absolute and relative references.
SHIFT + F3 - Insert function.
CTRL + SHIFT + DIRECT QUOTATION MARK (") - Copy the contents of the top cell to the current cell or to the formula bar.
ALT + F1 - Creation of an embedded chart with data in the current area.
F11 - Create a chart with data from the current range on a separate sheet.
ALT + M, M, D - Definition of a name for use in links.
F3 - Insert name from the "Insert name" dialog box (if names are defined in the book).
ENTER - Go to the first field of the next record in the form with data.
ALT + F8 - Create, run, edit or delete a macro.
ALT + F11 - Launch the Microsoft Visual Basic for Applications (VBA) editor.

Function Keys

F1 - Display the Excel Help task pane.
The keyboard shortcut CTRL + F1 shows or hides the ribbon.
The keyboard shortcut ALT + F1 creates a chart with data in the current area.
The keyboard shortcut ALT + SHIFT + F1 adds a new sheet to the workbook.

F2 - Change the active cell and move the insertion point to the end of the content. When editing is disabled for a cell, the insertion point is placed in the formula bar. While editing a formula, you can turn point mode on or off to use the arrow keys to create a link.
The SHIFT + F2 keyboard shortcut adds or modifies cell comments.
CTRL + F2 brings up the Print Preview area on the Print tab in Backstage view.

F3 - Displays the Insert Name dialog box. Available only if names are defined in the workbook (Formulas tab, Defined Names group, Assign Name).
SHIFT + F3 displays the Function Wizard - Step 1 of 2 dialog box.

F4 - Repeats the last command or action, if possible.
When a cell or range reference is selected in a formula, the F4 key switches between all possible absolute and relative values.
The keyboard shortcut CTRL + F4 closes the selected book window.
The keyboard shortcut ALT + F4 closes Excel.

F5 - Displays the Transition dialog box.
The shortcut keys CTRL + F5 restores the size of the selected workbook window.

F6 - Switches the insertion point between sheet, ribbon, task pane and zoom controls. In split sheets (View menu, Window group, Freeze Areas section, Split Window command), when you switch between panels and the ribbon area using the F6 key, the split areas are also included.
SHIFT + F6 navigates between worksheet, zoom controls, task pane, and ribbon.
If more than one book is open, CTRL + F6 moves the insertion point to the next book window.

F7 - Displays the Spelling dialog box for spell checking in the active sheet or selected range.
If the book window is not maximized, CTRL + F7 performs the Move command. Use the arrow keys to move the window and press Enter, or press ESC to cancel.

F8 - Switch to selection mode and exit from it. When enabled, the status bar displays Expand Selection, and the arrow keys expand selection.
The SHIFT + F8 keyboard shortcut lets you use the arrows to add non-adjacent cells or a range to a selection.
The shortcut CTRL + F8 invokes the Size command (on the Book Window Control menu) if the window is not maximized.
The keyboard shortcut ALT + F8 displays the Macro dialog box, which allows you to create, run, modify, and delete macros.

F9 - Calculates all sheets of all open books.
The SHIFT + F9 keyboard shortcut calculates the active sheet.
CTRL + ALT + F9 calculates all sheets of all open workbooks, regardless of whether they have been modified since the last calculation.
CTRL + ALT + SHIFT + F9 validates dependent formulas and then recalculates cells in all open workbooks, including cells not marked for calculation.
The shortcut keys CTRL + F9 minimizes the book window to an icon.

F10 - Toggles tooltips on and off (the same happens when you press the ALT key).
The SHIFT + F10 keyboard shortcut displays the context menu for the selected item.
The keyboard shortcut ALT + SHIFT + F10 displays the error check button menus or messages.
CTRL + F10 maximizes or resets the selected workbook window to its original size.

F11 - Creates a chart with data from the current range on a separate sheet.
The SHIFT + F11 keyboard shortcut inserts a new sheet into the workbook.
The keyboard shortcut ALT + F11 opens the Microsoft Visual Basic for Applications editor, in which you can create a macro in VBA.

F12 - Display the Save As dialog.

Other useful keyboard shortcuts

ALT - Displays key tips (new keyboard shortcuts) on the ribbon.
Examples:
ALT, W, P toggles the sheet to page layout mode.
ALT, W, L switches the sheet to normal mode.
ALT, W, I switches the sheet to page mode.

Arrow keys - Move one cell up, down, left or right through the sheet.
The keyboard shortcut CTRL + ARROW KEY navigates to the border of the current data area on the worksheet.
SHIFT + ARROW KEY expands the selection of cells by one cell.
CTRL + SHIFT + ARROW KEY expands the selection of cells to the last nonblank cell in the same row or column as the active cell, or, if the next cell is empty, expands the selection to the next nonblank cell.
The LEFT ARROW or RIGHT ARROW keys while the ribbon is highlighted helps you select a tab on the left or right. When a submenu is selected or open, these arrow keys move from the main menu to the submenu and back. With a ribbon tab selected, these keys help you navigate the tabs.
The DOWN ARROW or UP ARROW keys when a menu or submenu is open will navigate to the previous or next command. When a ribbon tab is selected, these keys move up and down through tab groups.
In the dialog box, the arrow keys move to the next or previous option in the selected drop-down list or option group.
The DOWN ARROW key or the ALT + DOWN ARROW key combination opens the selected drop-down list.

BACKSPACE - Removes one character to the left in the formula bar.
Also deletes the contents of the active cell.
In cell editing mode, deletes the character to the left of the insertion point.

DELETE - Clears the cell contents (data and formulas) in the selected cell without affecting cell formatting or comments.
In cell editing mode, deletes the character to the right of the insertion point.

END - With the END key you can turn on or off the end-to-end mode. In this mode, using the arrow keys, you can move to the next nonblank cell in the same row or column as the active cell. Go to end mode is turned off automatically when you press the arrow key. You must press the END key again before pressing the next arrow key. When enabled, this mode is displayed in the status bar.
If the cells are empty, pressing the END key and the arrow keys in succession moves to the last cell in the row or column.
Also, if a menu or submenu is displayed on the screen, the last menu command is selected.
CTRL + END moves to the last cell on the sheet, located in the lowest used row of the rightmost used column. If the cursor is in the formula bar, CTRL + END moves the cursor to the end of the text.
CTRL + SHIFT + END expands the selected range of cells to the last used cell on the worksheet (lower-right corner). When the cursor is in the formula bar, CTRL + SHIFT + END selects all text in the formula bar from the cursor position to the end of the line (this does not affect the height of the formula bar).

Enter - Completes entering a value in a cell in the formula bar and selects the cell below (default).
In the data entry form, moves to the first field of the next record.
Opens the selected menu (press F10 to activate the menu bar) or executes the selected command.
In a dialog box, performs the action assigned to the default button in the dialog box (this button is highlighted with a thick border, often the OK button).
The ALT + ENTER key combination starts a new line in the current cell.
CTRL + ENTER fills the selected cells with the current value.
SHIFT + ENTER completes the input in the cell and moves the insertion point to the cell above.

ESC - Cancels input to a cell or formula bar.
Closes a menu or submenu, dialog box, or message box.
It also closes the full screen mode, if applied, and reverts to normal mode, which displays the ribbon and status bar.

HOME - Moves to the beginning of a line or sheet.
When SCROLL LOCK is on, it jumps to the cell in the upper left corner of the window.
In addition, if a menu or submenu is displayed on the screen, this key selects the first command from the menu.
The shortcut keys CTRL + HOME navigates to a cell at the beginning of the sheet.
The CTRL + SHIFT + HOME keyboard shortcut expands the selected range of cells to the beginning of the sheet.

PAGE DOWN - Moves one screen down the sheet.
The ALT + PAGE DOWN key combination moves one screen to the right in the sheet.
The shortcut keys CTRL + PAGE DOWN moves to the next sheet of the book.
The shortcut keys CTRL + SHIFT + PAGE DOWN allows you to select the current and next sheets of the book.

PAGE UP - Moves one screen up the sheet.
The ALT + PAGE UP key combination moves one screen to the left in the sheet.
The shortcut keys CTRL + PAGE UP moves to the previous sheet of the book.
The shortcut keys CTRL + SHIFT + PAGE UP allows you to select the current and previous sheets of the book.

SPACE - In the dialog box, clicks the selected button or sets and unchecks the checkbox.
The keyboard shortcut CTRL + SPACEBAR selects a sheet column.
SHIFT + SPACEBAR selects a sheet row.
The keyboard shortcut CTRL + SHIFT + SPACEBAR selects the entire sheet.
If the sheet contains data, CTRL + SHIFT + SPACEBAR selects the current region. Pressing CTRL + SHIFT + SPACEBAR again selects the current region and its resulting rows. Pressing CTRL + SHIFT + SPACEBAR a third time selects the entire sheet.
When an object is selected, CTRL + SHIFT + SPACEBAR selects all objects on the sheet.
The keyboard shortcut ALT + SPACEBAR displays the Excel Window Control menu.

Tab - Moves one cell to the right.
Navigates between unprotected cells on a protected sheet.
Moves to the next parameter or parameter group in the dialog box.
The SHIFT + TAB keyboard shortcut moves to the previous sheet cell or the previous option in a dialog box.
The keyboard shortcut CTRL + TAB moves to the next tab in the dialog box.
The shortcut keys CTRL + SHIFT + TAB moves to the previous tab in the dialog box.