Forum menu
Excel Help
 

[Closed] Excel Help

Posts: 0
Free Member
Topic starter
 
[#1263603]

Hi,

Trying to do a simple worksheet for something at work - got it fine on the pc, but how do you configure it so that when printed you get the grid too ? I'm just getting the text without a grid etc....

Cheers


 
Posted : 26/01/2010 9:24 pm
Posts: 12
Free Member
 

Page layout > Sheet > Gridlines

(May be slightly different depending on version but should be something like that)


 
Posted : 26/01/2010 9:26 pm
Posts: 0
Free Member
 

Alternatively.... highlight the cells that make up your table and actually put borders round them.

Right click, format cells, borders etc etc


 
Posted : 26/01/2010 9:29 pm
Posts: 0
Free Member
Topic starter
 

Getting there....

Ive got grids but only on the first 3 lines where i have text entered - how do i get it to do a whole a4 sheet of grid ?


 
Posted : 26/01/2010 9:31 pm
Posts: 0
Free Member
 

highlight the area you want and click "set print area" in the file menu.

with these cells highlighted you can format the border which includes internal gridlines


 
Posted : 26/01/2010 9:34 pm
Posts: 0
Free Member
 

Highlight about an A4 page's worth of cells and then set print area.

Tiggs you sh1t!


 
Posted : 26/01/2010 9:36 pm
Posts: 145
Free Member
 

I'm on the mac at the moment, so from memory I think you can go to

File > page set up, then under one of the tabs is the option to include the row and column headers and the grid


 
Posted : 26/01/2010 9:38 pm
Posts: 0
Free Member
Topic starter
 

Got it.

Cheers ๐Ÿ˜†


 
Posted : 26/01/2010 9:38 pm