Excel Window

Contents:
Excel file tab | quick access toolbar | title bar | excel ribbon | Row / Column Bar | status bar | View Buttons | zoom | help

When you start the excel application, Excel window will appear and this section will let you learn the various important parts of excel window.

excel window

Now let’s see how to understand the various parts of excel one by one:

File Tab

When you want to create a new workbook, open one existing workbook, save current workbook, print a workbook , close current workbook, get current excel file information (such as: size, Title, tags, Categories, Related Dates, Related People)o or others file-related operations.

excel window file tab

Quick Access Toolbar

This Toolbar will contain the most frequently used command. Of course, you can add new commands to Quick Access Toolbar.

By default, the Quick Access Toolbar just contains three button: SAVE, Undo Typing and Redo typing. Now we will talk how to add a command to the Quick Access Toolbar.

excel window quick access toolbar

Title Bar

The Title bar will show the current excel workbook titles.

Excel Ribbon

The excel ribbon is the most important area in MS/Microsoft Excel.  The following tabs are shown on the ribbon by default: File, Home, Insert, Page, Layout, Formulas, Data, Review .

There are different Groups and commands in each Tab. Such as:  the Home tab contains “Clipboard”, “Font”, “Alignment”, “Number”,  “Styles”, “Cells”, “Editing” groups.

excel window ribbon

Row / Column Bar

x
How to Remove Line Breaks Carriage Returns in Excel

Excel Row Bar are numbered with a numeric value and row number start from 1 to 1048576 Excel Column Bar are numbered with alphabetic values and column ranges from A to XFD.

Microsoft Office Excel 2007, 2010 and 2013 worksheets contains a maximum of 1,048,576 rows and 16,384 columns.

Status Bar

Excel status bar displays worksheet information that are selected, such as: Cell Mode(Ready, Enter, Edit, point), Permission, Caps Lock, Num Lock, Scroll Lock, Page Number, Sum and so on.

You can customize the status bar, just right-click it, then click the options that you want to display.

excel status bar

Worksheet Area

The worksheet area is used to enter data, you can select one cell or range to enter your data.

View Buttons

The View buttons contains three buttons: Normal, Page Layout, Page Break view.

  • Normal:  the worksheet is displayed in normal view by default.
  • Page Layout:  It will give you a full screen look of work sheet when it is printed. You can add page headers and footers for printing.
  • Page Break view: this view give you a preview of where pages will break when you print it.  Of course, you can adjust page breaks, such as: insert, move, or delete page breaks in a worksheet.

Zoom

You can control page view size through clicking “+“  or“-” buttons to zoom in and out.

Help

You can click the “?” button on the right-upper of excel window or press “F1”to open “Excel Help” dialog box.  There are lots of nice how-to excel articles and tutorials, so you can learn more from “Excel help”.

excel help window

 

Related Posts

How To Sum the Largest N Values in Excel

Sometimes we may want to sum the largest N numbers or top N numbers in a range. In this article, we will show you the method of “SUM the Largest N Numbers” by a simple formula which consist of SUMPRODUCT ...

How to Sum the Smallest N Values in Excel
How to Sum the Smallest N Values in Excel 15

Sometimes we may want to sum the first smallest N numbers in a range in Excel. In this article, we will show you the method of “SUM the Smallest N Numbers” by a simple formula which consist of SUMPRODUCT and ...

How to Auto Fill Weekdays or Weekends in Excel

Sometimes we may want to enter a sequence of days in excel for some purpose, and we can press Ctrl+; to insert current date into cell, and then drag the cell down to attach following days into other cells, then ...

How to Create Dynamical Drop-Down List and Sort by Alphabetical Order in Excel
How to Create Dynamical Drop-Down List 14

In our daily work we may need to create a dynamical dropdown list and sort all values by alphabetical order. To create a dropdown list like this, we need to apply some built-in features like ‘Define Name’ and ‘Data Validation’ ...

How to Highlight Every Other Row or Every Nth Row in Excel?
How to Highlight Every Other Row or Every Nth Row in Excel 11

Sometimes we may want to highlight every other row or every Nth row in a spreadsheet to make data in different rows looks more clearly. Though we can apply table styles to highlight table rows automatically, we can also highlight ...

How to Count Duplicate Values Only Once in A Range in Excel?
How to Count Duplicate Values Only Once in A Range in Excel5

When counting the number of times for objects appear in a list or a range, we usually record the duplicate value only once and ignore the redundant ones. We cannot apply formula with only one function to implement this in ...

How to Create Dynamic Drop Down List without Blank in Excel
create dynamic drop down list with blank5

This post will guide you how to create dynamic drop down list without blank cells in Microsoft Excel. In Excel, and you can use Data Validation feature to improve the efficiency of data entry in excel, and it also be ...

How to Stack Data from Multiple Columns into One Column in Excel
Stack Data 12

In previous article, I have shown you the method to split data from one long column to multiple columns by VBA and Index function. This time if we want to stack data from multiple columns to one column, how can ...

How to Count Only Unique Values Excluding Duplicates in Excel
Count Only Unique Values Excluding Duplicates 6

We enter a list of numbers or products and there are some duplicates in the list, if we want to just do count for the unique values and exclude the duplicates, how can we do? Now you can follow the ...

How To Transpose Every N Rows of Data into Muliptle Columns in Excel
How to Transpose every N rows from one column to multiple2

This post will guide you how to transpose data from rows to column with a formula in Excel. How do I transpose every N rows from one column to multiple columns in Excel. Assuming that you have a list of ...

Sidebar