Split Screen

If you still need more space you can try to split the window by double clicking in the corner, just above scroll-bar. 


This will lock the data above the cell where your curser was and allow you to scroll the below data. 


This can be especially helpful when reviewing large amounts of data. 

Zoom

You can change the zoom level to show more cells. You can control the zoom from the View tab of the Ribbon.

The zoom feature can also be access at the bottom right corner of Excel.

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.

Closing Excel

The Office button at the top left hand corner of Excel can be double clicked on to quickly close Excel. This allows you a quick and easy way to close Excel.

If you have made changes to your file, Excel will prompt you to confirm if you wish to save the changes before closing.

Full Screen View

Excel allows you to view the workbook on the entire screen. 


From the View tab of the Ribbon you can select the Full Screen command. 

To return to the normal screen view, press the Esc key on the keyboard.

Navigation

Double clicking the side of a cell will scroll to last cell with data in the row (a blank cell will stop the curser).

You can also double click on the cell top or bottom to scroll up or down the column (a blank cell will stop the curser).


This is a handy way to quickly move around your data but be careful. If you click on the lower right corner of a cell instead of the side or bottom, Excel will auto fill in data.

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 8^th 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.