Scribd
Upload
29 views3 pages

Excel Commands List Spanish PDF

This document describes the most common functions and keyboard shortcuts in Excel. It includes function keys such as F2 to edit cells, F4 to repeat actions, and F9 to calculate formulas. It also includes keyboard shortcuts like Ctrl+C to copy, Ctrl+V to paste, and Ctrl+Z to undo. It explains how to use combinations of function keys and Alt to access menus such as Alt+F11 to open the Visual Basic editor. Additionally, it provides shortcuts for moving between cells.

Uploaded by

ScribdTranslations
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
29 views3 pages

Excel Commands List Spanish PDF

This document describes the most common functions and keyboard shortcuts in Excel. It includes function keys such as F2 to edit cells, F4 to repeat actions, and F9 to calculate formulas. It also includes keyboard shortcuts like Ctrl+C to copy, Ctrl+V to paste, and Ctrl+Z to undo. It explains how to use combinations of function keys and Alt to access menus such as Alt+F11 to open the Visual Basic editor. Additionally, it provides shortcuts for moving between cells.

Uploaded by

ScribdTranslations
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Functions, Commands, and Shortcuts in Excel

Function keys in Excel


F2 Enters edit mode for the active cell
F4 Repeats the last action. Additionally, when writing a formula, it allows switching between references.
relative, absolute, and mixed.
F5 displays the Go to dialog.
F7 displays the Spelling dialog box.
F9 calculates the result of the formulas on all sheets of the open workbooks.
F10 activates the menu bar.
F11 creates a chart sheet with the selected cell range.

Basic keyboard shortcuts in Excel


Ctrl+A opens the Open dialog.
Ctrl+B Shows the Find dialog.
Ctrl+C copies the selected cells.
Ctrl+D copies a formula to the right across the selected range.
Ctrl+E selects all the cells in the current sheet.
Ctrl+G saves the workbook.
Ctrl+I opens the Go to dialog.
Ctrl+J copies a formula down over the selected range.
Ctrl+K applies italic formatting to the selected text.
Ctrl+N applies bold formatting to the selected text.
Ctrl+P shows the Print dialog.
Ctrl+R closes the workbook.
Ctrl+S Underline the selected text.
Ctrl+T displays the Create Table dialog.
Ctrl+U New workbook.
Ctrl+X cuts the selected cells.
Ctrl+Y Redoes the last undone action.
Ctrl+Z undoes the last action.
Ctrl+1 Displays the Format Cells dialog box.
Ctrl+2 applies bold formatting to the selected text.
Ctrl+3 applies italic formatting to the selected text.
Ctrl+4 underlines the selected text.
Ctrl+5 applies the strikethrough effect to the text.
Ctrl+6 hides or shows the sheet objects.
Ctrl+8 shows the schema symbols in the sheet.
Ctrl+9 hides the selected rows.
Ctrl+0 hides the selected columns.

Shortcuts with Alt + Function keys


Alt+F1 Inserts a chart in the current worksheet.
Alt+F2 displays the Save As dialog box.
Alt+F4 closes Excel.
Alt+F8 opens the Macro dialog box.
Alt+F10 Displays the "Selection and Visibility" panel for shapes.
Alt+F11 opens the Visual Basic for Applications editor.

Keyboard shortcuts for navigating in Excel


Alt+Page Up Move one screen to the right on the sheet.
Alt+Page Up Move one screen to the left on the sheet.
Ctrl+. Move to the next corner of a selected range.
Ctrl+PgDown Move to the next sheet.
Ctrl+Page Up Move to the previous sheet.
Ctrl+Home Move to cell A1 or to the upper left visible cell in the sheet.
Ctrl+End Move to the last used cell in the current range.
Ctrl+Backspace Moves the screen to show the active cell.
Ctrl+Tab Move to the next open workbook.
Ctrl+Arrow key Move to the end of the current row or column according to the key
pressed direction.

Keyboard shortcuts for selecting data


Ctrl+* Selects the current region of cells with data.
Ctrl+Space Selects the current column.
Shift+Page Down extends the selection down by one screen.
Shift+Page Up Extends the selection upwards by one screen.
Shift+Home extends the selection to the beginning of the line.
Shift+Space Selects the current row.
Shift+Arrow key extends the selection one cell in the same direction as the key.
pressed.
Other keyboard shortcuts in Excel
Alt+Space opens the control menu of the Excel window.
Ctrl+- Shows the Delete Cells dialog.
Ctrl++ shows the Insert Cells dialog.
Ctrl+Alt+V Displays the Paste Special dialog.

You might also like