Hei hi a sei sia, mahse a tangkai bawk sia, harsa tak a ka lak khawm a ia.In duh chuan chuah ula, a rem loh pawn pawi lo.

*Description Shortcut Key
*New file Ctrl + N
Open file Ctrl + O
Save file Ctrl + S

Move between open workbooks Ctrl + F6
Close file Ctrl + F4
Save as F12
Display the print menu Ctrl + P
Select whole spreadsheet Ctrl + A
Select column Ctrl + Space
Select row Shift + Space
Undo last action Ctrl + Z
Redo last action Ctrl + Y
Start a formula Equals Sign (eg. SUM(A1+A2)
Exit Excel 97 Alt + F4
*Navigating *

*Description Shortcut Key
*Move to next cell in row Tab
Move to previous cell in row Shift + Tab
Up one screen Page Up
Down one screen Page Down
Move to next worksheet Ctrl + Page Down
Move to previous worksheet Ctrl + Page Up
Go to first cell in data region Ctrl + Home
Go to last cell in data region Ctrl + End
*Formatting Text In Worksheet*

*Description Shortcut Key
*Bold toggle for selection Ctrl + B
Italic toggle for selection Ctrl + I
Underline toggle for selection Ctrl + U
Strikethrough for selection Ctrl + 5
Change the font Ctrl + Shift + F
Change the font size Ctrl + Shift + P
Apply outline borders Ctrl + Shift + 7
Remove all borders Ctrl + Shift + Underline
Wrap text in same cell Alt + Enter
*Formatting Cells*

*Description Shortcut Key
*Format cells Ctrl + 1
Select font Ctrl + Shift + F
Select point size Ctrl + Shift + P
Format as currency Ctrl + Shift + 4
Format as general (to remove any formatting) Ctrl + Shift + # (hash
sign)
Format as percentage Ctrl + Shift + 5
Format as number Ctrl + Shift + 1
*Editing/Deleting Text*

*Description Shortcut Key
*Delete one character to right Delete
Delete one character to left Backspace
Edit active cell F2
Cancel cell entry Escape Key
*Highlighting Cells*

*Description Shortcut Key
*Select entire worksheet Ctrl + A
Select entire row Shift + Spacebar
Select entire column Ctrl + Spacebar
Manual select Hold Shift + with Left, Right, Up, Down Arrow Key
*Copying and Moving Text*

*Description Shortcut Key
*Cut Ctrl + X
Copy Ctrl + C
Paste Ctrl + V
*Inserting Text Automatically*

*Description Shortcut Key
*Autosum a range of cells Alt + Equals Sign
Insert the date Ctrl + ; (semi-colon)
Insert the time Ctrl + Shift + ; (semi-colon)
Insert columns/rows Ctrl + Shift + + (plus sign)
Insert a new worksheet Shift + F11
*Misc*

*Description Shortcut Key
*Find text Ctrl + F
Replace text dialog Ctrl + H
Create a chart automatically on new sheet F11
Edit a cell comment Shift + F2
*Main Jaws Keystrokes In Excel*

*Description Shortcut Key
*Say Version of Excel Ctrl + Shift + V
Move to Next Sheet Ctrl + Page Down
Move to Prior Sheet Ctrl + Page Up
Go to a cell command Ctrl + G
Collapse Selection To Active Cell Shift + Backspace
Say Active Cell Coordinates Insert + C
AutoSum Alt + Equals
Formula Mode Equals Sign
Insert Date In Current Cell Ctrl + ; (semicolon)
Insert Time In Current Cell Ctrl + Shift + ; (semicolon)
Current Column First Cell From Top Alt + 1
Current Column Second Cell From Top Alt + 2
Current Column Third Cell From Top Alt + 3
Current Column Fourth Cell From Top Alt + 4
Data Region Left Ctrl + Left Arrow
Data Region Right Ctrl + Right Arrow
Data Region Down Ctrl + Down Arrow
Data Region Up Ctrl + Up Arrow
Select Whole Data Region Ctrl + Shift + 8
Say Formula Ctrl + F2
Spell Check F7
Report Gridline Status Alt + Shift + g
Read Row Total Insert + Delete
Read Column Total Insert + Enter
Say Column Title Alt + Shift + C
Say Row Title Alt + Shift + R
Say Visible Range Coordinates Alt + Shift + V
Cycle Through Controls in Dialog Box Tab
Tab Backwards Shift + Tab
List Cells With Comments Ctrl + Shift + ‘ (apostrophe)
Row Second Cell From Left Alt + Ctrl + 2
Row First Cell From Left Alt + Ctrl + 1
Row Third Cell From Left Alt + Ctrl + 3
Row Fourth Cell From Left Alt + Ctrl + 4
Describe Cell Border Alt + Shift + B
Read Cell Comment Alt + Shift + ‘ (apostrophe)
Auto Filter Ctrl + Shift + A
Read Cell Hyperlink Alt + Shift + H
Close Office Assistant Ctrl + Insert + F4
Set Monitor Cell One Alt + Ctrl + Shift + 1
Set Monitor Cell Two Alt + Ctrl + Shift + 2
Set Monitor Cell Three Alt + Ctrl + Shift + 3
Set Monitor Cell Four Alt + Ctrl + Shift + 4
Set Monitor Cell Five Alt + Ctrl + Shift + 5
Set Monitor Cell Six Alt + Ctrl + Shift + 6
Set Monitor Cell Seven Alt + Ctrl + Shift + 7
Set Monitor Cell Eight Alt + Ctrl + Shift + 8
Set Monitor Cell Nine Alt + Ctrl + Shift + 9
Set Monitor Cell 10 Alt + Ctrl + Shift + 0
Read Monitor Cell One Alt + Shift + 1
Read Monitor Cell Two Alt + Shift + 2
Read Monitor Cell Three Alt + Shift + 3
Read Monitor Cell Four Alt + Shift + 4
Read Monitor Cell Five Alt + Shift + 5
Read Monitor Cell Six Alt + Shift + 6
Read Monitor Cell Seven Alt + Shift + 7
Read Monitor Cell Eight Alt + Shift + 8
Read Monitor Cell Nine Alt + Shift + 9
Read Monitor Cell Ten Alt + Shift + 0
List Visible Cells With Data Ctrl + Shift + D
Lists Data In Current Column Ctrl + Shift + C
List Data In Current Row Ctrl + Shift + R
Select Hyperlink Ctrl + Shift + H
Move To Worksheet Listbox Ctrl + Shift + S
Move To Monitor Cell Ctrl + Shift + M
Select Worksheet Objects Ctrl + Shift + O
List Cells At Page Breaks Ctrl + Shift + B
Options Listbox Insert + V

Marema
Infosys Campus, Bangalore.

May be related

• Steffi’s new avatar
• SUPER Converter - Converts anything
• How to become yourself
• FTP Error Messages
• Convert file to pdf via email

Recent entries

• Pastor thihna chhui dan RTI hmangin
• Christmas at Aizawl
• Bhutto Killed in Attack
• Mustaine -The Real life Santa
• Mizoram BPL card neute zinga 83.66 percent in an phu lo
• Kan hnam hming “Mizo” leh kan “Chi” te hi
• 12 churches attacked in eastern India
• Mizoram hmun hrang hrang Christmas
• Dead man sends Christmas cards from ‘Heaven’!
• Sad news: “Mizo student met fatal accident in Pune”

This entry was posted on Tuesday, April 17th, 2007 at 8:28 am and is filed under Tech trek trek. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.