super impose

[dynagirl]

can you super impose a letter over the center of a block of four cells? The 4
cells are also set up as a dotted line grid.

[EdMac]

You can chose 'centre over selection' in the alignment section of cell formatting - does this help?

ed

[Kernow Girl]

Yes - highlight the cells and click on the Merge and Center icon on the
toolbar. Then to Format/Cells/Alignment and change the Vertical to Centre.

"dynagirl" wrote:

> can you super impose a letter over the center of a block of four cells? The 4
> cells are also set up as a dotted line grid.

[dynagirl]

tried - center across top 2 but not the bottom 2cells. Thanks
"EdMac" wrote:

>
> You can chose 'centre over selection' in the alignment section of cell
> formatting - does this help?
>
> ed
>
>
> --
> EdMac
> ------------------------------------------------------------------------
> EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
> View this thread: http://www.excelforum.com/showthread...hreadid=531536
>
>

[dynagirl]

I tried vertical center & center across selection and the horizontal center,
It only centers across the top 2 cells instead of the connectign 4 center
corners. Thanks

"Kernow Girl" wrote:

> Yes - highlight the cells and click on the Merge and Center icon on the
> toolbar. Then to Format/Cells/Alignment and change the Vertical to Centre.
>
> "dynagirl" wrote:
>
> > can you super impose a letter over the center of a block of four cells? The 4
> > cells are also set up as a dotted line grid.

[Kernow Girl]

Hi - make sure you highlight all 4 cells, then use Merge and Centre. After
that you can centre vert and horiz, but the cells have to be merged first.

"dynagirl" wrote:

>
> I tried vertical center & center across selection and the horizontal center,
> It only centers across the top 2 cells instead of the connectign 4 center
> corners. Thanks
>
> "Kernow Girl" wrote:
>
> > Yes - highlight the cells and click on the Merge and Center icon on the
> > toolbar. Then to Format/Cells/Alignment and change the Vertical to Centre.
> >
> > "dynagirl" wrote:
> >
> > > can you super impose a letter over the center of a block of four cells? The 4
> > > cells are also set up as a dotted line grid.