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

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

Get Address of First Cell in Range

We will learn how to get address of first cell in range in this post. At Instance, we must determine the address of first cell in range to use as the data table's value. For the DATA table, we have ...

Abbreviate Names Or Words in Excel
abbreviate names1

As an MS Excel user, you might have come across a task where you need to abbreviate different names or words, and there are also possibilities that you might have done this task manually by assuming that there isn't any ...

Filter or Extract with a Partial Match
filter with partial match1

Assume you have a table consisting of a few cells having few values, and you want to filter out the set of records with the partial match. You might take it easy and would prefer to manually filter out the ...

Extract matching values From Two Lists
extract matching values from two list1

Suppose that you are working with two lists containing few values, and you want to extract the matching values from those two lists into another separate list. You might prefer to manually extract the matching values from the two lists, ...

Extract all Partial Matches
extract all partial matches1

Just assume that you have a range of data that contains a text string and you want to extract the few partial matches into another separate range of cells; then you might think that it's not a big deal; because ...

Extract Multiple Match Values into Separate Columns

If you have a few values/items in the excel sheet and you are thinking that with the aid of the “VlOOKUP” function you can look for a specific value, extract it and then put the matching item into the separate ...

Average the Last N Numeric Values in Excel

AVERAGE function is one of the most popular functions in Excel. Apply AVERAGE together with some other functions, we can calculate average simply for some complex situations. In this article, we will introduce you to calculate average of the last ...

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

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 ...

Sidebar