block of cells appear as single cell

J

John Grandy

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

ozgrid.com

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

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

Gord Dibben

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
 
Top