Overview of the interface in Excel 2013, 2016
The following article will help you understand the overview of the interface in Excel 2013 and 2016.
When Excel opens the interface works as shown:
1. The title bar
- The Excel icon contains the command: Restore, Move, Size, Minimize, Maximize, Close.
- Save icon
allows you to quickly save the spreadsheet.- Undo, Redo buttons
allow you to go back or move to the next worksheet.- The Customize Quick Access Toolbar contains frequently used commands:
- Next is the Excel file name, here the Excel file is named Book1.
- Finally, in the right corner of the title bar is Excel Help, Ribbon Layout, Minimize, Maximize the window and close the Excel workbook window:
2. The Ribbon
- Contains groups of command cards, with an intuitive interface that helps you easily work with spreadsheets:
- The ribbon contains the command tags: Home, Insert, PageLayout, Formulas, Data, Review, View, Developer.
- Each command card contains groups of commands, for example, the Home tab contains a group of commands: Clipbpard, Font, Alignment, Number, Styles, Cells, Editing.
- For details of the command groups, click the arrow icon -> commands in the group are displayed:
3. Formula Bar.
- Contains the name of the data range, data entry .
4. Input area:
- Contains columns (columns) and rows (row) in which the column is numbered alphabetically, the line numbered by number. The intersection of columns and rows is called cells or cells . The input at the position of the cells.
5. Sheet tab.
- This is the area containing the sheet names created in Excel file and contains the command button to quickly create a new sheet.
In addition, Excel 2013 supports adding quick action buttons for spreadsheets:
- Bring the worksheet to the default mode Normal, PageLayout, Page Break Review, Zoom out, Zoom In respectively as shown:
Above is an overview of the interface of Excel 2013, 2016.
Good luck!
You should read it
- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
- Get familiar with Acccess 2016 interface and basic operations
- How to fix column and header rows in Excel 2007, 2010, 2013, 2016
- Instructions for installing and using Office 2016
- Guide to familiarize yourself with Excel
- How to merge cells in Excel - Instructions to merge cells in Excel 2010, 2013, 2016
- Guide to full Excel 2016 (Part 2): Learn about OneDrive
- Complete guide to Excel 2016 (Part 1): Get familiar with Microsoft Excel
- Complete guide to Excel 2016 (Part 10): Use the Find and Replace function
- How to wrap text in Excel 2007, 2010, 2013, 2016
- Complete guide to Excel 2016 (Part 9): Working with multiple spreadsheets
- Complete guide to Excel 2016 (Part 13): Introduction to formulas
Maybe you are interested
Difference between function and formula in Excel
8 little-known Excel functions that can save you a lot of work
How to use pictures as Excel chart columns
6 ways to fix arrow keys not working in Excel
Fix the error of not being able to use the F4 key in Excel with shortcut keys
How to split sheet into multiple separate Excel files