In this article you will know the basic controls and parts of the Excel Window that will be very helpful in working with next your projects.

But first you should take note that the two versions of Excel are almost identical, only the Office button is replaced with the File Tab.


Here are the the use of every part of the Excel window:

Quick Access Toolbar – Collection of buttons that provide one click access to commonly used commands such as Save, Undo or Redo. You can also customize this according to your preference.

Title Bar – A bar the display the name of active workbook

Ribbon – The main set of commands and controls organized task in Tabs and groups, you can also customize the ribbon according to your preference.

Column Headings – The letters that appear along the top of the worksheet to identify the different columns in the worksheet.

Worksheet Window – A window that displays an Excel worksheet, basically this is where you work all the tasks.

Vertical Scroll Bar – Scroll bar to use when you want to scroll vertically through the worksheet window.


Horizontal Scroll Bar – Scroll bar to use when you want to scroll horizontally through the worksheet window.

Zoom Controls – Used for magnifying and shrinking of the active worksheet.

View Shortcuts  – Buttons used to change how the worksheet content is displayed. Normal, Page Layout or Page Break Preview.

Sheet Tabs – Tabs the display the name of the worksheet in the workbook, by default its name sheet 1, sheet 2, etc. You can rename this to any name the best represent to your sheet.

Sheet Tab Scrolling Buttons – Buttons to scroll the sheet tabs in the workbook

Row Headings – The number that appears on the left of the worksheet window to identify the different rows.

Select All Button – A button that selects all the cells in the active worksheet

Active Cell  – The cell selected in the active worksheet

Name Box – A box that displays the cell reference of the active cell

Formula Bar – A bar that displays the value or formula entered in the active cell

Office Button/File Tab – It provides access to workbook level features and program settings. You will notice that in Excel 2007  there is a circle Office button while on the Excel 2010 it replace with File Tab. If you click the circle office button you will see this.


To all the readers of this website, please read carefully and understand this disclaimer before you use or implement all the contents found here. Some of the posts are risky to use if you are a beginner.

All the post and contents of this website is for public information only, however we cannot guarantee the accuracy, completeness, or the assurance that will work for you if you implement some of the tutorials posted on this website. We are working to the best of our skills to make this website updated and working, but due to the fact that every seconds there some updates taking place on the World Wide Web it’s out of our control if some of the contents here will not work. Read More....

Related Articles