Excel Help
 

MegaSack DRAW - This year's winner is user - rgwb
We will be in touch

[Closed] Excel Help

7 Posts
5 Users
0 Reactions
55 Views
Posts: 0
Free Member
Topic starter
 

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 8: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 8: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 8: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 8: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 8: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 8: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 8:38 pm
Posts: 0
Free Member
Topic starter
 

Got it.

Cheers 😆


 
Posted : 26/01/2010 8:38 pm