How to Use Excel with Shortcut keys

Command Keystroke
Absolute/relative/mixed reference F4
AutoSum Alt =
Bold Ctrl-B
Border lines off Ctrl-Shift _
Border lines on Ctrl-Shift &
Calculate active sheet Shift-F9
Calculate all worksheets F9
Close Ctrl-W
Collapse selection to active cell Shift-Backspace
Comment insert/edit Shift-F2
Copy Ctrl-C
Copy formula from cell above Ctrl ‘
Copy value from cell above Ctrl-Shift “
Cut Ctrl-X
Date Ctrl ;
Delete range Ctrl –
Delete to end of line Ctrl-Del
Show values/formulas Ctrl `
Edit cell F2
Enter formula as array Ctrl-Shift-Enter
Fill down Ctrl-D
Fill right Ctrl-R
Find Ctrl-F
Format cell or range  (Format Cells dialog box) Ctrl-1
Format commas (2 decimal places) Ctrl-Shift !
Format currency (2 decimal places) Ctrl-Shift $
Format date (day, month, year) Ctrl-Shift #
Format exponential number (2 decimal places) Ctrl-Shift ^
Format general number Ctrl-Shift ~
Format percentage (0 decimal places) Ctrl-Shift %
Format time (hour and minute) Ctrl-Shift @
Formula =
Function Wizard Shift-F3
GoTo Ctrl-G
Group row/column Alt-Shift-Right
Hard Return in cell Alt-Enter
Hide selected column(s) Ctrl-0 (zero)
Hide selected row(s) Ctrl-9
Insert chart sheet F11
Insert Function components Ctrl-Shift-A
Insert range Ctrl-Shift-Plus
Insert worksheet Shift-F11
Italics Ctrl-I
Menu bar F10
Move between noncontiguous selections Ctrl-Alt-Left/Right
Move left/right one screen Alt-PgUp/PgDn
Move to beginning of worksheet Ctrl-Home
Move to edge of region Ctrl-Dn, Up, Left, Right
Move to end of row End, Enter
Move to end of worksheet Ctrl-End
Move to next corner of selection Ctrl .
Move up through a selection Shift-Enter
Name a range (Insert/Name/Create) Ctrl-Shift-F3
Name a range (Insert/Name/Define) Ctrl-F3
New Ctrl-N
Next window Ctrl-F6
Next worksheet Ctrl-PgUp
Open Ctrl-O
Outline symbols display/hide Ctrl-8
Paste Ctrl-V
Paste named range (Insert/Name/Paste) F3
Previous window Ctrl-Shift-F6
Previous worksheet Ctrl-PgDn
Print Ctrl-P
Repeat Find Shift-F4
Repeat/Redo Ctrl-Y
Replace Ctrl-H
Save Ctrl-S
Save As F12
Scroll to display active cell Ctrl-Backspace
Select array to which active cell belongs Ctrl /
Select cells directly referred to by selected formula Ctrl [
Select cells referred to by selected formula Ctrl-Shift {
Select cells with comments Ctrl-Shift ?
Select column Ctrl-spacebar
Select current region Ctrl-Shift *
Select formulas that directly refer to active cell Ctrl ]
Select formulas that refer to active cell Ctrl-Shift }
Select objects on worksheet Ctrl-Shift-spacebar
Select row Shift-spacebar
Select to beginning of row Shift-Home
Select to beginning of worksheet Ctrl-Shift-Home
Select to edge of region Ctrl-Shift-(Arrow)
Select to end of row End, Shift-Enter
Select to end of worksheet  Ctrl-Shift-End
Select visible cells in selection Alt ;
Select worksheet Ctrl-A
Shortcut menu Shift-F10
Spelling and Grammar check F7
Strikethrough on/off Ctrl-5
Style box Alt ‘
Tab inserted Ctrl-Alt-Tab
Time Ctrl-Shift-Colon
Underline Ctrl-U
Undo Ctrl-Z
Ungroup row/column Alt-Shift-Left
Unhide column(s) Ctrl-Shift )
Unhide row(s) Ctrl-Shift (

How to Convert a Column to a Row in Excel

Sometimes we’ve entered data in a column in Excel, only to realize later that it would be better to have this data in a row, or vise-versa.  Here’s a simple trick to convert any row or set of rows into a column, or vise-versa, in Excel.In case of Bulk data you want to convert in rows from column you don’t need to reenter data in rows and don’t need to waste your time.

Please Note: This is tested in Excel 2003, 2007, and 2010.  Here we took screenshots from Excel 2010 x64, but it works the same on the other versions.

Convert a Row to a Column

Here’s Sample data in Excel:

How to convert column in rows

If you want to change these two data columns into rows.  Select all the cells you wish to convert, right-click, and select copy (or simply press Ctrl+C):

Microsoft excel

Now, you should do right-click in the cell where you want to put the data in rows, and select “Paste Special Option from that drop down manue.”

Convert column in rows

Now a Pop up Window will be open.Check the box at the bottom that says “Transpose”, and then click OK.

Microsoft excel 2007

Now your Sample data will be converted in rows from columns! 

Microsoft excel 2003

This works the exact same for converting rows into columns.  Here’s some data in rows:

Excel

After copying and pasting special with Transpose selected, here’s the data in columns! This way you can save your time.

Microsoft excel

This is a great way to get your data organized just like you want in Excel.