Include Excel graphic in the header
There are many users who do their office work with Excel and sometimes it is necessary to add a graphic to the header. Unfortunately, it does not work under View> Header and Footer, as in Word. With a trick you can also include a graphic in the header in Excel.
The first step is to insert the graphic in a worksheet, proceed as follows:
Insert> Graphic> From File ... choose.
Then you move the graphic to the top of the table. In the second step on File> Page Setup ... and in the following window the register Table click. Specify here the area of the in "Repeat lines above" is to be entered. If the area of the graphic is from line 1 to 5, then you have to enter $ 1: $ 5.
Now the graphic is displayed on each page. You don't necessarily have to repeat a graphic in the first five lines. The whole thing also works with text.
Questions about Office or especially Excel click here.
more interesting Excel tips:
- Delete duplicate entries in Excel 2007
- Rotate Excel table (transpose)
- Enter numbers as text / display leading zeros
_
| Transparency: | This article may contain affiliate links. These lead directly to the provider. If a purchase is made through this, we receive a commission. There are no additional costs for you! These links help us to refinance the operation of win-tipps-tweaks.de. |
This tip comes from www.win-tipps-tweaks.de
© Copyright Michael Hille
Warning:
Using Registry Editor or its tips incorrectly can cause serious system problems that may require you to reinstall your operating system. Tampering with the registry files and using the tips is at your own risk.