excel shorcuts in tabular form

CA CS CIMA Prakash Somani (Landmark Group) (23502 Points)

06 September 2007  

ENTER

Complete a cell entry and move down in the selection

ALT+ENTER

Start a new line in the same cell

CTRL+ENTER

Fill the selected cell range with the current entry

SHIFT+ENTER

Complete a cell entry and move up in the selection

TAB

Complete a cell entry and move to the right in the selection

SHIFT+TAB

Complete a cell entry and move to the left in the selection

ESC

Cancel a cell entry

BACKSPACE

Delete the character to the left of the insertion point, or delete the selection

DELETE

Delete the character to the right of the insertion point, or delete the selection

CTRL+DELETE

Delete text to the end of the line

Arrow keys

Move one character up, down, left, or right

HOME

Move to the beginning of the line

F4 or CTRL+Y

Repeat the last action

SHIFT+F2

Edit a cell comment

CTRL+SHIFT+F3

Create names from row and column labels

CTRL+D

Fill down

CTRL+R

Fill to the right

BACKSPACE

Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents

ENTER

Complete a cell entry

CTRL+SHIFT+ENTER

Enter a formula as an array formula

ESC

Cancel an entry in the cell or formula bar

CTRL+A

Display the Formula Palette after you type a function name in a formula

CTRL+SHIFT+A

Insert the argument names and parentheses for a function after you type a function name in a formula

CTRL+K

Insert a hyperlink

ENTER (in a cell with a hyperlink)

Activate a hyperlink

F2

Edit the active cell and position the insertion point at the end of the line

F3

Paste a defined name into a formula

SHIFT+F3

Paste a function into a formula

F9

Calculate all sheets in all open workbooks

CTRL+ALT+F9

Calculate all sheets in the active workbook

SHIFT+F9

Calculate the active worksheet

= (equal sign)

Start a formula

ALT+= (equal sign)

Insert the AutoSum formula

CTRL+; (semicolon)

Enter the date

CTRL+SHIFT+: (colon)

Enter the time

CTRL+SHIFT+" (quotation mark)

Copy the value from the cell above the active cell into the cell or the formula bar

CTRL+` (single left quotation mark)

Alternate between displaying cell values and displaying cell formulas

CTRL+' (apostrophe)

Copy a formula from the cell above the active cell into the cell or the formula bar

ALT+DOWN ARROW

Display the AutoComplete list

ALT+' (apostrophe)

Display the Style dialog box

CTRL+1

Display the Format Cells dialog box

CTRL+SHIFT+~

Apply the General number format

CTRL+SHIFT+$

Apply the Currency format with two decimal places (negative numbers appear in parentheses)

CTRL+SHIFT+%

Apply the Percentage format with no decimal places

CTRL+SHIFT+^

Apply the Exponential number format with two decimal places

CTRL+SHIFT+#

Apply the Date format with the day, month, and year

CTRL+SHIFT+ @

Apply the Time format with the hour and minute, and indicate A.M. or P.M.

CTRL+SHIFT+!

Apply the Number format with two decimal places, thousands separator, and minus sign (–) for negative values

CTRL+SHIFT+&

Apply the outline border

CTRL+SHIFT+_

Remove outline borders

CTRL+B

Apply or remove bold formatting

CTRL+I

Apply or remove italic formatting

CTRL+U

Apply or remove an underline

CTRL+5

Apply or remove strikethrough formatting

CTRL+9

Hide rows

CTRL+SHIFT+( (opening parenthesis)


Unhide rows

CTRL+0 (zero)

Hide columns

CTRL+SHIFT+) (closing parenthesis)


Unhide columns

F10 or ALT

Make the menu bar active, or close a visible menu and submenu at the same time

TAB or SHIFT+TAB (when a toolbar is active)


Select the next or previous button or menu on the toolbar

CTRL+TAB or CTRL+SHIFT+TAB (when a toolbar is active)


Select the next or previous toolbar

ENTER

 

SHIFT+F10

Show a shortcut menu

ALT+SPACEBAR

Show the program icon menu (on the program title bar)