how to create own color layout in excel for mac

You can add a header or footer to a page, change the margins as well as several other options.

This page shows you how to set-up your printout as well as the options for printing.

Youll then be able to improve the presentation of your file on paper.

You can change the margins of sheets, add the headers, the footers and several other options that will be discussed below.

This is very practical when all the columns of youre worksheet should be on one page only.

You can also ask Excel to find automatically the best size to enter your document.

Instead of printing all the contents of a worksheet, you can choose.

The option Print titles will reprint the selected rows and columns on to every page.

The watermark does not appear in other worksheets in the same workbook.

However, there are a couple of ways that you can simulate the look of a watermark.

In this document, well discuss how to create watermarks with images, like a company logo, and using an image as a worksheet background.

Excel watermarks also do not support processes such as pasting in a block of text from Microsoft Word as a text watermark.

You create the text you want for your watermark in a custom graphic in a standard picture file format such as.PNG,.JPG or.BMP, and import it into the Excel worksheet header.

You can then use this picture as a watermark as many times as you want in your Excel worksheets.

Use your preferred graphics program, such as Microsoft Paint, to create the picture file with the text you want to use as your watermark.

The header appears directly above Row 1 of the worksheet, in three sections.

Click inside the left, center or right section for the header.

When you create data on a new page in the same worksheet, the watermark appears on the new page.

NOTES: You may resize the watermark after you import it into Excel.

In Page Layout mode, click the cursor in front of the in Picture.

Use the Size tab to change the size of the watermark image on the worksheet.

For other watermark settings, see the section Editing graphics properties for watermarks.

Youll see the watermark only when youre in Page Layout view or in Print Preview.

Insert a DRAFT watermark When you share printouts of a worksheet and want people to know its not the final copy, you can add the word DRAFT to the background on all the printed pages of your worksheet.

NOTE: Youll see the watermark only when youre in Page Layout view or in Print Preview.

Right-click this link ( DRAFT ), click Save picture as or Save target as., and save the file to your computer.

You can use this sample image for your watermark.

The new DRAFT watermark appears in the currently displayed worksheet.

How To Create Own Color Layout In Excel For Mac