Bạn đang xem bài viết Excel Header And Footer: How To Add, Change And Remove được cập nhật mới nhất trên website Hoisinhvienqnam.edu.vn. Hy vọng những thông tin mà chúng tôi đã chia sẻ là hữu ích với bạn. Nếu nội dung hay, ý nghĩa bạn hãy chia sẻ với bạn bè của mình và luôn theo dõi, ủng hộ chúng tôi để cập nhật những thông tin mới nhất.
Do you want to know how to make a header in Excel? Or are you wondering how to add the footer page 1 to the current worksheet? This tutorial will teach you how to quickly insert one of the predefined headers and footers and how to create a custom one with your own text and graphics.
Headers and footers are displayed only on printed pages, in Print Preview and Page Layout view. In the normal worksheet view, they are not visible.
How to add header in Excel
Inserting a header in an Excel worksheet is quite easy. Here’s what you do:
Now, you can type text, insert a picture, add a preset header or specific elements in any of the three Header boxes at the top of the page. By default, the central box is selected:
When you print out your worksheet, the header will be repeated on each page.
Like an Excel header, a footer can also be inserted in a few easy steps:
As an example, let’s insert a footer that displays a page number and file name:
Voila, our Excel footer is created, and the following information will be printed at the bottom of each page:
Two things you should know about preset headers and footers
When inserting an inbuilt header or footer in Excel, please be aware of the following caveats.
Most of the preset headers and footers in Excel are entered as codes, which makes them dynamic – meaning your header or footer will change to reflect the latest changes you make to the worksheet.
2. Preset headers and footers are inserted in predefined boxes
When adding a built-in header or footer, you cannot control the location of specific elements – they are inserted in the predefined boxes no matter which box (left, center, or right) is currently selected. To position the header or footer the way you want, you can move the inserted elements to other boxes by copying / pasting their codes or add each element individually as explained in the next section.
How to make a custom header or footer in Excel
In Excel worksheets, not only can you add preset headers and footers, but also make your own ones with custom text and images.
This example will show you how to create a custom header with your company logo, page numbers, file name and current date.
To begin with, let’s insert File Name (workbook name) in the central header box:
Then, select the right box and insert Page Number there. As you can see in the screenshot below, this only displays the number:
Our custom Excel header looks pretty nice, don’t you think?
Tips:
To start a new line in a header or footer box, press the Enter key.
To include an ampersand (&) in the text, type two ampersand characters without spaces. For example, to include Products & Services in the header or footer, you type Products && Services.
To add page numbers to Excel headers and footers, insert the &[Page] code in combination with any text you want. For this, use the built-in Page Number element or one of the preset headers and footers. If you enter the numbers manually, you will end up having the same number on each page.
Add headers and footers using the Page Setup dialog box
If case you’d like to create a header or footer for chart sheets or for several worksheets at a time, the Page Setup dialog box is your option.
The Page Setup dialog box will show up where you can select one of the preset headers and footers or make your own one.
To create a custom header or footer, do the following:
For example, this is how you can add a page number to the right hand side of your Excel header: You can also type your own text in any section as well as edit or remove the existing text or codes.
There are two ways to edit headers and footers in Excel – in Page Layout view and by using Page Setup dialog.
Change header or footer in Page Layout view
Now, you select the header or footer text box and make the desired changes.
Change header or footer in the Page Setup dialog
Another way to modify an Excel footer or header is by using the Page Setup dialog box. Please remember that a header and footer of chart sheets can only be edited in this way.
Once you have finished creating or editing your Excel footer or header, how do you get out of the header and footer view and return to the regular view? By doing any of the following:
To delete headers and footers from multiple worksheets at once, carry out these steps:
Select the worksheets from which you want to remove a header or footer.
That’s it! All headers and footers in the selected sheets will be removed.
Now that you know the essentials of Excel headers and footers, the below tips may help you avoid common challenges.
How to add header and footer to all or selected sheets in Excel
To insert headers or footers on multiple worksheets at a time, select all target sheets, and then add a header or footer in the usual way.
How to format text in Excel header and footer
To quickly change the font style or font color of your header or footer, select the text and pick the desired formatting option in the pop-up window:
How to make a different header or footer for the first page
If you’d like to insert a specific header or footer on the first page of your worksheet, you can have it done in this way:
Change to Page Layout view.
Select the header or footer.
Go to the Design tab, and check the Different First Page box.
Set up a special header or footer for the first page.
Tip. If you want to create separate headers or footers for odd and even pages, select the Different Odd & Even Pages box, and enter different information on page 1 and page 2.
How avoid resizing the header / footer text when scaling the worksheet for printing
To keep the font size of the header or footer text intact when the worksheet is scaled for printing, switch to Page Layout view, select the header or footer, go to the Design tab and clear the Scale with Document box.
If you leave this checkbox selected, the header and footer font will scale with the worksheet. For example, the header text will become smaller when you select the Fit Sheet on One Page printing option.
That’s how you add, change and remove headers and footers in Excel. I thank you for reading and hope to see you on our blog next week.
You may also be interested in
How To Add Code To WordPress Header And Footer (2 Easy Solutions)
How to Add Code to WordPress Header and Footer With a Plugin
For most users, the easiest way to add code to the WordPress header and footer is via a plugin. The benefits of using a plugin over the manual method in the next section are:
Your code snippets will remain intact if you ever switch themes.
The plugin makes it easy to only add code snippets to the header or footer of your homepage, which can be helpful in some use cases.
The plugin is more beginner-friendly because it doesn’t require digging into the code.
While there are several plugins that offer this functionality, we recommend the Head, Footer and Post Injections plugin from Stefano Lissa because it gives you more control than many of the alternatives. It currently has over 200,000 active installs with a 5 out of 5-star rating.
Step 1: Install and Activate Head, Footer and Post Injections
Head, Footer and Post Injections is available for free at chúng tôi so you can install and activate it directly from your WordPress dashboard by going to Plugins → Add New and searching for it:
Step 2: Add Code Snippet to Head, Footer and Post Injections
Once you activate the plugin, you can access its interface by going to Settings → Header and Footer in your WordPress dashboard. You’ll see a number of tabs in the plugin’s interface. But for this guide, you’ll mostly work in the default Head and footer tab:
Every page – adds the code snippet to the header of every single page on your site. This is what you’ll want to use most of the time.
Only home page – only adds the code snippet to the header of your homepage.
For example, to add the Google Analytics tracking code to WordPress, you’d just paste it into the Every page box and save your changes:
Subscribe Now
Desktop – despite the name, this adds code to the footer of both the desktop and mobile version of your site unless you specifically check the box for Mobile.
Mobile – when checked, this lets you add a different code snippet to the mobile version of your site.
If you just want to add a code snippet to the footer section for all users, no matter their devices, paste it in the Desktop box and leave Mobile unchecked:
If needed, you can add multiple code snippets to each box.
BONUS – Add Code to Header and Footer of Google AMP Pages
Another neat thing about this plugin is that, if you’re using Google AMP for WordPress, the plugin lets you specifically add code snippets to the header and footer of the Google AMP versions of your pages ( as long as you’re using the official AMP plugin from Automattic).
To do it, head to the AMP tab in Header and Footer and paste your code snippet into the appropriate box:
If you are simply needing to add different PHP functions on a site-wide basis, we also recommend checking out the free Code Snippets plugin. It removes the need to add custom snippets to your theme’s chúng tôi file. It currently has over 100,000 active installs with a 5 out of 5-star rating.
How to Manually Add Code to WordPress Header and Footer
If you’re not familiar with the basics of PHP, we recommend you stick with the plugin method above. The manual method might be overly complicated for you.
In this section, you’ll learn how to manually add code snippets to your theme’s header and footer via its chúng tôi file.
If you want to proceed with this method over the plugin in the previous section, it’s essential that you use a WordPress child theme to make your edits. If you don’t use a child theme, any code that you add to your header or footer will get overwritten if you update your WordPress theme.
Many developers provide a child theme. But if your developer doesn’t, here’s a guide on how to create a WordPress child theme. Once you have your child theme ready to go, you can proceed with the following steps to add code to your theme’s header or footer.
While you can add code snippets directly to your chúng tôi and chúng tôi files, a better way is to use your chúng tôi file and the appropriate WordPress hook. This lets you keep all your snippets in one place and avoid modifying core theme files.
Step 1: Prepare Code Snippets
To get you started, we’ll give you a rough framework to add code to both your header and footer.
For each snippet, make sure to change:
The your_function_name placeholder (both instances)
The PASTE X CODE HERE placeholder
Step 2: Add Code Snippets to chúng tôi File in Child Theme
Once you have the relevant code snippet(s) ready, you need to add them to the chúng tôi file of your child theme. You can either edit this file by connecting to your site via FTP. Or, you can go to Appearance → Editor and select the chúng tôi file. Then, paste your code at the end of the file:
Make sure to save your changes and you’re done!
BONUS: Add Code to Header or Footer For Only Specific Pages
If you want more control over where your header or footer code snippets show up, you can use if statements to only add the code to specific pages on your WordPress site.
For example, to only add code snippets to the header or footer of your homepage, you could use:
Another option is to only add the code snippets to specific posts or pages. To do that, you can use this code snippet:
Make sure to replace the example number – 73790 – with the actual ID of the post or page you want to add the code snippets to.
When In Doubt, Use The Plugin
That wraps up our guide on how to add code to the header or footer of your WordPress site. If the manual code examples are confusing, we recommend that you use the plugin method. It’s much more beginner-friendly and, most of the time, gives you just as much functionality.
If you enjoyed this tutorial, then you’ll love our support. All Kinsta’s hosting plans include 24/7 support from our veteran WordPress developers and engineers. Chat with the same team that backs our Fortune 500 clients. Check out our plans
How To Add Or Remove Page Breaks In Word 2022
How to Add a Page Break
Word automatically adds page breaks when add more content than can fit on one page, but sometimes you’ll want to add a break somewhere else — for example, if you’re creating a new section in a long document or you want to create more space around an image or chart.
There are two simple steps for creating your page break:
1. Place the cursor where you want to start a new page. If you want to break up a long document and insert a page break between paragraphs, for example, make sure the cursor is in front of the first character that will start the new page.
If you’ve just finished a paragraph and want to start typing on a new page, the cursor will be at the end of the paragraph and y you can continue to step 2.
Alternatively, you can use the keyboard shortcut CTRL+Enter to quickly add a page break.
Other Kinds of Page Breaks
Word also offers additional types of breaks you can add to your document.
Column Break: If your document is formatted into multiple columns, you can force text from the first column to move to the next one. This is a better option than pressing Enter a few times to move the text to the next column, since doing that could mess up your formatting if the font size changes or you edit the text.
Text Wrapping: If you have a picture or other object in your document and want to add a caption, the text wrapping break will keep the caption with the object while making the rest of the document flow around both the object and your caption.
Next Page: This works just like the page break under the Insert menu, except it also creates a new section with the option to use entirely different formatting from the previous sections. For example, you can use a different section to rotate a page to landscape or portrait mode, add a different header or footer, or format the section into columns without affecting the rest of the document.
Continuous Break: Creates a new section, like the next page break, but doesn’t start you on a new page.
Even and Odd Page Breaks: Insert a section break and also take you to the next even or odd page (depending on which break type you select) so you can format your alternating pages in a document differently (e.g., right or left pages in a book).
How to Remove Page Breaks
You can remove page breaks you’ve added and also adjust where Word’s automatic page breaks appear.
To remove a manual page break:
3. Hit Delete.
Although you can’t remove automatic page breaks, you can adjust where they land and thus keep specific paragraphs or lines together.
Window/Orphan control: Makes sure at least two lines of a paragraph are at the top or bottom of a page
Keep with next: Makes sure no breaks happen between your selected paragraphs
Keep lines together: Prevents a page break in the middle of a paragraph
Page break before: Adds a page break before your selected paragraph
1. Highlight the paragraphs or lines you want to keep together.
3. Under the Line and Page Breaks tab, select one or more of these options:
All of these options help you better control your document’s formatting and flow.
How To Add And Delete A Watermark In Excel
The watermark is an image used in the background of the worksheet labeled as copy, draft, confidential or a picture of the logo. The Excel 2010 and later versions do not have built-in watermarks, therefore we need to learn how to add and delete a watermark using the Header & Footer tools.
Figure 1. Watermark
How to Add a Watermark
First of all, we need to save an image on our computer which we want to use as watermark. Alternately, we can create a watermark by using the WordArt or Microsoft Paint tools and save it as an image on the computer. We need to follow the below steps to add watermark to worksheet.
Go to the
View
tab and from
Workbook Views
group select the
Page Layout
.
Figure 3. Header & Footer Tools
From the
Header & Footer Elements
group, select the
Picture
element and browse the picture where we have saved it on the computer. Select the picture and press the
Insert
button
Figure 4. Insert the Watermark Picture
The Header box of worksheet appears with text
&[Picture]
to indicate that the header contains a picture now.
Figure 5. Header Box Containing Picture Text
Figure 6. Insert Watermark
Figure 7. Formatting the Watermark Picture
How to Delete a Watermark
To remove watermark we need to follow the below steps;
Select the text
&[Picture]
and press the Delete button
Figure 8. How to Remove Watermark
Instant Connection to an Expert through our Excelchat Service
Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.
Cập nhật thông tin chi tiết về Excel Header And Footer: How To Add, Change And Remove trên website Hoisinhvienqnam.edu.vn. Hy vọng nội dung bài viết sẽ đáp ứng được nhu cầu của bạn, chúng tôi sẽ thường xuyên cập nhật mới nội dung để bạn nhận được thông tin nhanh chóng và chính xác nhất. Chúc bạn một ngày tốt lành!