Interface

Learn Excel Window Parts Title Bar | Quick Access Toolbar | Tabs | Ribbon | Name Box | Column Headings | Sheet Tabs Welcome to our free “Excel Basics” course. In the first lesson, we are going to explore the most frequently used window parts of Microsoft Excel. Knowing these parts by their names will […]

How to insert checkbox in Excel Link a Checkbox | Create a To-Do List The checkbox in Excel is very useful to create a checklist. In this lesson, we are going to discuss how to insert checkbox, link a checkbox, and create a checklist. Insert a Checkbox 1. On your excel Developer tab, click “Insert.”

Using Excel Status Bar Customize Status Bar The Excel status bar locates at the bottom of the Excel window and it displays quite useful information. Status bar displaying statistics The status bar can display the average, count, and sum when you select a range of cells. 1. Select the cell range C3:C8. 2. Take a

Turn on Excel Developer Tab The Developer tab in Excel is used to create a macro or insert controls. You can add the Developer tab by following the steps below. 1. Right-click anywhere on the Ribbon and then click “Customize the Ribbon.” 2. Under Customize the Ribbon, make sure that “Main Tabs” is selected. 3.

Customize Ribbon in Excel If you like to customize Ribbon in Excel by creating your own tab and adding commands to it, follow the steps below. 1. Right-click anywhere on the ribbon and then click “Customize the Ribbon.” 2. Click New Tab. 3. You can rename the “New Tab” by right-clicking on it and then

Customize Excel Quick Access Toolbar Command Not in Ribbon By default, Excel shows 3 or 4 commands: Save, Undo, and Redo. If you think you are using a command frequently, you can add that command to the quick access toolbar to save your time. Adding command from Ribbon 1. Right-click on a command that you

Excel Ribbon Groups| Using Ribbon | Collapse Ribbon At the start, Excel automatically selects the Home tab of the ribbon for you. Let’s learn more about Ribbon. Tabs Generally speaking, the tabs on the ribbon are File, Home, Insert, Page Layout, Formulas, Data, Review, View, and Help. However, additional tabs may appear when you add