 |
| How To Use Microsoft Excel with the keyboard |
- F1: Opens the online help
- TAB: Select the next cell to the right.
- SHIFT + TAB: Select the next cell to the left.
- CTRL + TAB: Switch between open documents in Excel.
- MIAUSC + F3: Opens the window for inserting a function (Sum, AVG, etc.) in a cell. Once you open the window you must choose one of the Many functions, then press "OK" and indicate the cells to be computed. Between a cell and the other place ";"
- F2: Allows you to edit the selected cell.
- CTRL + plus sign (+): Adds a cell or a row in the selected point.
- CTRL +: Delete a cell or a row.
- CTRL + 1: Opens the window to set up the cell format.
- CTRL + F9: Minimize the active worksheet.
- CTRL + F10: Maximizes or returns to window the active worksheet.
- CTRL + N: The new command, open a new worksheet.
- CTRL + F12: Opened command, to open another spreadsheet.
- Shift + F12: "Save" Command. Saves the current document in the format and with the name that is already assigned.
- CTRL + page up (or PAGGIU '): Switches to the next or previous sheet.
- CTRL + 7: Shows or hides the standard toolbar.
- CTRL + W: Delete an entire column and all of its contents.
- Shift + F5: Opens the Find window to search within the document.
- CTRL + 6: Alternatively view and hides the objects on the active sheet (pictures, etc.).
- CTRL + SHIFT +%: Apply the percentage format with no decimal places. In practice, using the command after selecting a cell with a number, apply the percentage to the number by multiplying it by 100.
- CTRL + B: Apply or remove strikethrough. With the strikeout on the writing appear with a line overlay.
- CTRL + SHIFT + (: View extended features in combined or each cell.
- CTRL + SHIFT + &: Applies the border to the selected cells.
- CTRL + SHIFT + _: Removes the edge from the selected cells.
- F11: Create a chart with the data contained in the selected area. Of course there should be suitable information in the area in question.
