View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default Don't merge cells?

Yes are you odd or even ?
Steve

On Sun, 10 Sep 2006 14:09:56 +0100, Roger Govier
wrote:

Hi Epinn

Mark the range of cells A1:C1, then
FormatCellsAlignmentSelect the Horizontal dropdownCenter across
selection
There is nothing to stop you from starting to type in A1.
If the data is truncated, then you need to widen the columns.
You do not get gridlines in between.

If you do not have any data in B1 or C1, then just typing the whole of
the text in A1, will give the appearance of a single cell without
gridlines

Choosing Merge, also truncates the data, unless you widen the column(s)

Incidentally, I noted from earlier postings Epinn is an acronym of
(Electronic (pin) (n)umber but you do not say whether you are male or
female?