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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top