Author Topic: EXCEL - somebody, please??  (Read 1308 times)

tim

  • Hectare
  • *****
  • Posts: 18,607
  • Just like the old days!
EXCEL - somebody, please??
« on: July 28, 2006, 06:58:53 »
How do I print a ruled page with empty rows & columns?

I just want 8 columns & as many rows as I can get onto a page.

supersprout

  • Hectare
  • *****
  • Posts: 4,660
  • mulch mad!
Re: EXCEL - somebody, please??
« Reply #1 on: July 28, 2006, 07:06:54 »
Select your 8 columns and about 100 rows

Using the menu bar at the top of the worksheet:

Format/borders and shading - select the criss-cross grid on the left to highlight the cell borders
File/page setup - select 'fit to page'. Make sure the orientation (landscape or portrait) is set to what you want

Insert a space in the bottom right cell of your selection (column 8, row 100 for example)

File/print - select '1' in 'number of pages'
Use 'print preview' to check OK

If you want bigger spaces in your printout, use Format menu to adjust paragraph size
Hope that works tim?

« Last Edit: July 28, 2006, 07:14:33 by supersprout »

tim

  • Hectare
  • *****
  • Posts: 18,607
  • Just like the old days!
Re: EXCEL - somebody, please??
« Reply #2 on: July 28, 2006, 07:55:58 »
I'll have a go!

 

anything
SimplePortal 2.3.5 © 2008-2012, SimplePortal