How To Use Microsoft Excel with the keyboard

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 informationin the area in question.