block of cells appear as single cell
 

How to select a block of cells and make appear as a single cell ? ( but is
still multiple cells under the covers )

block of cells appear as single cell
 

=A1 & " " & B1.....

Or turn off gridlines and apply a border to your selection.


--
Regards
Dave Hawley
www.ozgrid.com
"John Grandy" <john.arthur.grandy-at-gmail.com wrote in message
...
How to select a block of cells and make appear as a single cell ? ( but
is still multiple cells under the covers )

block of cells appear as single cell
 

For what purpose?

One method.............

Select a range of cells A1:D10

Color background to white, put a border around that block.

Give the range a name.

Pick the rangename from Namebox.


Gord Dibben MS Excel MVP

On Wed, 31 Mar 2010 17:49:28 -0700, "John Grandy"
<john.arthur.grandy-at-gmail.com wrote:

How to select a block of cells and make appear as a single cell ? ( but is
still multiple cells under the covers )