Sedikit Info Seputar
Excel shortcut and function keys for Professionals.
Terbaru 2017
- Hay gaes kali ini team Just Sharing Info, kali ini akan membahas artikel dengan judul Excel shortcut and function keys for Professionals., kami selaku Team Just Sharing Info telah mempersiapkan artikel ini untuk sobat sobat yang menyukai Just Sharing Info. semoga isi postingan tentang
Artikel Crazy Minders,
Artikel database,
Artikel excel,
Artikel Excel Shortcut,
Artikel Tech Diary, yang saya posting kali ini dapat dipahami dengan mudah serta memberi manfa'at bagi kalian semua, walaupun tidak sempurna setidaknya artikel kami memberi sedikit informasi kepada kalian semua. ok langsung simak aja sob
Judul:
Berbagi Info Seputar
Excel shortcut and function keys for Professionals.
Terbaru
link: Excel shortcut and function keys for Professionals.
Berbagi Excel shortcut and function keys for Professionals. Terbaru dan Terlengkap 2017
The following lists contain CTRL combination Excel shortcut and function keys , function keys, and some other common shortcut keys, along with descriptions of their functionality.TIP To keep this reference available when you work, you may want to print this topic. To print this topic, press CTRL+P.
NOTE If an action that you use often does not have a shortcut key, you can record a macro to create one.
Work with databases, lists, and PivotTables by using shortcut keys | |
| Work in a data form by using shortcut keys | |
| To | Press |
| Select a field or a command button | ALT+ key, where key is the underlined letter in the field or command name |
| Move to the same field in the next record | DOWN ARROW |
| Move to the same field in the previous record | UP ARROW |
| Move to the next field you can edit in the record | TAB |
| Move to the previous field you can edit in the record | SHIFT+TAB |
| Move to the first field in the next record | ENTER |
| Move to the first field in the previous record | SHIFT+ENTER |
| Move to the same field 10 records forward | PAGE DOWN |
| Move to the same field 10 records back | PAGE UP |
| Move to the new record | CTRL+PAGE DOWN |
| Move to the first record | CTRL+PAGE UP |
| Move to the beginning or end of a field | HOME or END |
| Move one character left or right within a field | LEFT ARROW or RIGHT ARROW |
| Extend a selection to the beginning of a field | SHIFT+HOME |
| Extend a selection to the end of a field | SHIFT+END |
| Select the character to the left | SHIFT+LEFT ARROW |
| Select the character to the right | SHIFT+RIGHT ARROW |
| Work with the AutoFilter feature by using shortcut keys | |
| To | Press |
| Display the AutoFilter list for the current column | Select the cell that contains the column label, and then press ALT+DOWN ARROW |
| Close the AutoFilter list for the current column | ALT+UP ARROW |
| Select the next item in the AutoFilter list | DOWN ARROW |
| Select the previous item in the AutoFilter list | UP ARROW |
| Select the first item (All) in the AutoFilter list | HOME |
| Select the last item in the AutoFilter list | END |
| Filter the list by using the selected item in the AutoFilter list | ENTER |
| Work with the PivotTable Wizard by using shortcut keys | |
| In Step 3 of the PivotTable Wizard, to | Press |
| Select the next or previous field button in the list | UP ARROW or DOWN ARROW |
| Select the field button to the right or left in a multicolumn field button list | LEFT ARROW or RIGHT ARROW |
| Move the selected field into the Page area | ALT+P |
| Move the selected field into the Row area | ALT+R |
| Move the selected field into the Column area | ALT+C |
| Move the selected field into the Data area | ALT+D |
| Display the PivotTable Field dialog box | ALT+L |
| Work with page fields in a PivotTable by using shortcut keys | |
| To | Press |
| Select the previous item in the list | UP ARROW |
| Select the next item in the list | DOWN ARROW |
| Select the first visible item in the list | HOME |
| Select the last visible item in the list | END |
| Display the selected item | ENTER |
| Group and ungroup PivotTable items by using shortcut keys | |
| To | Press |
| Group selected PivotTable items | ALT+SHIFT+RIGHT ARROW |
| Ungroup selected PivotTable items | ALT+SHIFT+LEFT ARROW |
| Print and preview a document by using shortcut keys | |
| To | Press |
| Display the Print command (File menu) | CTRL+P |
| Work in print preview | |
| To | Press |
| Move around the page when zoomed in | Arrow keys |
| Move by one page when zoomed out | PAGE UP or PAGE DOWN |
| Move to the first page when zoomed out | CTRL+UP ARROW or CTRL+LEFT ARROW |
| Move to the last page when zoomed out | CTRL+DOWN ARROW or CTRL+RIGHT ARROW |
| Outline data by using shortcut keys | |
| To | Press |
| Ungroup rows or columns | ALT+SHIFT+LEFT ARROW |
| Group rows or columns | ALT+SHIFT+RIGHT ARROW |
| Display or hide outline symbols | CTRL+8 |
| Hide selected rows | CTRL+9 |
| Unhide selected rows | CTRL+SHIFT+( |
| Hide selected columns | CTRL+0 (ZERO) |
| Unhide selected columns | CTRL+SHIFT+) |
| Keys for menus | |
| To | Press |
| Show a shortcut menu | SHIFT+F10 |
| Make the menu bar active | F10 or ALT |
| Show the program icon menu (on the program title bar) | ALT+SPACEBAR |
| Select the next or previous command on the menu or submenu | DOWN ARROW or UP ARROW (with the menu or submenu displayed) |
| Select the menu to the left or right, or, with a submenu visible, switch between the main menu and the submenu | LEFT ARROW or RIGHT ARROW |
| Select the first or last command on the menu or submenu | HOME or END |
| Close the visible menu and submenu at the same time | ALT |
| Close the visible menu, or, with a submenu visible, close the submenu only | ESC |
| Tip You can select any menu command on the menu bar or on a visible toolbar with the keyboard. Press ALT to select the menu bar. (To then select a toolbar, press CTRL+TAB; repeat until the toolbar you want is selected.) Press the letter that is underlined in the menu name that contains the command you want. In the menu that appears, press the letter underlined in the command name that you want. | |
| Keys for toolbars | |
| On a toolbar, to | Press |
| Make the menu bar active | F10 or ALT |
| Select the next or previous toolbar | CTRL+TAB or CTRL+SHIFT+TAB |
| Select the next or previous button or menu on the toolbar | TAB or SHIFT+TAB (when a toolbar is active) |
| Open the selected menu | ENTER |
| Perform the action assigned to the selected button | ENTER |
| Enter text in the selected text box | ENTER |
| Select an option from a drop-down list box or from a drop-down menu on a button | Arrow keys to move through options in the list or menu; ENTER to select the option you want (when a drop-down list box is selected) |
| Keys for using the Office Assistant | |
| To | Press |
| Make the Office Assistant the active balloon | ALT+F6; repeat until the balloon is active |
| Select a Help topic from the topics displayed by the Office Assistant | ALT+topic number (where 1 is the first topic, 2 is the second, and so on) |
| See more help topics | ALT+DOWN ARROW |
| See previous help topics | ALT+UP ARROW |
| Close an Office Assistant message | ESC |
| Get Help from the Office Assistant | F1 |
| Display the next tip | ALT+N |
| Display the previous tip | ALT+B |
| Close tips | ESC |
| Show or hide the Office Assistant in a wizard | TAB to select the Office Assistant button; SPACEBAR to show or hide the Assistant |
Itulah sedikit Artikel Excel shortcut and function keys for Professionals. terbaru dari kami
Semoga artikel Excel shortcut and function keys for Professionals. yang saya posting kali ini, bisa memberi informasi untuk anda semua yang menyukai Just Sharing Info. jangan lupa baca juga artikel-artikel lain dari kami.
Terima kasih Anda baru saja membaca Excel shortcut and function keys for Professionals.
