| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 ) |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 ) |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 ) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Single Cell To more cells | Excel Discussion (Misc queries) | |||
| fill any random cell in a column and block all other cells | Excel Discussion (Misc queries) | |||
| Pasting a block of Word info into a single Excel cell | Excel Discussion (Misc queries) | |||
| How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
| Return a block of text based on a single "short name" entry | Excel Worksheet Functions | |||
Hybrid Mode
