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 2010 - The Page Layout tab

Introduction

Themes

Themes
Colors
Fonts
Effects

Page Layout

Margins
Orientation
Size
Print Area
Breaks
Background
Print titles
Other options for Page Setup

Scale to fit

Width
Height
Scale
Other options for Scale to Fit

Sheet options

Gridlines
Headings
Other Sheet Options

Arrange

Bring Forward
Send backward
Selection Pane
Align
Group
Rotate

The options you find in the Page Layout tab lets you adjust how your document will be presented on paper. Cette page va vous donner une description de chacun des items qui vont vous aider à mieux parraître sur papier. This page will give you a description of each item that will help you parraître paper.

Themes determine which style of presentation will be accessible from the gallery style who are under the Home tab. Sélectionnez de la liste des thèmes disponibles, les couleurs, les polices de caractères et même les effets d'animation. Select from the list of available themes, colors, fonts and even the animation effects.

Pressing the Themes button, you will have access to a list of predetermined styles. Vous pourrez aussi vous connecter à Office Online et aller chercher d,autres thèmes de présentations qui ont été développés depuis la sortie du logiciel. You can also connect to Office Online and get to other topics of presentations that have been developed since the release of the software.

You can also change the colors of individual features.

Select New Theme Colors.

In addition to change the colors of presentation styles, you can also change the fonts that are used in carcatères themes.

You can also choose from a list style for the filling of cells and borders.

The Page Layout group of commands will allow you to determine the best layout for your document on paper. This is where you determine the margins, the paper orientation, the paper size (Letter, Legal, A3, A4, A5 ...), the print area, where the page breaks will be located, the background and the titles will appear on every page.

Margins determine that there is space between the edge of the paper and the contents of your document. You can control this spacing

There are only two options for the paper orientation: Portrait (vertical) or landscape (horizontal). This will have an impact for all your printing. Contrairement à Word, Excel ne permet pas d'imprimer une partie du document avec une oritentation de papier et le reste avec l'autre orientation. Unlike Word, Excel does not print a "section" of the document with one paper oritentation and the rest with another. Toutes les pages imprimées avec Excel doivent être avec la même orientation. All pages must be printed in Excel with the same page orientation. Sinon, vous devez changer l'orientation du papier entre chaque impression. Otherwise, you must change the orientation of paper between each print.

Excel also allows you to change the paper size according to what your printer supports and what is best for your document.

You do not have to print the whole document each time. You can print the parts of the document you need. You can ask to print selections when selecting the Print option. But you can also identify print areas in advance stretches of cells you want. Be careful. Même si plusieurs zones d'impression peuvent entrer sur une même page, Excel va imprimer chaque zone d'impression sur des pages différentes. Although several print areas may come on the same page, Excel will print each print area on different pages. To print many ranges into a single sheet it is best to hide rows and columns that you do not need before you print.

This is the most important element of the layout. Vous pouver déterminer l'endroit précis où l'impression d'une page va commencer ou finir en plaçant des saut de pages au bon endroit. You can determine exactly where the impression of a page will start or end by placing page breaks at the right place.

In some cases, it is préféable have an image or a logo behind the values to better represent the content. Vous pouvez choisir parmi les images disponibles sur l'ordinateur, sur Office Online ou parmi vos propres images. You can choose from the available images on the computer, on Office Online or from your own images.

In a model, there is always a row or column containing titles to describe the content. It is preferable that these titles appear on each page of your print. Cela devient encore plus important lorsque vous avez un grand document. This becomes even more important when you have a large document.

From the Sheet tab, you can first determine what the print area. C'est cet étendue de cellules qui sera imprimé sur papier. It is this range of cells that will be printed on paper.

The rows to repeat at top and columns to repeat at left boxes are you using to determine what will be repeated on each page of printing.

Under the Page Layout tab, you will find options to change the paper size and to determine the paper feed.

Often a row or column is not on a page. Vous pouvez zone réduire le pourcentage afin de pouvoir entrer une ligne ou deux de plus sur une même page. You can reduce the percentage area in order to get a line or two more on the same page. Instead of looking for the ideal percentage, you can determine the page length and width that you document must meet. Excel will automatically find the required percentage to be able to print the area into the number of pages you requested.

Use this option to determine the number of pages wide that your document is printed.

Use this option to determine the number of pages tall that your document is printed.

Use this option to manually change the overall size of printing. Remember to make a print preview to make sure your next printing meets your needs.

From the Scale section, you can manually change the size by percentage of printing. You can ask Excel to automatically adjust the percentage of printing depending on the number of pages in width and height you want.

Remember to ensure you complete the check print quality. Otherwise, Excel will refuse to print.

The numbering of pages automatically, but you can enter the number of the first page in the last box. Cela est avantageux lorsque vous avez à intégrer votre document Excel avec d'autres documents. This is advantageous when you have to integrate your Excel document with other documents.

This is the Insert tab you find the options to add a header or footer to print the document. However, you can also choose this option by selecting the Header and Footer tab.

You can then choose from a list of headers and footers or create your own preset headers and SIDS page.

The grid spreadsheets is important when entering data and creating formulas. However, printing the grid for the entire document is rarely required. Les en-têtes des feuilles de calculs (les case avec les A, B, C au haut de feuille de calcul ainsi que les numéros de chaque ligne) sont rarement requis pour l'impression. The headings of the spreadsheet (the box with the A, B, C at the top of spreadsheet and the numbers of each line) are rarely required for printing. But here you can decide to activate them if you think it is good for your document.

Find out here if you want to see the grid on the screen and in print.

Determine if you want to see the headers spreadsheets (A, B, C on the first line and 1, 2, 3 on the first column) on the screen and in print.

This option places the form you have chosen over the stack of forms.

This option places the form you have chosen below all other forms on the screen.

This button opens a pane to the right of the screen with the list of forms contained on the spreadsheet. You can see them or hide them and to change the order of presentation of forms.

You can decide how the forms will be aligned with one another.

Select two or more forms, keeping a finger on the Shift key (Shift) or Ctrl.
Press Group.

The forms you have chosen will now only one object that you can travel in groups or change its options. Vous pourrez aussi dégrouper ses formes si requis. You can also unbundle its forms if required.

Vous pouvez changer l'orientation d,une forme pour mieux répondre à vos besoins. You can change the orientation of a shape to suit your needs.

Sélectionnez la forme que vous désirez réorienter. Select the shape you want to redirect.
Appuyez sur bouton Rotation. Press the Rotate button.
Donnez la rotation que vous désirez à la forme. Give the rotation you want to form.