Enable the Developer tab. To use the form controls in Excel 2010 and later versions, you have to enable the Developer tab. To do this, follow these steps: Click File, and then click Options. Click Customize Ribbon in the left pane. Select the Developer check box under Main Tabs on the right, and then click OK. 1. Turn Filter / AutoFilter on. To turn Filter on using a keyboard shortcut, ensure a cell in the range is selected and then press Ctrl + Shift + L. If your data range contains any blank columns or rows, select the entire range of cells first. You can use the same shortcut to turn the Filter off. Not Microsoft style. The File menu’s Open command opens the file. Follow the user interface for capitalization and use bold formatting both in text and procedures. Do not capitalize the identifier, such as menu or command. Microsoft style. On the Options menu, click Keep Help on Top. Not Microsoft style. On the Options menu, click Keep Help Below are the steps. First, right-click on the ribbon and select the customize the ribbon option. Now, the Excel options dialog box appears. From there, you can add any tab by selecting the check-in box under the main tabs menu. In the end, click on Ok and this tab will appear on the ribbon. Program pengolah kata Microsoft Excel memiliki sembilan menu yang terdapat bar atau baris menu. Kesembilan menu itu : File, Edit, View, Insert, Format, Tools, Data, Window, dan Help. Masing-masing menu memiliki submenu perintah yang masing-masing sub perintah tersebut memiliki fungsi tersendiri yaitu antara lain : onglFKv.

menu menu microsoft excel