How to cut in excel using the keyboard. Microsoft Excel program: hotkeys

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 occupied by the cells located one line below.

Deleting a row using the context menu

The easiest way to delete a row in Excel is to use the context menu, which is called by pressing the right mouse button. To delete a row, 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 row being deleted is shifted up. Similarly, you can delete several selected lines, to do 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.

Deleting a line from the keyboard with hotkeys

More fast way delete a line or several lines - use a combination of hot keys on the keyboard. To delete a line from the keyboard using hotkeys, you just need to press Ctrl + "-", that is, two keys, one of which is Ctrl, and the second is "-". It should be noted that the line (or several lines) must be preselected. The command deletes the selected area with a shift up. Its use allows you to save a little time and get rid of the extra movement that causes the context menu. You can speed up the process of deleting a line a little more using hot keys, but for this you have to do two things. Firstly, save the macro in your personal macro book and secondly, assign the execution of this macro to a specific key combination on the keyboard.

1. Save the macro

Macro code for deleting the line containing the selection marker. Using the code below, you can delete a line without using the mouse. The command determines the number of the line in which the selection marker (active cell) is located and deletes this line with a shift up. In this case, it is not required to select a line before deleting.

Sub Delete_Stroki_S_Aktivnoy_Yachejkoj() "macro deletes the row containing the active cell Rows(ActiveCell.Row).Delete Shift:=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 buttonsin the upper right corner of this field, copy the program code and paste it into the project module on your computer (more on how to save macro code ).

2. Assign a keyboard shortcut to the macro

About, how to assign a keyboard shortcut to a macro written separately. It should be noted that you should be careful about the choice of keys, since some combinations are already used by Excel. In addition, the application recognizes the alphabet of a given letter, so in order 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 deleting rows by condition

There are better tools for deleting strings that do not require you to use your own eyesight and attention to find the strings you want to delete. An example would be macro that searches for and deletes lines containing user-specified text, as well as Excel add-in to delete rows, with many various conditions and the ability to set these conditions in a convenient dialog box.

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

First of all, it should be noted that in the list of hotkeys below, a single "+" sign will serve as a character that denotes a keyboard shortcut. If the “++” sign is indicated, this means that on the keyboard you need to press the “+” key along with another key that is indicated. The name of the function keys is indicated as they are called on the keyboard: F1, F2, F3, etc.

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

General settings

Microsoft's general management tools 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

To navigate through a sheet or book, there are also hot keys.

• Ctrl + F6 - move between several books that are open;
• Tab - move to the next cell;
• Shift + Tab - move to the previous cell;
• Page Up - moving up by the size of the monitor;
• Page Down - move down by 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.

Hot keys for computing activities

The Microsoft Excel program 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 hotkeys.

• Alt+= - autosum activation;
• 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 in the table with information.

• F2 – edit mode of the marked cell;
• Ctrl++ - add columns or rows;
• Ctrl + - - delete selected columns or rows on a Microsoft Excel spreadsheet sheet;
• Ctrl+Delete - delete selected text;
• Ctrl+H – window "Find/Replace";
• Ctrl+Z - undo the action performed last;
• Ctrl+Alt+V - special paste.

Formatting

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

• Ctrl+Shift+% - enable percentage format;
• Ctrl+Shift+$ — monetary expression format;
• Ctrl+Shift+# - date format;
• Ctrl+Shift+! – number format;
• Ctrl+Shift+~ - general format;
• Ctrl+1 – activation of the cell formatting window.

Other hotkeys

In addition to the hot keys that were listed in the above groups, Excel has the following important combinations buttons on the keyboard to call functions:

• Alt + ' - the choice of design style;
• F11 - create a chart on a new sheet;
• Shift+F2 - change the comment in the cell;
• F7 - check text for errors.

Of course, not all options for using hot keys in Microsoft Excel were presented above. However, we paid attention to the most popular, useful, and in-demand of them. 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 might 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 those keyboard shortcuts? Of course not! All needs are 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 combinations keys to manage books.

• Ctrl + N: create a new book
• Ctrl+O: open an existing workbook
• ctrl+s: save the book
• F12: open the "Save As" dialog box
• 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 "Tell me what you want to do" box
• F7: check spelling
• F9: calculate all sheets in all open workbooks
• Shift+F9: calculate active worksheets
• Alt or F10: turn hints on or off
• Ctrl+F1: show or hide the ribbon
• 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 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: go to add-ons tab
• Alt+Y: go to the "Help" tab
• Ctrl+Tab: switching between open workbooks
• Shift+F3: insert function
• Alt+F8: creating, running, editing or deleting a macro
• Alt+F11: open the Microsoft Visual Basic for Applications Editor

Move within 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 on the left or right in a row
• Arrow Up/Down: moving 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 previous cell
• ctrl+end: move 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: move to the beginning of the worksheet
• Page Up/Down: moving 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: move to the previous or next worksheet

Cell selection

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

• Shift + left/right arrow: expand selection cell left or right
• Shift+Space: select the whole line
• Ctrl+Space: select entire column
• Ctrl+Shift+Space: select the entire worksheet

Cell Editing

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: copying 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
• 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 on the sheet)
• Alt+H+D+C: Delete column
• Esc: undo an entry in a cell or formula bar
• Enter: Complete an entry in a cell or in the formula bar

Cell Formatting

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

• ctrl+b: add or remove bold text 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 an underline to cell content, selected data, or a selected range of cells
• Alt+H+H: select a fill color
• Alt+H+B: add border
• Ctrl+Shift+&: apply outline border
• Ctrl + Shift + _ (underscore): remove 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 remember them. And no one expects you to remember them. I hope you've found some new ones that you can use to make your Excel life a little better.

This article describes the Excel hotkeys (often also referred to as Excel Shortcuts) for the Microsoft Excel 2013 version, but most of the keyboard shortcuts are applicable to previous versions of Microsoft Excel: Excel 2010, Excel 2007, Excel 2003 (except for the shortcuts for the Function Ribbon).

Hot keys in Excel are combinations or keyboard shortcuts with which you can quickly call up various necessary actions and navigate through the program. If you often perform the same type of work operations, using hot keys can significantly save your working time.

In localized versions of Microsoft Excel, a number of hotkeys may not work.

Excel Hotkeys for Working with the Ribbon of Functions (Ribbon)

In new versions of Microsoft Office programs, starting with version 2007, the user interface has changed significantly. At the top of the screen appeared the so-called Ribbon (Ribbon), containing bookmarks, which placed the function buttons.

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

Excel hotkeys with Ctrl key

Excel Hotkeys Using Function Keys (F1-F12)

Other Useful Excel Keyboard Shortcuts

Introducing 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 contains the most common keyboard shortcuts for Excel 2016.

CTRL+W— Closing the spreadsheet.
CTRL+O- Opening a spreadsheet.
ALT+H- Switch to the Home tab.
CTRL+S- Saving a spreadsheet.
CTRL+C— Copying.
CTRL+V- Insert.
CTRL+Z- Cancel operation.
DELETE key- Deleting the contents of the cells.
ALT+H, H- Selecting a fill color.
CTRL+X- Cutting out.
ALT+N- Switch to the Insert tab.
CTRL+B- Bold selection.
ALT+H, A, C- Align the contents of the cells to the center.
ALT+P- Switch to the Page Layout tab.
ALT+A— Go to the Data tab.
ALT+W— Go to the View tab.
SHIFT+F10 or shortcut menu key — Cell Formatting from the context menu.
ALT+H, B- Adding borders.
ALT+H, D, C— Deleting a column.
ALT+M- Switch to the Formula tab.

Using access keys for the ribbon

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

ALT+Q- Open the assistant box on the ribbon and enter a search term to get help or open help.
ALT+F- Opening the File page and using the Backstage view.
ALT+I- Open the Home tab and format text and numbers, or use the search tool.
ALT+C- Open the Insert tab and insert PivotTables, Charts, Add-Ins, Sparklines, Pictures, Shapes, Headings, or Labels.
ALT+Z- Opening the "Page Layout" tab to work with themes, page settings, scale and alignment.
ALT+L- Opening the "Formulas" tab for inserting, tracking and adjusting functions and calculations.
ALT+L- Open the Data tab to connect to data, sort it, filter it, analyze it, and more.
ALT+P- Open the Review tab to check spelling, add notes, and protect worksheets and books.
ALT+O- Open the View tab to view page breaks, select view modes, show or hide grid lines and titles, zoom, manage windows and panes, and view macros.

Working with ribbon tabs and menus using the keyboard

Alt or F10(To switch to another tab, use the access keys or arrow keys) - 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— Open the menu for the selected button.
DOWN ARROW key- Select the next command after opening a menu or submenu.
CTRL+F1- Hiding and showing the ribbon.
SHIFT+F10 or context menu key — Opens the context menu.
LEFT ARROW key— Move to a submenu in an open or selected menu.

Navigate cells with keyboard shortcuts

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

Highlighting and performing actions using keyboard shortcuts

CTRL+A or CTRL+SHIFT+SPACE- Selection of the entire 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— Expanding the selected area by one cell.
CTRL+SHIFT+arrow key— Extend the selection to the last non-blank cell in the same row or same column as the active cell, or, if the next cell is empty, to the next non-blank cell.
Activate the selection mode and expand the selected range using the arrow keys. To turn off the mode, press the combination again. F8 - Turn on the selection mode and expand the selected range using the arrow keys. To turn off the mode, press the combination again.
SHIFT+F8- Add to selection nonadjacent cells or range using arrow keys.
ALT+ENTER— Start a new line in the current cell.
CTRL+ENTER— Fill the selected cells with the current value.
SHIFT+ENTER— Completion of input in the current cell and transition to the cell above.
CTRL+SPACE— Selection of the entire column on the sheet.
SHIFT+SPACE- Selection of the entire line on the sheet.
CTRL+SHIFT+SPACE— If an object is selected, selects all objects on the sheet.
CTRL+SHIFT+HOME— Expanding the selected area to the beginning of the sheet.
CTRL+A or CTRL+SHIFT+SPACE— Selection of the current area, if the sheet contains data. Press the combination again to highlight the current region 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 PivotTable report.
HOME— If the screen displays a menu or submenu, select the first command in it.
CTRL+Y- Repeating the last command or action, if possible.
CTRL+Z— Undo the last action.

Format 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 a note to a cell.
CTRL+SHIFT+plus sign (+)- Inserting empty cells using the "Insert" dialog box.
CTRL+minus sign (-)— Displaying the Delete Cells dialog box for deleting selected cells.
CTRL+SHIFT+COLONS (:)— Insert current time.
CTRL+SHIFT+COLONS (:)— Insert the current date.
CTRL+ACCENT (`)— Switching between display modes on the sheet of cell values ​​and formulas.
CTRL+APOSTROPHE (‘)— Copy the formula of the top cell to the current cell or to the formula bar.
CTRL+X— Moving selected cells.
CTRL+C— Copy selected cells.
CTRL+V- Paste content at the insertion point, replacing the selected content.
CTRL+ALT+V- Paste content using the Paste Special dialog box.
CTRL+I or CTRL+3- Apply or remove italics.
CTRL+B or CTRL+2- Apply or remove bold.
CTRL+U or CTRL+4- Underline text or remove underlining.
CTRL+5- Apply or remove strikethrough formatting.
CTRL+6— Switching between hiding objects, showing objects and showing object outlines.
CTRL+SHIFT+AMPERSAND (&)— Inserting a structure frame into selected cells.
CTRL+SHIFT+underscore (_)— 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 in the selected area to all cells to the right.
CTRL+SHIFT+TILDE (~)— Applying a common number format.
CTRL+SHIFT+DOLLAR SIGN ($)— Apply currency format with two decimals (negative numbers are shown in parentheses).
CTRL+SHIFT+PERCENT SIGN (%)- Apply percentage format without fractional part.
CTRL+SHIFT+CAP (^)— Apply exponential number format with two decimal places.
CTRL+SHIFT+NUMBER SIGN (#)- Apply date format with day, month and year.
CTRL+SHIFT+@ SIGN— Use of the time format with display of hours and minutes and indexes AM or PM.
CTRL+SHIFT+EXCLAMATION (!)— Uses a number format with two decimal places, a thousands separator, and a minus sign (–) for negative values.
CTRL+K- Create or edit 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- Display the "Create Table" dialog box.

Work with data, functions, and the formula bar using keyboard shortcuts

CTRL+SHIFT+STAR (*)— Selection of the entire PivotTable report.
F2- Changing the active cell and placing 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. When editing a formula, you can turn pointing mode on or off to use the arrow keys to create a link.
CTRL+SHIFT+U- Expand or collapse the formula bar.
ESC- Cancels input in a cell or formula bar.
ENTER— Completing the input in the formula bar and moving to the cell below.
CTRL+END— Move the cursor to the end of the text in the formula bar.
CTRL+SHIFT+END— Selection of all text in the formula bar from the cursor position to the end.
F9- Calculate all sheets of all open workbooks.
SHIFT+F9— Calculate the current sheet.
CTRL+ALT+F9- Calculation for all sheets of all open workbooks, regardless of whether changes have been made to them since the last calculation.
CTRL+ALT+SHIFT+F9- Check dependent formulas and calculate for cells in all open workbooks, including cells not marked for calculation.
ALT+SHIFT+F10- Display the menu or message of the error check button.
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— Insertion in parentheses of the list of arguments, if the cursor is located to the right of the function name in the formula.
CTRL+E— Calling the Instant Fill function to automatically detect the pattern in adjacent columns and fill the current column.
F4— If a cell or range reference is selected in the formula, iterate over all combinations of absolute and relative references.
SHIFT+F3- Function insertion.
CTRL+SHIFT+STRAIGHT QUOTATION MARK (")— Copy the contents of the top cell to the current cell or 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- Inserting a name from the "Insert Name" dialog box (if names are defined in the workbook).
ENTER - Move to the first field of the next record in the data form.
ALT+F8- Create, run, edit or delete a macro.
ALT+F11- Launches 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 data chart in the current area.
The keyboard shortcut ALT+SHIFT+F1 adds a new sheet to the workbook.

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

F3— Display the Insert Name dialog box. Only available if names are defined in the workbook (Formulas tab, Defined Names group, Assign Name).
The key combination SHIFT+F3 displays the Function Wizard dialog box - step 1 of 2.

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

F5— Displays the Transition dialog box.
The CTRL+F5 key combination restores the size of the selected workbook window.

F6- Switches the entry point between sheet, ribbon, task pane, and zoom controls. In split sheets (View menu, Window group, Freeze Panes section, Split Window command), when switching between panels and a ribbon area using the F6 key, split panes also participate in the switch.
The keyboard shortcut SHIFT+F6 navigates between the sheet, the zoom controls, the task pane, and the 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 checking spelling in the active sheet or selected range.
If the book window is not maximized, the keyboard shortcut CTRL+F7 executes the Move command. Use the cursor keys to move the window and press the Enter key, or press the ESC key to cancel.

F8- Switching to selection mode and exiting it. When enabled, the status bar displays Expand Selection and the arrow keys expand the selection.
The keyboard shortcut SHIFT+F8 allows you to use the arrows to add nonadjacent cells or a range to the selection.
The CTRL+F8 key combination invokes the Size command (on the Book Window's Control menu) if the window is not maximized.
The keyboard shortcut ALT+F8 displays the Macro dialog box, which allows you to create, run, edit, and delete macros.

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

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

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

F12— Display the Save As dialog box.

Other useful keyboard shortcuts

ALT- Displays key tips (new keyboard shortcuts) on the ribbon.
Examples:
ALT, W, P switches 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 the sheet one cell up, down, left or right.
The CTRL+ARROW key combination jumps to the boundary of the current sheet data area.
The SHIFT+ARROW key combination expands the selected area of ​​cells by one cell.
The CTRL+SHIFT+ARROW key combination expands the cell selection to the last non-blank cell in the same row or same column as the active cell, or, if the next cell is empty, expands the selection to the next non-blank cell.
The LEFT ARROW or RIGHT ARROW keys, when the ribbon is selected, help you select a tab on the left or right. When a submenu is selected or open, these arrow keys allow you to move from the main menu to the submenu and back. When a ribbon tab is selected, these keys help you navigate through the tabs.
The DOWN ARROW or UP ARROW keys, when a menu or submenu is open, navigate to the previous or next command. When a ribbon tab is selected, these keys allow you to navigate up and down tab groups.
In a dialog box, the arrow keys navigate to the next or previous option in the selected drop-down list or option group.
The DOWN ARROW key or ALT+DOWN ARROW opens the selected drop-down list.

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

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

END- With the END key, you can turn on or off the jump to the end mode. In this mode, using the arrow keys, you can move to the next non-blank cell in the same row or column as the active cell. Skip to end mode is turned off automatically when an arrow key is pressed. You must press the END key again before pressing the next arrow key. When this mode is enabled, it 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.
The CTRL+END key combination navigates to the last cell on the worksheet, located in the lowest usable row of the rightmost usable column. If the cursor is in the formula bar, the CTRL+END key combination moves the cursor to the end of the text.
The CTRL+SHIFT+END key combination expands the selected range of cells to the last used worksheet cell (bottom right corner). If 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- Ends entering a value into a cell in the formula bar and selects the cell below (default).
In the data entry form, navigates 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 (that button has a thick border, often an OK button).
The keyboard shortcut ALT+ENTER starts a new line in the current cell.
The CTRL+ENTER key combination fills the selected cells with the current value.
The SHIFT+ENTER key combination completes the entry in the cell and moves the insertion point to the cell above.

ESC- Cancels input in a cell or formula bar.
Closes a menu or submenu, dialog box, or message box.
Also closes full screen mode, if it was applied, and returns to normal mode, which displays the ribbon and status bar.

HOME- Moves to the beginning of a line or sheet.
When enabled, SCROLL LOCK navigates to a 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 CTRL+HOME key combination jumps to the cell at the beginning of the worksheet.
The keyboard shortcut CTRL+SHIFT+HOME expands the selected range of cells to the beginning of the worksheet.

PAGE DOWN— Moves one screen down the sheet.
The ALT+PAGE DOWN key combination moves one screen to the right in the worksheet.
The CTRL+PAGE DOWN key combination moves to the next sheet in the book.
The key combination 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 on the sheet.
The CTRL+PAGE UP key combination moves to the previous sheet in the book.
The keyboard shortcut CTRL+SHIFT+PAGE UP allows you to select the current and previous sheets of the book.

SPACE— In a dialog box, clicks the selected button or sets and unchecks the checkbox.
The CTRL+SPACE key combination selects a worksheet column.
The SHIFT+SPACE key combination selects a sheet row.
The CTRL+SHIFT+SPACE key combination selects the entire worksheet.
If the worksheet contains data, CTRL+SHIFT+SPACE will select the current area. Pressing CTRL+SHIFT+SPACEBAR again selects the current region and its summary lines. A third press of CTRL+SHIFT+SPACE will select the entire sheet.
When an object is selected, CTRL+SHIFT+SPACEBAR allows you to select all objects on the sheet.
The keyboard shortcut ALT+SPACEBAR displays the Control menu of the Excel window.

tab- Moves one cell to the right.
Navigates between unprotected cells on a protected sheet.
Moves to the next option or group of options in the dialog box.
The SHIFT+TAB key combination navigates to the previous sheet cell or the previous option in a dialog box.
The CTRL+TAB key combination navigates to the next tab in the dialog box.
The CTRL+SHIFT+TAB key combination navigates to the previous tab in the dialog box.