Home » Modify

Tag: Modify

Sharyn Baines

HOW TO delete a blank or extra page in Word document (5 quick fixes)

Needing a hand to remove a blank or extra page in Microsoft Word?

If you're reading this, you're probably wrestling with an extra page break or a blank page or a lot of space within your document somewhere.  

I'm going to show you several different fixes starting with the easiest and moving to the more unusual fixes. 

Fix number one – removing unwanted extra paragraphs 

On the Home tab click on the Show Hide character button. 

Once that's on you will see a little symbol on your screen. This represents where the Enter key has been hit on the keyboard to start a new paragraph. 

If you can see a whole heap of little symbols that means somebody has pressed the Enter key many times to start a new page. 

To remove them, select over the symbols and press your Delete key. This will delete the empty paragraphs and remove the extra space, hopefully removing your blank or wanted page. 

Fix number 2 – removing unwanted page breaks 

When you have your Show/Hide characters turned on you can also see where a page break has been inserted into the document. 

Creating a page break is simple. You can place your insertion point wherever you want to start information on a new page and on the Insert tab click the Page Break button. 

This inserts a page break symbol. 

So, all you need to do is delete the symbol and you will remove the page break and bring your text back together again. To get rid of those extra pages you may need to remove unwanted page breaks. 

Fix number 3 – checking the pagination settings 

If you have a big gap and you can’t see any paragraph markers or page break symbols, check your pagination settings. 

First click into the paragraph at the top of the next page (the paragraph after the big gap). 

Right click over the paragraph and select Paragraph. When the Paragraph dialog box opens click on to the Line and Page Breaks tab 

Remove the check mark from the Page break before option box and click OK. 

You should now have removed the big gap and your paragraphs will be back together again. 

Fix number 4 – removing a section break (the safe way) 

Section breaks can cause extra pages in your document. But before you remove them, just be careful. 

If you delete a section break you may delete any headers and footers you have in the previous section. 

A section break ‘sections’ your document so that you can have different page formats in different sections. 

For example, in section 1 you can have a header and page numbering. In section 2 you can turn these off. 

Deleting the section break between section 1 and section 2 will apply the header and footer settings from section 2 only, removing section 1’s formats. Therefore, your header and page numbering will disappear. 

So proceed with caution. 

What you can do prior to deleting the section break is go into the header, footer or page number settings for section 2, and connect these from section 1 by clicking the Link to Previous button. This will then continue the same formatting settings into section 2. 

Click Yes to connect to the header/footer in the previous section. 

Now, with your Show/Hide characters on you should be able to see the Section Break symbol. Just select it and press DELETE to remove it. 

And the extra page will now be gone, and your headers and footers should still be fine. 

Fix number 5 – removing a blank last page 

If you have a blank last page in your document that isn’t disappearing when you select the paragraph marker and press Delete, try this. 

From the Home tab turn on your Show/Hide characters and then go to the second to last page of your document. 

If you can see a page break symbol, select it, and delete it. 

If you can see many paragraph symbols with empty paragraphs, select these and delete these.  

You should now have removed your blank last page. 

Sharyn is an expert trainer.  She became the first certified Microsoft® MOUS Authorised Instructor in New Zealand.

She is endorsed by Microsoft® as a qualified Microsoft® Office Specialist and has more than 20 years of experience in the training industry, developing and delivering technology training workshops. Her approach to taking the “techie-speak” out of technology training has placed her as a preferred supplier to many of New Zealand’s leading organisations.

If you enjoyed this you may also enjoy...

Needing a hand to remove a blank or extra page in Microsoft Word? If you’re reading this, you’re probably wrestling with an extra page break or a blank page or a lot of space within your document somewhere.   I’m going to show you several different fixes starting with the easiest and moving to the more unusual fixes. Fix number one – removing unwanted extra paragraphs On the Home tab click on the Show Hide character button. Once that’s

​Read More

Freezing column and row labels in Excel (a.k.a Freeze Panes) locks parts of your screen so that you don’t lose sight of the heading labels at the top of a column or beginning of a row when you scroll. When working on large worksheets, labels used to identify data can be lost when you scroll in

​Read More

Without a doubt ‘Paste Link’ is one of the best time-saving features in Excel.  Linking information from one cell to another saves you from having to update data in several places. Another fabulous time-saving feature is ‘Paste Special Transpose’. This allows you to copy a horizontal range and paste it vertically, or vice versa. An absolute

​Read More
people sitting down near table with assorted laptop computers

Find, modify and break links to an Excel workbook

people sitting down near table with assorted laptop computers

 

Learn how to find, modify and break links to an Excel workbook.

Linking is great, until you no longer need it. Then it can be a bit of a pain.

A couple of challenges may come your way if you weren’t the creator of the workbook that contains links. One challenge is identifying where the linked data is within your workbook and another is actually breaking the link. Continue Reading

Sharyn Baines

Freezing column and row labels in Excel

Sharyn Baines

Freezing column and row labels in Excel (a.k.a Freeze Panes) locks parts of your screen so that you don’t lose sight of the heading labels at the top of a column or beginning of a row when you scroll.

When working on large worksheets, labels used to identify data can be lost when you scroll in either direction, and then you find yourself wasting time scrolling backwards and forwards, up and down, just to check you are actually in the correct column and row. Continue Reading

three gray bullets on brown surface

Don’t be fooled – protecting isn’t bullet-proof

three gray bullets on brown surface

sharyn bainesWhen I’m asked to teach a class on how to restrict editing within a document, the first 5 minutes of my instruction is usually spent explaining that protecting isn’t bullet-proof.

Why do I do this?  Because I have met so many people who assume that restricting the editing of a document by adding a password is in fact securing it so that only the holder or holders of the password can access the file.  Not true!  Via the Internet you can easily access a multitude of work-arounds that coach you through how to easily access the content of a restricted file. Continue Reading

person writing on white paper

Excel – Paste a link and Paste Special transpose your data

person writing on white paper

Without a doubt ‘Paste Link’ is one of the best time-saving features in Excel.  Linking information from one cell to another saves you from having to update data in several places.

Another fabulous time-saving feature is ‘Paste Special Transpose’. This allows you to copy a horizontal range and paste it vertically, or vice versa. An absolute gem.

But have you ever tried to use the two together?  It isn’t easy at all.  In this post I want to share a wee work-around that will allow you to use the Paste Link and Paste Special Transpose features together. Continue Reading