- Learn about the key components of the Excel interface
- Excel 2013 screen elements
- Active cell
- Add a leaf icon
- column letters
- Formula bar
- Name field
- Quick Access Toolbar
- Ribbons Tabs
- File tab
- Line numbers
- sheet tabs
- status bar
- Zoom slider
- Early versions of Excel
Learn about the key components of the Excel interface
If you’re relatively new to using Excel 2013 for spreadsheets, you may not know the purpose of everything on the screen. You’ll probably find easier or more efficient ways to work with spreadsheets once you learn about the interface and its tricks. Here is a brief overview of the components of Excel 2013.
Excel 2013 screen elements
The Excel screen is filled with possibilities. Once you know what each section is for, you can quickly create professional spreadsheets.
active cell recognizable by the green outline. Data is always entered in the active cell. Different cells can be made active by clicking on them with the mouse or by using the arrow keys on the keyboard.
Add a leaf icon
on . to press Add Leaf Icon Near sheet tab at the bottom of the screen, add another sheet. (You can also use two keyboard shortcuts to add a new sheet: Shift+F11 and Alt+Shift+F1 )
cells – These are right-angled rectangles located in the central part of the sheet. Here are some important things to know about cells:
Data entered into a table is stored in a cell. Each cell can only hold one piece of data at a time.
A cell is the intersection of a vertical column and a horizontal row.
Each cell on a worksheet can be identified by a cell reference, which is a combination of letters and numbers, such as A1, F456, or AA34.
columns on the sheet are arranged vertically and each of them is indicated by a letter in column header .
Above the worksheet, this area displays the contents of the active cell. Formula bar can also be used to enter or edit data and formulas.
Next to the formula bar, name field a cell reference is displayed, or name active cell.
Quick Access Toolbar
Quick Access Toolbar allows you to add frequently used commands – click the down arrow at the end of the toolbar to display the available options.
ribbon is a strip of buttons and icons above the worksheet. When pressed, these buttons and icons activate various program functions. The ribbon was first introduced in Excel 2007 and has replaced the menus and toolbars in Excel 2003 and earlier.
Ribbon tabs are part of the horizontal ribbon menu, which contains links to various program functions. Any tab, for example House , page layout and formulas contains a number of related functions and options that are activated by clicking on its icon.
File tab was introduced in Excel 2010, replacing the Office 2007 button in Excel, and it works differently from other tabs. Instead of displaying the options in a horizontal ribbon, clicking the File tab opens a drop-down menu on the left side of the screen.
This tab contains items primarily related to file and document management, such as opening new or existing spreadsheet files, saving, and printing.
The “Options” item, which is also in the menu, is used to change the appearance of the program as a whole by selecting the display elements of the screen, such as scroll bars and gridlines; it also includes options to activate a number of settings, including automatic recalculation of sheet files and selection of languages for spelling and grammar checking.
strings are placed horizontally on the sheet and are identified by a number in the row header.
An Excel 2013 file has one worksheet by default, but you can add more worksheets. On the tab Sheet at the bottom of the sheet is the name of the sheet, such as Sheet1 or Sheet2.
Renaming a sheet or changing the color of a tab can make it easier to keep track of data in large spreadsheet files.
Switching between sheets can be done by clicking on the tab of the sheet you want to open (you can also switch between sheets using the keyboard shortcut to switch between sheets: Ctrl+PgUp and Ctrl+PgDn )
status bar located horizontally along the bottom of the screen, it can be configured to display a number of options, most of which provide the user with information about the current worksheet, the data in the worksheet, and the user’s keyboard.
The information includes information about whether the keys are enabled or disabled. Caps Lock , scroll lock and N uhm lock .
The status bar also includes a slider Scale that allows users to change the sheet magnification.
Located in the lower right corner of the Excel screen, zoom slider used to change the magnification of the sheet while dragging slider back or forward or by pressing the buttons Reduce and increase at both ends of the slider.
Early versions of Excel
If you’re not using Excel 2013, one of these articles may provide the information you need to get to grips with your version’s interface:
Parts of an Excel 2010 screen
Parts of an Excel 2007 screen