Move to a task pane (task pane: A window within an Office application that provides commonly used commands. Perform the action for the selected item in a smart tag menu. Select the previous item in a smart tag menu. Select the next item in a smart tag menu. If more than one smart tag is present, switch to the next smart tag and display its menu or message. Maximize or restore the selected workbook window.Ĭopy a picture of the screen to the Clipboard.Ĭopy a picture of the selected window to the Clipboard.ĭisplay the menu or message for a smart tag. Use the arrow keys to resize the window, and when finished press ENTER. When a workbook window is not maximized, perform the Size command (on the Control menu for the workbook window). Use the arrow keys to move the window, and when finished press ESC.
When a workbook window is not maximized, perform the Move command (on the Control menu for the workbook window). When more than one workbook window is open, switch to the next workbook window. Switch to the previous pane in a worksheet that has been split.
Switch to the next pane in a worksheet that has been split (Window menu, Split command). Restore the window size of the selected workbook window. Shift + F3 − Opens the Excel formula window.Microsoft Excel 2003 Keyboard Shortcuts - printable cheatsheet Microsoft Excel 2003 Keyboard Shortcuts
For example, C6.į7 − Spell checks the selected text or document.į11 − Creates chart from the selected data.Ĭtrl + Shift + − Enters the current time.Īlt + Shift + F1 − Inserts New Worksheet.Īlt + Enter − While typing text in a cell pressing Alt + Enter will move to the next line allowing for multiple lines of text in one cell. For example, if you changed the color of text in another cell pressing F4 will change the text in cell to the same color.į5 − Goes to a specific cell. Below is the list of all the major shortcut keys in Microsoft Excel.Ĭtrl + A − Selects all contents of the worksheet.Ĭtrl + I − Italicizes the highlighted selection.Ĭtrl + U − Underlines the highlighted selection.Ĭtrl + 1 − Changes the format of selected cells.Ĭtrl + 5 − Strikethrough the highlighted selection.Ĭtrl + P − Brings up the print dialog box to begin printing.Ĭtrl + F9 − Minimizes the current window.Ĭtrl + F10 − Maximize currently selected window.Ĭtrl + F6 − Switches between open workbooks or windows.Ĭtrl + Page up − Moves between Excel work sheets in the same Excel document.Ĭtrl + Page down − Moves between Excel work sheets in the same Excel document.Ĭtrl + Tab − Moves between Two or more open Excel files.Īlt + = − Creates a formula to sum all of the above cellsĬtrl + ' − Inserts the value of the above cell into cell currently selected.Ĭtrl + Shift + ! − Formats the number in comma format.Ĭtrl + Shift + $ − Formats the number in currency format.Ĭtrl + Shift + # − Formats the number in date format.Ĭtrl + Shift + % − Formats the number in percentage format.Ĭtrl + Shift + ^ − Formats the number in scientific format.Ĭtrl + Shift + − Formats the number in time format.Ĭtrl + Arrow key − Moves to the next section of text.Ĭtrl + Space − Selects the entire column.Ĭtrl + - − Deletes the selected column or row.Ĭtrl + Shift + = − Inserts a new column or row.Ĭtrl + ~ − Switches between showing Excel formulas or their values in cells.į3 − After a name has been created F3 will paste names.į4 − Repeat last action.
EXCEL SHORTCUT KEYS FILTER WINDOWS
If you are familiar with windows operating system, you should be aware of most of them. MS Excel offers many keyboard short-cuts.
0 kommentar(er)
