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

=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
news:(E-Mail Removed)...
> How to select a block of cells and make appear as a single cell ? ( but
> is still multiple cells under the covers )
>

For what purpose?

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

Select a range of cells A110

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 )
>