د موضوعګانو سرپاڼه

تخنیک ، خبرتیایي تکنالوژي او کمپیوتري‌ مرستې

د ايکسل پروګرام شارټ کټز

naimtullah
13.11.2010

محترمو دوستانو پدې هېله چې به روغ او جوړ ياست!

ايکسل پروګرام يو ډير مفيد او استعمال کيدونکى پروګرام دى، او پدې پروګرام کې مو چې خومر شارکټز زيات زده وي هومره به پرې تيز کار کوو پدې خاطر غواړم تاسو ته د ايکسل شارټ کټز په ليکه کړم.
Short Key Function
Ctrl+
Move to first cell of Row
Ctrl+
Move to last cell of Row
Ctrl+
Move to first cell of column
Ctrl+
Move to last cell of column
Ctrl+Home key Move to first cell of Sheet
Ctrl+= Insert auto sum
F5 Display the “Go To” dialogue box
Esc Cancel a cell entry
Ctrl+; Enter Data
Ctrl+Shift+: Enter Time
Ctrl+Page Down Move One screen to the right

Ctrl+Page Up Move One screen to the lift

Ctrl+1 Display the “format cell” dialogue Box
Ctrl+Shift+& Apply the outline border
Ctrl+Shift+- Remove the outline border
Ctrl+5 Apply or remove strick through formatting
Ctrl+9 Hide row
Ctrl+Shift+( Unhide row
Ctrl+0 Hide column
Ctrl+Shift+) Unhide column
Ctrl+Space bar Select the entry column
Shift + Space bar Select the entry row
Shift + F11 Insert a new worksheet
Alt+Shift+F1 Insert a new worksheet
Ctrl+Plus Insert a column or row in a worksheet
Ctrl+- Remove a column or row in a worksheet

Ctrl+Page Down Move to a next sheet in a workbook
Ctrl+Page Up Move to previous sheet in a workbook
Page Down Move down one screen
Page Up Move up one screen
Ctrl+D Fill down
Ctrl+R Fill right
F2 Edit a active cell
Ctrl+Tab Move another open workbook


OK
This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies. Find out more