Showing posts with label 2007. Show all posts
Showing posts with label 2007. Show all posts

Maximum Size Of Worksheet







The cell reference address is displayed in the Cell Name Box and is determined by its representative column letter and row number. The first cell displayed in the upper left hand corner of any new workbook is cell A1 (the intersection of column A and row 1).

Excel allows over one million rows of data and over sixteen thousand columns of data. As Excel gets close to column Z, Excel doubles the letters and repeats the process so the column address’s show as W, X, Y, Z, AA, AB, AC…

If you were to go to the very last possible column its address would be XFD. If you went to the very last cell, its address would be XFD1048576.

Navigation with the Ribbon

Navigation within Excel 2007 is accomplished by using the Ribbon. The Ribbon can be found at the top of Excel and is a significant change from other versions of Excel as it is the primary replacement for menus and toolbars.

Designed for easy navigation, the Ribbon consists of tabs that are organized around specific situations or objects. The controls on each tab are further broken down into similar like groups.

By default, Excel shows 7 tabs on the Ribbon. These are Home, Insert, Page Layout, Formulas, Data, Review and View.

There is also an 8th Ribbon labeled Developer that can be added by the user if required.

As you click on each Ribbon tab, the Ribbon will dynamically change.

Home tab - Contains the most common formatting and editing options.


 Insert tab - Options to insert pictures, charts, headers, footers, and pivot tables.

Page Layout tab - Set margins, page orientation, gridlines, and heading options. Themes can also be found on this tab.


Formulas tab - Functions, formulas, auto sum options and name definitions.

Data tab – Allows you to get data from other sources such as Access and text files. Sorting, filtering and outline commands are also here.

Review tab – Contains the spell check, thesaurus, comments, and workbook /sheet protection options.

View tab – Options for workbook views including zoom and gridlines. Macros and the switch windows commands are also on this tab.


Developer tab – This tab can be added to the Ribbon is desired and has advanced controls used for Visual Basic and Macros.


To add the Developer tab, mouse click on the Office Button at the top left corner and then select Excel Options.


















From the Excel Options dialog box, left mouse click on Show Developer tab in the Ribbon.








When done, select the OK button.