Excel Shortcut

/, Uncategorized/Excel Shortcut

Excel Shortcut

Excel is one of the powerful software is the Microsoft Office Suite.

With so many commands, keyboard shortcut keys come in very handy.

Here are few shortcut keys for formatting generic cialis 5mg and other commands :

Display the Style command (Format menu)  =     ALT+’ (APOSTROPHE)
Display the Cells command (Format menu)   = CTRL+1
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, 1000 separator, and – for negative values   = CTRL+SHIFT+!
Apply the outline border  = CTRL+SHIFT+&
Remove all borders   = CTRL+SHIFT+_
Apply or remove bold formatting   = CTRL+B
Apply or remove italic formatting    = CTRL+I
Apply or remove an underline    = CTRL+U
Apply or remove strikethrough formatting  = CTRL+5
Hide rows    = CTRL+9
Unhide rows   = CTRL+SHIFT+(
Hide columns =  CTRL+0 (ZERO)
Unhide columns =  CTRL+SHIFT+)

Edit data by using shortcut keys

Edit the active cell =  F2
Cancel an entry in the cell or formula bar = ESC
Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents =  BACKSPACE
Paste a name into a formula  = F3
Complete a cell entry = ENTER
Enter a formula as an array formula =  CTRL+SHIFT+ENTER
Display the Formula Palette after you type a valid function name in a formula = CTRL+A
Insert the argument names and parentheses for a function, after you type a valid function name in a formula =  CTRL+SHIFT+A

Insert, delete, and copy a selection by using shortcut keys

Copy the selection = CTRL+C
Paste the selection = CTRL+V
Cut the selection = CTRL+X
Clear the contents of the selection =DELETE
Insert blank cells = CTRL+SHIFT+PLUS SIGN
Delete the selection = CTRL+ –
Undo the last action = CTRL+Z

Move within a selection by using shortcut keys
To                                                                                                                                                                                             Press
Move from top to bottom within the selection (down), or in the direction that is selected on the Edit tab = (Tools menu, Options command) ENTER
Move from bottom to top within the selection (up), or opposite to the direction that is selected on the Edit tab =(Tools menu, Options command) SHIFT+ENTER
Move from left to right within the selection, or move down one cell if only one column is selected =TAB
Move from right to left within the selection, or move up one cell if only one column is selected = SHIFT+TAB
Move clockwise to the next corner of the selection = CTRL+PERIOD
Move to the right between nonadjacent selections = CTRL+ALT+RIGHT ARROW
Move to the left between nonadjacent selections = CTRL+ALT+LEFT ARROW

By | 2010-12-24T16:01:07+00:00 December 24th, 2010|Excel, Uncategorized|Comments Off on Excel Shortcut

About the Author: