Hello Sunil
A Dummies Guide to Excel for Beginners - Part -1

A Dummies Guide to Excel for Beginners – (Part -1)📊

Step 1: Click the drop-down arrow to the right of the Quick Access Toolbar.

Step 2: Select the command you want to add from the drop-down menu. To choose from more commands, select More Commands.

Excel for Beginners - Customize quick access toolbar-1

Step 3: Under Choose commands from, select Commands Not in the Ribbon. As an example, select Form and click Add.

Excel for Beginners - Customize quick access toolbar-2

💡 Note

By default, Excel customizes the Quick Access Toolbar for all documents. Under Customize Quick Access Toolbar, select the current saved workbook to only customize the Quick Access Toolbar for this workbook.

Step 4: Click OK. Also, to remove a command from the Quick Access Toolbar, right click the command and click Remove from Quick Access Toolbar.

How to manage your worksheets in Excel

As we mentioned, workbooks can contain multiple sheets. You can manage those sheets with the sheet tabs near the bottom of the screen. Click a tab to open that particular worksheet.

Excel for Beginners - Manage your worksheets in Excel - img 1

To add a new worksheet, click the + (plus) button at the end of the list of sheets.

Excel for Beginners - Manage your worksheets in Excel - img 2

You can also reorder the sheets in your workbook by dragging them to a new location. And if you right-click a worksheet tab, you will get a number of options:

Excel for Beginners - Manage your worksheets in Excel - img 3

For now, don’t worry too much about these options. Rename and Delete are useful. Rename allows you to rename your worksheet whereas Delete will delete your worksheet.

Microsoft Excel worksheet views

Excel has a variety of viewing options that change how your workbook is displayed. These views can be useful for various tasks, especially if you are planning to print the spreadsheet.

To change worksheet views, locate the commands in the bottom-right corner of the Excel window and select Normal view, Page Layout view, or Page Break view.

Excel for Beginners - Excel worksheet views - img 1

Normal view is the default view for all worksheets in Excel. Here is how it looks:

In the case of Page Layout view it displays how your worksheets will appear when printed. You can also add headers and footers in this view.

Excel for Beginners - Excel worksheet views - img 3

Finally, Page Break view allows you to change the location of page breaks, which is especially helpful when printing a lot of data from Excel.

Excel for Beginners - Excel worksheet views - img 4

Microsoft Excel backstage view

Excel Backstage view gives you various options for saving, opening a file, printing, and sharing your workbooks.

You can access Backstage view by clicking on File tab on the Ribbon and here is how it looks:

Excel for Beginners - Excel backstage view - img 1

Description of each options are as follows:

Arrow button: You can use the arrow to close Backstage view and return to Excel.

New: This option allows you to create a new blank workbook or choose from a large selection of templates.

Sunil Pradhan

Hi there 👋 I am a front-end developer passionate about cutting-edge, semantic, pixel-perfect design. Writing helps me to understand things better.

Add comment

Stay Updated

Want to be notified when our article is published? Enter your email address below to be the first to know.

Sunil Pradhan

Hi there 👋 I am a front-end developer passionate about cutting-edge, semantic, pixel-perfect design. Writing helps me to understand things better.