laparts.blogg.se

Here we’ve got the logo ready on our computer drive, so we’ll select the first option and find the folder where the picture’s been prepared.

Let’s click there, go to ‘Header & Footer’ and there we click on ‘Picture’.Įxcel will show several options of locations which we can browse to add the picture. Imagine we want to add a logo into the header section on the right. Let’s carry on and have a look at how to insert a picture, because there are a couple things that are worth mentioning about that. We can use the same way to insert, for example, ‘Current Date’, ‘File Path’, ‘File Name’ or the ‘Sheet Name’.

To add a total page count to the page numbers, simply click into the header again, type in a forward slash to separate the two numbers and then click on ‘Number of Pages’.Īgain, we can see a code here, but once we click outside the header area, what shows after the page number is the number of pages separated with a slash – just as we wanted. Click into the selected header section, then go to the Header & Footer tab on the Ribbon and select ‘Page Number’.Įxcel uses this code for page numbers, so if we now click anywhere within the document area, the header shows the number of the page there.

Let’s say we would like to insert page numbers in the left part of the header. This is the place where we can insert various elements in the header. Then we click anywhere at the top of the document to see these three sections. 6 How to Remove Any Element From the Header How to Display Header in the Sheetįirst of all, we need to display the header in the sheet, so we’ll go to the View tab and click on ‘Page Layout’.