Help needed from Excel experts please

[Pennies]

I am designing my own wall calendar for next year in Excel. So far so good but with it needs a bit of prettying up.

I have had to use as much available space to fit the year on the page (which is poster size) and what I really want to do is put a border round the very edge of the poster.

I've tried the usual ways of doing a border on a table but a) they are too far from the edge and b) the borders available are really dull. I'm looking for something a bit celtic or maybe a geometric pattern. I found a couple of things on clip art that might do though.

So, my question is can anyone tell me how on earth to get a border in the outer margins of a n Excel page.

Why dont you highlight the area you want in Excel and then copy and paste it into Word, where you can insert any border you like as clip art - that may work?

Would that work with a table though?

Just try it and see! I have done it with a table and you just highlight the area and then right click to copy. Open word, and select the paste special command, and paste in as a picture - it doesnt bring in the gridlines. You can then do what you like - re-size it, etc and add borders, etc from Clip art.

You can't get fancy borders in Excel, only the plain lines.

You can paste a table into Word.

Aahh OK have pasted it into word as a picture and all is good except that for some reason the bottom few lines of my table in image form in word are blank, even though the picture space clearly accommodate this. Any advice?

I would try and Paste Special into a different format to see whether that makes a difference

Why paste it as a picture? Pasting it as a table sounds as though it would be more flexible (although I may be missing something).

Try to go to teh paste special menu and paste it as an excel table

Tried that too and it's still lopping off the last ten rows or so.

Have you tried looking at the print preview and zooming in.

Sometimes Word can appear to miss the lines from a chart on screen. But they do actually print on the print preview and when printed.

You can do a test print on A4 by selecting "fit to page" in one of the print option menus