Showing posts with label Ribbon. Show all posts
Showing posts with label Ribbon. Show all posts

Alignment Tab

If you are new to Excel, you will use the Alignment tab quite often. Found on the Home Tab of the Ribbon (Excel 2007 version), the Alignment tab allows you to position (justify) text in a cell.











From Top left to right, Horizontal alignment of text (top of cell, centered, and lower. The bottom left to right left justify, center and right justify.

Other features of the alignment tab include indenting text, wrapping text in a cell and merging multiple cells (basically creating one large cell). You can even change the text direction from the Alignment tab.

Clicking on the lower right hand corner of the tab will bring up the Format Cells dialog window to even give you more formatting options.

Collapse The Ribbon

Double clicking on Ribbon menu tab names will collapse the Ribbon to give you more space. This can be handy if you wish to see a few more rows on the screen but Excel can’t display them due to your screen size and resolution.


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.