Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel courses in london - page boarders while printing

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses in london - Page boarders while printing continued pages

excel courses in london - Page boarders while printing continued pages

ResolvedVersion Standard

Fazil has attended:
Excel Advanced course

Page boarders while printing continued pages

Hello,

Thanks for your ongoing support.

While printing multiple pages (running to about 25 pages) how do I insert page boarders automatically for evey page..?

Regards... Fazil

RE: Page boarders while printing continued pages

There is no function in Excel to insert Page Boarders. But you can switch to View menu -> Page Break Preview to change the 25 page breaks manually .

Hope this helps.

Katie

RE: Page boarders while printing continued pages

Thanks Katie...! Thats how am doing now, just thought there could be a short-cut to do it.

Regards... Fazil

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.