Kumpulan shortkey Pada Microsoft Excel

Jalan pintas merupakan hal yang paling disukai semua orang untuk mempercepat mencapai tujuannya. Tidak terkecuali dalam menggunakan software komputer. Untuk mempercepat pekerjaan dalam olah data, microsoft excel menyediakan beberapa shortkey. langsung saja berikut ada lah list shortkey yang ada pada microsoft Excel :

Kumpulan shortkey Pada Microsoft Excel

Kumpulan shortkey Pada Microsoft Excel

Shift + F1 What’s This?
Shift + F2  Insert Comment
Shift + F3  Insert Function dialog box
Shift + F4  Find Again
Shift + F5  Find dialog box
Shift + F6  Previous Pane
Shift + F8 Add to Selection
Shift + F9  Calculate Worksheet
Shift + F10 Right Click Menu
Shift + F11 New Worksheet
Shift + F12 Save
Shift + Spacebar Select Row

Shift held down while in Copy mode will enable you to select Paste Picture and Paste Picture Link from the Edit menu.

Keep the Shift key pushed down while expanding (contracting) Autoshapes to keep the same height:width ratio.

Alt + F4  Close Program (Excel)
Alt + F6  Switch between Visual Basic Editor/Workbook
Alt + F8  Macros dialog box
Alt + F11  Open Visual Basic Editor
Alt + D  Data Menu
Alt + E   Edit Menu
Alt + F   File Menu
Alt + I   Insert Menu
Alt + H  Help Menu
Alt + O  Format Menu
Alt + T   Tools Menu
Alt + W  Window Menu
Alt + ‘   Style dialog box
Alt + 9   Hide Rows (Thanks Peter!)
Alt + 0   Hide Columns (Thanks Peter!)
Alt + Page Up Go left one screen
Alt + Page Down Go right one screen
Alt + Tab  Next Program

Anda Harus Tahu   cara mengurutkan rangking siswa dengan excel

Keep the Alt key pushed down to position your shape against the sides of the nearest cell or cells, either while drawing normally or expanding using the handles on the shape’s sides.

Ctrl + F3  Define Name dialog box
Ctrl + F4  Close Workbook
Ctrl + F5  Restore Window
Ctrl + F6  Next Workbook
Ctrl + F7  Move Window
Ctrl + F8  Resize Window
Ctrl + F9  Minimize Window
Ctrl + F10  Restore Workbook
Ctrl + F11  New Macro Sheet
Ctrl + F12  Open dialog box
Ctrl + A  Select All
Ctrl + B  Bold Font
Ctrl + C  Copy Selection
Ctrl + D  Fill Down (Drag to Select)
Ctrl + F  Find dialog box
Ctrl + G  Goto dialog box
Ctrl + H  Replace (Find dialog box)
Ctrl + I   Italic Font
Ctrl + K  Insert Hyperlink dialog box
Ctrl + N  New Workbook
Ctrl + O  Open dialog box
Ctrl + P  Print
Ctrl + R  Fill Right (Drag to Select)
Ctrl + S  Save
Ctrl + U  Underline Font
Ctrl + V  Paste
Ctrl + W  Close Workbook
Ctrl + X  Cut Selection
Ctrl + Y  Do Again
Ctrl + Z  Undo
Ctrl + 1  Format Cells dialog box
Ctrl + 2  Bold Font
Ctrl + 3  Italic Font
Ctrl + 4  Underline Font
Ctrl + 5  Strikethrough Font
Ctrl + 8  Display Outline Symbols
Ctrl + 9  Hide Rows
Ctrl + 0  Hide Columns
Ctrl + –  Delete dialog box
Ctrl + [  Direct Dependents
Ctrl + ]  All Dependents
Ctrl + ;  Current Date
Ctrl + :  Current Time
Ctrl + Home Start of Worksheet
Ctrl + End  Final Cell
Ctrl + Page Up Previous Worksheet
Ctrl + Page Down Next Worksheet
Ctrl + Tab  Next Window

Anda Harus Tahu   Menggunakan Fungsi IF

Push Ctrl while drawing Autoshapes to expand outwards (good for placing circles in precise locations)
Ctrl + Spacebar Select Column

Ctrl + Mousewheel Zoom/Unzoom 15% increments
Ctrl + Enter  Simultaneous entry into a range of cells

Ctrl + Arrow keys will help you move to the next value, end of selection or end of Worksheet quickly. Use these keys with Shift to select a range quickly.

Shift + F1 What’s This?
Shift + F2  Insert Comment
Shift + F3  Insert Function dialog box
Shift + F4  Find Again
Shift + F5  Find dialog box
Shift + F6  Previous Pane
Shift + F8 Add to Selection
Shift + F9  Calculate Worksheet
Shift + F10 Right Click Menu
Shift + F11 New Worksheet
Shift + F12 Save
Shift + Spacebar Select Row

Shift held down while in Copy mode will enable you to select Paste Picture and Paste Picture Link from the Edit menu.

Keep the Shift key pushed down while expanding (contracting) Autoshapes to keep the same height:width ratio.

sumber: Andrew Engwirda Exceltips

Kumpulan shortkey Pada Excel

Kasih masukanmu di sini


Selamat Datang di Tukangteori.com

Tukang Teori logo besar 

Bantu kami membagikan Informasi dengan cara share dan like :)