Here is a sneak peek into these Excel shortcuts. MS Excel Shortcuts Alt + Shift + F1, used for adding a new worksheet Ctrl + Z To undo the action Ctrl + F3, opens the excel name manager Ctrl + F9. Alternates between hiding objects, displaying objects, and displaying placeholders for objects. Several different shortcuts can be applied to a cell, such as editing a cell, aligning cell contents, adding a border to a cell, adding an outline to all the selected cells, and many more. Activates font point size drop down list.

Selects the whole of the current column(s). Cell Formatting Shortcut Keys A cell in Excel holds all the data that you are working on. Selects all cells to the left of the current selection, up to the edge of the current data region. Selects all cells to the right of the current selection, up to the edge of the current data region. Alt+E+S: The Paste Special is a tool that has saved many an Excel user from collapsing in a heap on the psychiatrists couch, and with good reason. Selects all cells above the current selection, up to the edge of the current data region. Selects all cells below the current selection, up to the edge of the current data region. Can also click the top left square of the worksheet to select all spreadsheet cells. Moves the current selected range left by one column. Moves the current selected range right by one column. Moves the current selected range up a row. Moves the current selected range down a row. to select a range, first use the left mouse key to click on a cell (or row or column) at the start of the range, then press the Shift key and select the cell at the end of the range. Selects all cells from the last selected cell to the current cell.I.e. to select more than one cell (or range), first use the mouse to select on the first cell (or range), then press the CTRL key and use the mouse to select further cells or ranges. Regarding using ALT+TAB to go to a different application, hold down the ALT key while repeatedly pressing the TAB key until the application you want is.

Basic excel keyboard shortcuts