showing gridlies on printout

[embee]

I have excel 2003, lotus approach 97 and lotus 1-2-3 97 on my machine. I'm trying to print out an empty sheet apart from the rows and columns so that I can fill in by hand. I've done it before but cannot get it to work this time. I've ticked a box which says 'show grid lines' and they still don't print. Please can anyone help? Thank you in advance.

[kujawski]

Make you selection by click mouse , hold button and dragging, then place borders around the selected cells,.

then press print

[kujawski]

if you cant find the icon for borders, from menu select Format> Cells then tab borders

[ACtheTROLL]

why all the spreadsheets?

[gordyagusta]

try as follows :

from top left hand cell -- left click and drag cursor until you have highlighted the area you wish to print.

right click -- format cells --- click on border tab. from there you can choose the type of border line etc

[embee]

Thank you all for your answers. kujawski I've tried your suggestion but still there is nothing to print on the preview.

ACtheTROLL it's a long story but here goes. I inherited my computer from my daughter. It had windows 95 on at the time and Lotus. I have two useful spreadsheets on this so I kept it when I upgraded to XP. When I did a 10 week course with the local authority I had to have Excel. Hence the Excel. Hope this explains things.

gordyagusta Your suggestion is the same as kujawski, but still no joy.

Incidentally I have since tried on Word putting a table on it. The difficulty here was that I needed only 2 columns and on the print preview the columns went on forever. I'm determined to crack this. Have you any more suggestions please?

[ACtheTROLL]

that was sort of what I expected.

unless you have something really wierd in your sheet... you should be able to import it into excel.

make a copy ... and fiddle with that ... just in case I'm wrong ;-)

you shouldn't have a problem though ... the office that came with 95 (can't remember what the actual version was(95?) ... but I fell foul of it myself - so remember it well) had a bug in the import filter which screwed up certain formatting ... and some of the more popular formulas)

as far as I'm aware that was sorted with 97 and 2003 should (almost) certainly do the job smoothly

[embee]

Thank you once again for your input. I have managed to print a table out on WORD. It would have been nice to be able to alter the height of the rows, but I suppose I can't have everything!

Maybe I didn't make myself clear at first. This sheet has no writing writing on it, only lines denoting columns and rows so that it can be printed and filled in by hand.

When I go to print preview on the spreadsheets I am told there is nothing to print. I'm still going to battle it out with the spreadsheets though. I've done it once, why can't I do it again?.