Username:  
Password:  
Register 
It is currently Tue Jul 15, 2025 4:31 pm

All times are UTC [ DST ]





Post new topic Reply to topic  [ 10 posts ] 
  Print view Previous topic | Next topic 
Author Message
 Post subject: Excel wizzkids
PostPosted: Thu May 15, 2014 10:38 am 
Offline
User avatar

Joined: Wed Jun 13, 2007 10:25 am
Posts: 12959
Location: Huntingdon, Cambridge
Just wanted to ask if anyone can help me I am using excel 2003 and want the second page of my sheet to be landscape and all the others portrait is there any way of doing this?

I have created page breaks above and below the area i want landscape but when I go to orientation and click landscape it change is all.

_________________
"Whenever you're feeling stupid just remember, some people believe the Earth is 6000 years old"
"Simplicity is the ultimate sophistication"


Top
 Profile  
 
 Post subject: Re: Excel wizzkids
PostPosted: Thu May 15, 2014 10:40 am 
Offline
User avatar

Joined: Fri Aug 18, 2006 7:13 am
Posts: 7496
Location: Errr, Nottingham
Have you tried turning it off and then back on again?

_________________
If there's any more chew, the bar will be closed!


Top
 Profile  
 
 Post subject: Re: Excel wizzkids
PostPosted: Thu May 15, 2014 10:43 am 
Offline
User avatar

Joined: Wed Mar 06, 2013 6:28 pm
Posts: 15342
Have you tried swearing at it or twatting the desk dead hard with your fist?

Normally works for me.


Top
 Profile  
 
 Post subject: Re: Excel wizzkids
PostPosted: Thu May 15, 2014 10:47 am 
Offline
User avatar

Joined: Thu Aug 17, 2006 8:25 pm
Posts: 22670
Just change the page setup differently in the individual tab. I've just tried it and it worked fine in print preview.


Top
 Profile  
 
 Post subject: Re: Excel wizzkids
PostPosted: Thu May 15, 2014 10:48 am 
Offline
User avatar

Joined: Wed Jun 13, 2007 10:25 am
Posts: 12959
Location: Huntingdon, Cambridge
they are on the same sheet not on different tabs?

_________________
"Whenever you're feeling stupid just remember, some people believe the Earth is 6000 years old"
"Simplicity is the ultimate sophistication"


Top
 Profile  
 
 Post subject: Re: Excel wizzkids
PostPosted: Thu May 15, 2014 10:49 am 
Do it on a different sheet?


Top
  
 
 Post subject: Re: Excel wizzkids
PostPosted: Thu May 15, 2014 11:03 am 
Offline
User avatar

Joined: Wed Jun 13, 2007 10:25 am
Posts: 12959
Location: Huntingdon, Cambridge
I will just do it on separate tabs then, but then how do i include the page numbers as it wont fit in order?

_________________
"Whenever you're feeling stupid just remember, some people believe the Earth is 6000 years old"
"Simplicity is the ultimate sophistication"


Top
 Profile  
 
 Post subject: Re: Excel wizzkids
PostPosted: Thu May 15, 2014 11:57 am 
Offline
User avatar

Joined: Thu Oct 07, 2010 5:56 pm
Posts: 9187
Location: nearest takeaway
you shouldn't smerk more than one tab at a time like

_________________
Come on Pools


Top
 Profile  
 
 Post subject: Re: Excel wizzkids
PostPosted: Thu May 15, 2014 12:22 pm 
Offline
User avatar

Joined: Sat May 19, 2007 11:00 am
Posts: 20758
Agree, always easier to use a new tab instead of a different sheet.

Excel is a wonderful programme like.

_________________
I'd recommend a more stealthy plan than googling 'afternoon tea dog'.


Top
 Profile  
 
 Post subject: Re: Excel wizzkids
PostPosted: Thu May 15, 2014 1:19 pm 
Offline
User avatar

Joined: Fri Aug 18, 2006 7:20 am
Posts: 18484
Location: Up Jack's Arse in America
Compo wrote:
I will just do it on separate tabs then, but then how do i include the page numbers as it wont fit in order?


If you put the page numbers on as a footer and then choose "print entire workbook" from the print options that should do the trick.

_________________
Deep down inside you know I'm always right

NOTE: Any statements made by me are, for the avoidance of doubt and arseyness, my opinion and not necessarily absolute fact nor are they necessarily shared by the people who own and run this board


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 

All times are UTC [ DST ]


Gadgies online

Dodgepots browsing this forum: 1stockton, BansteadPoolie, bigdavemaddog, Brian Honour's Left Foot, Darylmore, derwent, elwood, Fat Rascal, Jamie1952, JBPoolie, JohnnyMars, Jules, loan_star, loyal_fan, Pitlad, Rinkender, Robbie10, Snowy, Stotty1908, The Kit Kat Kid, Wizwag and 275 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  







The Bunker. The only HUFC forum with correct spelling and grammar.