[AccessD] OT: Excel - Merge several cells

O'Connor, Patricia (OTDA) Patricia.O'Connor at otda.state.ny.us
Thu Jul 19 13:47:03 CDT 2007


FYI
Unless there is a way to change things

	If there is text or even formulas in the other cells those will
be lost. 
	Only what is in the 1st (leftmost) cell will remain.  
	Example  cell1:  Hello 1, Cell2:  Iam2, Cell3: =A+B.  
	Only "Hello 1"  will remain if you merge all 3 cells

Patti
**************************************************
* Patricia O'Connor
* Associate Computer Programmer Analyst
* OTDA - BDMA
* (W) mailto:Patricia.O'Connor at otda.state.ny.us
* (w) mailto:aa1160 at nysemail.state.ny.us
**************************************************
 

> 
--------------------------------------------------------
This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments.  Please notify the sender immediately by reply e-mail and delete the e-mail from your system. 


-----Original Message-----

> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
> Sent: Thursday, July 19, 2007 10:56 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] OT: Excel - Merge several cells
> 
> There is a button immediately to the right of the right-hand 
> justify button.
> It's called Merge and Center.
> 
> 1) Select the cells you want to merge.  (you might lose text)
> 2) Push the button.
> 
> That's it!
> 
> Dan Waters
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Thursday, July 19, 2007 9:32 AM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] OT: Excel - Merge several cells
> 
> I need to "merge" several cells to create one big cell.  I 
> have seen this in spreadsheets but have no idea how to do it myself.
> 
> Any clue?
> 
> For example, a1,b1,c1 becomes one big cell, but a2,b2,c3 and 
> all the cells below them remain as they were.  I need to put 
> text in a "header cell".
> 
> TIA
> 
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>





More information about the AccessD mailing list