Click on the image to see full screenData is always entered into 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.
The tab also contains a save as option which will allow you to save multiple versions of a worksheet and an option to download a copy of a worksheet to your own computer.
Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.worksheet and each one is identified by a letter in the column header.
Rows run horizontally in a worksheet and are identified by a number in the row header.
Together a column letter and a row number create a cell reference. Each cell in the worksheet can be identified by this combination of letters and numbers such as A1, F456, or AA34.
Switching between worksheets in an Excel Web App file is done by clicking on the sheet tab at the bottom of the screen. By default there are three worksheets per workbook or spreadsheet file.
The Quick Access Toolbar available in Excel 2010 and 2007 has been shortened to just these two very handy options.
On the left is the Undo button that allows you to reverse accidental or undesirable changes to a worksheet. Each time you click on the undo button it reverses the last action you did.
Redo reverses the action of Undo. So if you undo too many steps you can get them back by clicking the Redo button.
It is important to note that both Undo and Redo always work in the order that you first performed them. You cannot, for example, undo a deletion from four steps ago without undoing the last three steps you performed.
The Ribbon is the strip of buttons and icons located above the work area. The Ribbon is organized into a series of tabs - such as File, Home, and Insert. Each tab contains a number of related features and options.
First introduced in Excel 2007, the Ribbon replaced the menus and toolbars found in Excel 2003 and earlier versions.