Microsoft Excel 2013 is a spreadsheet program developed by Microsoft Excel which enhances your ability to analyse large amounts of data. Excel offers powerful filtering, sorting and search tools by using which you can analyse your data quickly and easily. Excel is an amazing software for the use in Business due to its analysing capability which is highly useful in making business decisions.

Microsoft Office 2013 displays commands in a series of icons stored on different tabs. This combination of icons and tabs is known as the Ribbon which appears in Word, PowerPoint, Excel, Outlook, and Access. A Ribbon an interface which combines the menu bar and toolbar into a single floating pane.Excel 2013 uses a tabbed Ribbon system instead of traditional menus.

The purpose of the ribbon is to provide quick access to commonly used tasks within each program. Therefore, the ribbon is customised for each application and contains commands specific to the program. Since the ribbon contains both the program’s menu options and toolbar commands, it cannot be removed from the screen. However, it can be minimized to free up more screen real estate for the primary document window. To minimize the ribbon, you can either click the upside down eject icon at the top of the ribbon or use the keyboard shortcut Control+F1. Once the ribbon has been minimized, it can be restored by clicking the same icon or using the same keyboard shortcut.

In this article, let us see which are the Commands grouped under Ribbon Tab for Microsoft Excel 2013.

The following tables show the commands grouped under Microsoft Excel 2013 Ribbon Tab

 

Ribbon Tab Name Command Groups
Home Clipboard, Font, Alignment, Number, Styles, Cells, and Editing
Insert Tables, Illustrations, Apps, Charts, Reports, Sparklines, Filter, Links, Text, and Symbols
Page Layout Themes, Page Setup, Scale to Fit, Sheet Options, and Arrange
Formulas Function Library, Defined Names, Formula Auditing, and Calculation
Data Get External Data, Connections, Sort & Filter, Data Tools, and Outline
Review Proofing, Language, Comments, and Changes
View Workbook Views, Show, Zoom, Window, and Macros

 

1.Home tab:This tab contains commands for common actions such as formatting, copying, pasting, inserting, and deleting columns and rows. The Home tab is selected by default whenever you open Excel. The Home Tab contains groups namely Clipboard, Font, Alignment, Number, Styles, Cells, Editing.

2.Insert tab: This tab contains commands that enable you to insert objects such as charts and shapes into your spreadsheets. The Insert Tab consists of groups like Tables, Illustrations, Add-ins, Charts, Sparklines, Filters, Links, text and Symbols.

 

3.Page Layout tab: This tab holds all the commands that enable you to determine how your spreadsheet looks, both onscreen and when printed. These commands control options such as theme colors, page margins, and print area. The Page Layout tab consists of groups like Themes, Page Setup, Scale to Fit, Sheet Options and Arrange.

 

4.Formulas tab: This tab holds all the commands that help define, control, and audit Excel formulas. The Formula Tab contains groups like Function Library, Defined names, Formula Auditing and Calculation.

 

5.Data tab: This tab features commands that enable you to connect to external data, as well as manage the data in your spreadsheet. The Data Tab contains groups like Get external data, Connections, Sort & Filter, Data Tools and Outline.

 

6.Review tab:With commands such as Spell Check, Protect Sheet, Protect Workbook, and Track Changes, the theme of the Review tab is protecting data integrity in your spreadsheet. The Review Tab consists of Groups like Proofing, Language, Comments, and Changes etc.

 

7.View Tab: The commands on this tab are designed to help you control how you visually interact with your spreadsheet. View tab helps to change the view of Excel sheet and make it easy to view the data. Also, this tab is useful for preparing the workbook for printing. The View Tab has groups like Workbook Views, Show, Zoom, Window and Macros.

 

8.File tab: File Tab exposes Backstage view, where you find commands to help you open existing Excel workbooks, create new workbooks, save workbooks, apply protection. This Tab contains the basic required options such as New, Open, Save, Save As, Print, Share, Export, Close, Account, Options etc.

About the author

FAME is a leading Accountancy training provider. FAME brings together under one roof a wide range of accounting courses blended with real world experience and practical application. FAME aims to bridge the gap between theoretical knowledge and practical challenges that accountants face in their day to day working. We provide practical workplace skills for finance staff meeting the needs of employers, bankers, government and learners, both now and in the future. Our students are integral to the success of an organisation and at the heart of ensuring the smooth running of an accounting department.