ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   super impose (https://www.excelbanter.com/excel-discussion-misc-queries/82449-super-impose.html)

dynagirl

super impose
 
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

super impose
 

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


Kernow Girl

super impose
 
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

super impose
 

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

super impose
 

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

super impose
 
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.



All times are GMT +1. The time now is 10:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com