Computer Hope

Software => Computer software => Topic started by: billgates on January 26, 2006, 01:30:30 AM

Title: paging in excel
Post by: billgates on January 26, 2006, 01:30:30 AM
Someone, please help me with this task - How do i make more than one page in an excel sheet. Answers needed urgently from the gurus in the forum. thanks.
Title: Re: paging in excel
Post by: dl65 on January 26, 2006, 02:06:14 AM
billgates....Not 100% sure what it is you want to do , but it sounds like you wish to have a number of sheets showing up down at the bottom. For example if you open up excel ...I think it will show ( down at the bottom ) Sheet 1 , 2 and 3 ....with one being active .... If you want more than that , click on ...INSERT /WORKSHEET and presto another one has been added . If you want to rename the sheets to something else...... right click on ...for example sheet 1 and select rename ......

dl65  ::)
Title: Re: paging in excel
Post by: Rob Pomeroy on January 26, 2006, 02:28:28 AM
If by "page" you mean "printed page", it's all in the printer settings.  You can manually insert page breaks (i.e. hive off a section of each sheet for printing) or let Excel automatically choose page breaks.

Hint: large spreadsheets are never going to print well.
Title: Re: paging in excel
Post by: Michael on January 27, 2006, 07:56:23 AM
I think robpomeroy made the guess because he mention "in a worksheet" not "in a workbook".
But maybe he doedn't even know the difference?