Try an experiment of setting up ranges>one center across>one merged> SORT
Don Guillett SalesAid Software [EMAIL PROTECTED] ----- Original Message ----- From: "BobJohns" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Sunday, April 03, 2005 5:42 PM Subject: Re: Stupid Excel Question > Both effectively do the same thing. > > The one problem with Center Across is if the cells inadvertently get > formatted either Left or Right aligned then you have to go back and redo. > > With cell merge the cells stay so reapplying Center alignment is a wee bit > easier since you can quickly adjust from the tool bar. > > Bob J. > > At08:20 AM 4/4/2005, Don Guillett wrote the following message: > ==-==-==-==-== Begin Quoted Message ==-==-==-==-== > >You will like center across better > > > >Don Guillett > > > >> To center across several columns first select all cells - right click - > >> format cells - alignment tab - choose merge cells. > >> > >> Bob J. > >> > >> At06:52 AM 4/4/2005, Don Guillett wrote the following message: > >> ==-==-==-==-== Begin Quoted Message ==-==-==-==-== > >> >Select the cells>right click>format>alignment>center across > >> > > >> >Don Guillett > >> > >> >Subject: Stupid Excel Question > >> > > >> >> How do I write a heading that spans several columns? > >> >> > >> >> Pete Holsberg > >> >> Columbus, NJ > >> >> --- > >> ==-==-==-==-== End Quoted Message ==-==-==-==-== > ==-==-==-==-== End Quoted Message ==-==-==-==-== > > -- > ---------------------------------------- > WIN-HOME Archives: http://PEACH.EASE.LSOFT.COM/archives/WIN-HOME.html > Contact the List Owner about problems: [EMAIL PROTECTED] > Unofficial Win-Home List Members Profiles Page > http://winhome.wavijo.com/ > > > > -- > No virus found in this incoming message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.9.1 - Release Date: 4/1/2005 > > -- ---------------------------------------- WIN-HOME Archives: http://PEACH.EASE.LSOFT.COM/archives/WIN-HOME.html Contact the List Owner about problems: [EMAIL PROTECTED] Unofficial Win-Home List Members Profiles Page http://winhome.wavijo.com/
