Help with cells in a spreadsheet

  The Belarussian Mafia 20:07 03 Oct 2006

I've got 5 columns in the sheet. Only four rows have the cells showing on the print-out; on the fifth row the data appears but no cells. Why?!

PS I'm using Open Office, but it's virtually the same as Excel.


  marbleblue 21:05 03 Oct 2006

In Excel, anyway. The first is there a button on the formatting toolbar called Borders. Highlight the cells you want to show on your printout, then click the dropdown menu on this button, and select the icon 'All Borders', and then the cells which you highlighted should show up on the printout.

There is also a 'proper' way to do it, which I think is more permanent, but I can't think for the life of me how to do it, but that is a good quick fix alternative, and I'll be sure to post back if it comes to me.

  marbleblue 21:13 03 Oct 2006

Again, I can only say this works on Excel. Go to File>>Page Setup and click on the Sheet tab, then check Print..Gridlines. This will print all the gridlines on your selected print area (File>>Print Area>>Set Print Area)

Hope on of these solutions work!

  JoE. 23:13 21 Oct 2006

If so, please could you green tick this thread.

Thanks :)

  Chris the Ancient 11:24 22 Oct 2006

It may be that you filled the cell with white. Highlight the cells and make sure that the background is set to 'no fill' not 'white'.

  The Belarussian Mafia 17:49 23 Oct 2006

A big thank-you to marbleblue: the first solution worked perfectly. It was my son who needed this for his GCSE coursework, so it's also yet another feather in the bonnet for pcadvisor.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

WWDC history: Apple's product launches since 2005

Comment importer des contacts d’un iPhone à un autre iPhone ?