Navigation Previous Next Homepage FAQ What's new Sitemap Topics Excel 2010 Office button Home Insert Page Layout Formulas Data Review View Developer Excercises Autosum Chart - Insert a second axis Create a half-moon chart Create a demographics chart Conditionnal formatting Data table Pivot table Scenario Manager Solver Tutorials Word Excel 2003 Excel 2007 PowerPoint Access Others Demonstration files Texte en français Word 2010 Tutorials Contact By e-mail Join our Newsletter Share this page	Excel 2007/2010 - The View tab Introduction Workbook Views Normal Page Layout Page Break Preview Custom Views Full Screen Show/Hide Ruler Gridlines Message Bar Formula Bar Headings Zoom Zoom 100% Zoom to Selection Window New Window Arrange All Freeze Panes Split Hide Unhide View Side by Side Synchonous Scrolling Reset Window Position Save Workspace Switch Windows Macros View Macros Record Macro Use Relative References

Introduction

Workbook Views

Excel allows you to see your spreadsheet in several ways. Chaque option apporte un avantage. Each option provides a benefit.

Normal

This is the normal display mode or you work with Excel. However, there are other options that benefit.

Page Setup

This option gives you an overview of your design on paper. You can always adjust the size of the cells, move text, numbers or other objects to keep working on your model. The advantage is to immediately see the impact of your changes on paper instead of using the Print Preview option under the Office button.

Page Break Preview

As in previous versions of Excel, you can see the page breaks and change their location.

You can change the location of page breaks when you are in this mode of afficage.

Place the pointer on the blue bar of the page break you want to change the location.
While pressing the left mouse button, move the bar to its new emplacment.
Release the mouse button.

Custom Views

You can create your own views in your workbook. This can include many workbooks opened at the same time.

Full Screen

Full-screen mode lets you focus on your model by removing the tape commands and the status bar. You can navigate through your model and make the changes you want the content of the cells.

Press Esc to return to normal.

Show/Hide

Ruler

The rule is only available when you use the display mode layout. It allows you to see the emplement copntenu your spreadsheet on paper.

Gridlines

This option allows you to show or hide the grid on the screen. This gives you a better view of your model once placed on paper.

Message Bar

Formula Bar

The formula bar allows you to view and edit cell contents. You can remove it from the screen. But this is not recommended.

Headings

The titles are the elements that describe the contents of the rows and columns. You can remove it temporarily. But it is better to use the full screen display mode.

Zoom

It's easier to concentrate on some of the data or have an overview of the entire spreadsheet. Change the zoom to change the range of data that you can see on the screen.

Zoom

Note: The maximum zoom is 400%.

100%

Replace the data view 100% or normal size.

Zoom to Selection

There is also another way to access the zoom. You will also find the zoom options in the lower right corner of the screen.

You can find bar display modes normal, page layout and page break preview and a ruler to easily change the zoom on the screen.

Window

Excel allows you to open multiple workbooks at the same time. Each workbook is in its own window. The options in this group of commands allows you to manage these windows to display the data you want on the screen.

New Window

Arrange All

Freeze Panes

This option allows you to freeze the contents of a portion of the screen. This is useful when you enter data while wanting to see the titles of the rows and columns.

Place the cursor in cell B4.

From the View tab, in grouping the commands window, press the Freeze Panes.

This button will give you three options. The first, Freeze Panes, the screen will freeze all rows above and all columns to the left of the current cell. It is this option you will use most often. The second option, Freeze top row, will only freeze the first row that is displayed on the screen. So if the first line displayed is the line 5, that it will be fixed. The third option, Freeze first column will only freeze the first column on the screen.

Note
You cannot use Freeze top row and Freeze first column at the same time. We must use the Freeze panes instead. With this option, you can decide to freeze on the screen many rows and columns if required.

For this exercise, select Freeze Panes.

You can now move around the spreadsheet knowing that the securities will still be displayed. It's easier to understand the contents of a cell when you can refer to securities that are above and to the left of the screen.

Press the CTRL and Home keys.

This will take you back to the first cell of the non-rigid sheet. To remove this option:

From the View tab, select the options Freeze panes and Unfreeze Panes.

Split

The option will split the screen into multiple windows and is useful when you want to compare data that are apart from one another. For example, you want to compare the figures for this month with those of last year and forecasts of next year. However, there are twelve months of data between the two. The next exercise will show you how to put two cells next to each other by splitting the screen.

Open a new workbook or move the pointer to a new worksheet.
Place the cursor in the cell D6.
Select the View tab and the Split option.

Hide

You can temporarily hide a window to let space to other documents.

Unhide

You can then view the window you have hidden.

View Side by Side

Another option is to display the window next to each other to compare data.

Défilement synchrone

Synchronous scrolling allows two windows held at the same time. This is advantageous to compare data.

Reset Window Position

Save Workspace

You have created a workspace that may contain many windows and workbooks. You can save this workspace to reuse it later.

Switch Windows

Excel allows you to work on several files simultaneously. You can switch from one workbook to another using the taskbar at the bottom of the screen. But you can also use the Switch Windows in the View tab if the bar is hidden.

Macros

Sometimes by the time we have to perform repetitive tasks, a series of commands that you should always run in the same order. It is in these situations that a macro-control is advantageous. You can run a series of commands by pressing a button. You can either start a macro from the View tab or activate the Developer tab.

Run a macro

Place the cursor in cell B10.
Press Macro.
Select View Macro

Enable the Developer tab

View Macros

Record Macro

Select the spreadsheet model.
Place the cursor in cell B3.
Press the Record Macro.

It is from this window you can name your new macro. This name should not include spaces. As for the name of cells, you can use an underscore (_ or Shift + -) to join two words. You can also create a shortcut to the macro-control by combining it with the CTRL key. But do not forget that some key combinations are already used and are very convenient. Here is a list:

Press the Use relative references.

Select the cells B3 to D3.
Select the Home tab.

Select the background color of your choice. Also change the color of the font. Return to the Developer tab or View tab. Press the Stop Recording button.

Your little macro command has been executed and affect cells B10 to E10. If you have not selected the option Use the relative reference is to say from where the cursor is at the beginning of the execution, the macro-control s'aurait run the macro the same place as you saved it.

View Macros

Use Relative References

This site is hosted by 1&1.com