software

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.


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

ed--
EdMac
------------------------------------------------------------------------
EdMac's Profile: www.excelforum.com/member.php...oamp;userid=30736
View this thread: www.excelforum.com/showthread...hreadid=531536Yes - 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.

quot;dynagirlquot; wrote:

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


tried - center across top 2 but not the bottom 2cells. Thanks
quot;EdMacquot; wrote:

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


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

quot;Kernow Girlquot; wrote:

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

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.

quot;dynagirlquot; wrote:

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