Microsoft excel 2003 shortcut keys

To do this, follow next steps:. Select an existing chart. In the lower-left of the dialog box, click Set as default chart. You can define a custom template as the default chart with custom colors, effects, and settings. For more details, see How to change the default colors that excel uses for chart series.

If you encountered a bug or want to suggest a feature in Microsoft Office, we recommend you contact Microsoft Support. We are not a division, a subsidiary, or a contractor of Microsoft Corporation, and we are not responsible for their decisions. Also, we are not responsible for access configuration or software updates in your company.

The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback?

Submit feedback. Thank you for your feedback! Open the Home tab and format text and numbers and use the Find tool. Select the active tab on the ribbon and activate the access keys.

Alt or F To move to a different tab, use access keys or the arrow keys. Move down, up, left, or right, respectively, among the items on the ribbon. When a menu or submenu is open, move to the next command. Move to the submenu when a main menu is open or selected. Move to the previous cell in a worksheet or the previous option in a dialog box. Move to the edge of the current data region in a worksheet. Move to the last cell on a worksheet, to the lowest used row of the rightmost used column.

Extend the selection of cells to the last used cell on the worksheet lower-right corner. Move to the cell in the upper-left corner of the window when Scroll lock is turned on. Open the list of validation choices on a cell that has data validation option applied to it.

Cycle through floating shapes, such as text boxes or images. Exit the floating shape navigation and return to the normal navigation. Format fonts in the Format Cells dialog box. Insert a note. Open and edit a cell note. Insert a threaded comment. Open and reply to a threaded comment. Open the Insert dialog box to insert blank cells. Open the Delete dialog box to delete selected cells. Switch between displaying cell values or formulas in the worksheet. Copy a formula from the cell above the active cell into the cell or the formula bar.

Paste content at the insertion point, replacing any selection. Switch between hiding objects, displaying objects, and displaying placeholders for objects. Apply the Percentage format with no decimal places.

Apply the Scientific number format with two decimal places. Apply the Date format with the day, month, and year. Display the Quick Analysis options for selected cells that contain data. Open the Workbook Statistics dialog box. Paste only the data validation settings from copied cells. Paste all cell contents and formatting from copied cells.

Paste only formulas and number formats from copied cells. Paste only the values not formulas and number formats from copied cells. Turn extend mode on and use the arrow keys to extend a selection. Press again to turn off.

Add a non-adjacent cell or range to a selection of cells by using the arrow keys. Select all objects on a worksheet when an object is selected.

Extend the selection of cells to the beginning of the worksheet. Select the first command on the menu when a menu or submenu is visible. While hovering over the collapsed items, press and hold the Shift key and scroll down.

While hovering over the expanded items, press and hold the Shift key and scroll up. Complete an entry in the formula bar and select the cell below.

Move the cursor to the end of the text when in the formula bar. Select all text in the formula bar from the cursor position to the end. Display the menu or message for an Error Checking button. Copy the value from the cell above the active cell into the cell or the formula bar.

Create a chart of the data in the current range in a separate Chart sheet. Open the context menu for the selected cell, column, or row. Select all cells from the current location to the last cell of the column. Select all cells from the current location to the first cell of the column. Select all cells from the current location to the last cell of the row. Select all cells from the current location to the first cell of the row. Move to the first cell in the upper-left corner of selected table.

Move to the last cell in the lower-right corner of selected table. Close a dialog box or cancel a process, such as a paste operation. F1 alone: displays the Excel Help task pane. F4 alone: repeats the last command or action, if possible.

F5 alone: displays the Go To dialog box. F9 alone: calculates all worksheets in all open workbooks. F10 alone: turns key tips on or off. Pressing Alt does the same thing. F12 alone: displays the Save As dialog box. Displays the Key Tips new shortcuts on the ribbon.

Alt, W, L switches the worksheet to Normal view. Move one cell up, down, left, or right in a worksheet. Deletes one character to the left in the formula bar.

Clears the content of the active cell. In cell editing mode, it deletes the character to the left of the insertion point. In cell editing mode, it deletes the character to the right of the insertion point. End also selects the last command on the menu when a menu or submenu is visible.

Completes a cell entry from the cell or the formula bar and selects the cell below by default. In a data form, it moves to the first field in the next record.

Cancels an entry in the cell or formula bar. Closes an open menu or submenu, dialog box, or message window. Moves to the beginning of a row in a worksheet. Moves to the cell in the upper-left corner of the window when Scroll lock is turned on.

Selects the first command on the menu when a menu or submenu is visible. Moves one screen down in a worksheet. Moves one screen up in a worksheet. In a dialog box, performs the action for the selected button, or selects or clears a checkbox. Moves one cell to the right in a worksheet. Moves between unlocked cells in a protected worksheet.

Moves to the next option or option group in a dialog box. Perform the action assigned to the default button the button with the bold outline.

Shift, then scroll the mouse wheel up for left, down for right. Complete a cell entry and move to the right in the selection. Complete a cell entry and move to the left in the selection. Delete the character to the left of the insertion point or delete the selection.

Delete the character to the right of the insertion point or delete the selection. Delete text to the end of the line. Edit the active cell and position the insertion point at the end of the line.

Toggle the formula reference style between absolute, relative, and mixed. Alternate between displaying cell values and displaying cell formulas. Display the Modify Cell Style dialog box. Apply the exponential number format with two decimal places.

Apply the time format with the hour and minute, and indicate AM or PM. Extend the selection to the last nonblank cell in the same column or row as the active cell. Extend the selection to the last cell used on the sheet lower-right corner.

Select only the active cell when multiple cells are selected. Turn on the capability to extend a selection by using the arrow keys. Select the current array, which is the array that the active cell belongs to. Print the current sheet. Fill Right. Saves the open worksheet. Underlines all cells in the highlighted section. Pastes everything copied onto the clipboard.

Closes the current workbook. Cuts all cells within the highlighted section. Repeats the last entry. Undo the last action.

Changes the format of the selected cells. Bolds all cells in the highlighted section. Puts italics all cells in the highlighted section. Puts a strikethrough all cells in the highlighted section. Shows or hides objects.

Shows or hides the toolbar. Toggles the outline symbols. Hides rows. Hides columns. Enters the current time. Enters the current date. Changes between displaying cell values or formulas in the worksheet. Copies a formula from the cell above. Copies value from the cell above. Deletes the selected column or row. Inserts a new column or row. Switches between showing Excel formulas or their values in cells. Applies time formatting. Applies currency formatting. Applies date formatting.

Applies percentage formatting. Applies exponential formatting. Selects the current region around the active cell. Places border around selected cells. Removes a border. Unhide rows. Unhide columns. Selects the array containing the active cell. Selects all cells referenced by formulas in the highlighted section.

Selects cells that contain formulas that reference the active cell. Selects all cells directly or indirectly referenced by formulas in the highlighted section. Selects cells that contain formulas that directly or indirectly reference the active cell. Fills the selected cells with the current entry. Selects the entire column. Selects the entire worksheet. Move to cell A1. Move to the last cell on a worksheet. Move between Two or more open Excel files.

Activates the previous workbook. Inserts argument names into a formula. Opens the drop-down menu for fonts. Selects all of the cells that contain comments.