Select the whole column
Selection CTRL + SPACE
|
Select the whole row
Selection SHIFT + SPACE
|
Select table
Selection SHIFT + CTRL + SPACE bar
|
Save
Selection CTRL + s
|
Select visible cells only
Selection ALT + ;
|
Select entire region
Selection CTRL + A
|
Select range from start cell to far left
Selection SHIFT + Home
|
Select range from start cell to end in direction of arrow
Selection SHIFT + End + arrow
|
Select a continuous range of data (e.g. pivot), no matter where your cursor is.
Selection CTRL + *
|
Select blank cells
Selection F5 + ALT + S + K + ENTER
|
Select all cells with comments
Selection CTRL + SHIFT + O
|
Select all cells that are directly or indirectly referred to by formulas in the selection
Selection CTRL + SHIFT + {
|
Select all cells with formulas that refer directly or indirectly to the active cell
Selection CTRL + SHIFT + }
|
Selects all the way to a1 from cursor position
Selection CTRL + SHIT + HOME
|
Select cells in the direction of arrow
Selection CTRL + SHIFT + Arrow
|
Previous sheet
Navigation CTRL + Page Up
|
Next sheet
Navigation CTRL + Page Down
|
Launch GO TO Dialog (from here you can select special or jump to a cell or range)
Navigation F5
|
Go to top left (will go to top left of freezed pane if set)
Navigation CTRL + Home
|
Go to last non-blank cell
Navigation CTRL + end
|
Go to previous sheet
Navigation CTRL + PgUp
|
Go to next sheet
Navigation CTRL + PgDn
|
Print
Navigation CTRL + p
|
Toggle between workbooks in a given session of excel.
Navigation CTRL + TAB
|
Change the type of cell reference from relative to absolute or semi-absolute
Formulas F4
|
Repeat whatever you did last
Formulas F4
|
Debug portions of a formula (select and press)
Formulas F9
|
Sum range
Formulas ALT + =
|
Enter array formula
Formulas CTRL + SHIFT + Enter
|
Select array formula range
Formulas CTRL + /
|
Display range names (can be used when typing formulas)
Formulas F3
|
Evaluate formulas. (its easy to remember when working with some “tuf” formulas!)
Formulas ALT + TUF
|
Copy a formula from above cell and edit
Formulas CTRL + '
|
Display the formula palette after you type a valid function name in a formula
Formulas CTRL + A (while writing a formula)
|
Alternate between displaying cell values and displaying cell formulas
Formulas CTRL + ` (Single Left Quotation Mark)
|
Calculate formulas
Formulas F9
|
Select all precedent cells
Formulas CTRL + [
|
Select all dependent cells
Formulas CTRL + ]
|
Format Selection (cells, objects, charts)
Formatting CTRL + 1
|
Bold a cell’s content
Formatting CTRL + B
|
Format Painter – Paste formats from selection
Formatting ALT + EST
|
Format as number with 2 dp
Formatting CTRL + SHIFT + 1
|
Format as local currency
Formatting CTRL + SHIFT + 4
|
Format as percentage with 0 dp
Formatting CTRL + SHIFT + 5
|
Hide row
Formatting CTRL + 9
|
Hide column
Formatting CTRL + 0
|
Unhide row
Formatting CTRL + SHIFT + 9
|
Unhide column
Formatting CTRL + SHIFT + 0
|
Display the style command format menu
Formatting ALT + '
|
Sets/removes strikeout in current cell
Formatting CTRL + 5
|
Show/hide the top bar when you have a group
Formatting Crtl + 8
|
Single border around selected cells
Formatting CTRL + SHIFT + 7
|
Sort
Formatting ALT + DS
|
Insert hyperlink
Formatting CTRL + K
|
Freeze panes
Formatting ALT + WFF
|
Remove grid lines or (alt+t)ov(alt+g)[enter]
Formatting ALT + WVG (2007+)
|
To wrap lines
Formatting ALT + HW (2007+)
|
Save as
Excel Options F12
|
Collapse the ribbon (press again to expand)
Excel Options CTRL + F1
|
Opens print preview
Excel Options CTRL + F2
|
Maximize the current window
Excel Options ALT + SPACE X
|
Activate next window
Excel Options ALT + TAB
|
Activate previous window
Excel Options ALT + SHIFT + TAB
|
Close an excel workbook
Excel Options crtl + F4
|
Split screens
Excel Options ALT + W + S
|
Create a pivot table in new sheet (of course after selecting the range)
Everything Else ALT + DPF
|
Create a pivot table in the same sheet.
Everything Else ALT + DPN
|
Show visual basic editor
Everything Else ALT + F11
|
Macro dialog
Everything Else ALT + F8
|
Apply/remove filter
Everything Else ALT + DFF
|
Keep filter on columns, but show all rows
Everything Else ALT + DFS
|
Insert pivot table
Everything Else ALT + NVT
|
Turn filter on or off
Everything Else CTRL + SHIFT + L
|
Paste values only
Editing ALT + ESV
|
Edit a cell, place cursor at the end
Editing F2
|
Show in-cell drop down with previously entered values
Editing ALT + Down arrow
|
Fills down value from cell above
Editing CTRL + D
|
Add a comment or Edit comment
Editing SHIFT + F2
|
Insert new sheet
Editing SHIFT + F11
|
Insert row
Editing CTRL + +
|
Delete row
Editing CTRL + -
|
Copy
Editing CTRL + C
|
Paste
Editing CTRL + V
|
Cut
Editing CTRL + X
|
Undo
Editing CTRL + Z
|
Get a line break inside the cell
Editing ALT + Enter (while editing the cell)
|
Clear all contents
Editing ALT + EAA
|
Copy
Editing CTRL + insert
|
Paste
Editing SHIFT + Insert
|
Make chart/pivot chart
Editing F11
|
Edit a cell in Apple Macs
Editing CTRL + U
|
Copy the value from the cell above the active cell into the cell or the formula bar
Editing CTRL + SHIFT + "
|
Copies whatever is in the cell to the left of it.
Editing CTRL + R
|
Delete box (cell, row, column)
Editing ALT + ED
|
Insert box (cell, row, column)
Editing ALT + IE
|
Enter current date
Auto Complete CTRL + ;
|
Enter current time
Auto Complete CTRL + :
Resource Chandoo.org |
Bisa juga pilih negara yang lain
kalau pakai country indonesia biasanya yang port 80 atau 8080 yang bisa digunakan tapi kadang yang lain juga bisa, pilih saja mana yang bisa di gunakan
