ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I create a text on the left or right like a header & footer (https://www.excelbanter.com/excel-discussion-misc-queries/128439-can-i-create-text-left-right-like-header-footer.html)

charles

Can I create a text on the left or right like a header & footer
 
I'm trying to create a 10 x 10 (100 squares) for my Superbowl pool. One team
goes on the left side, while the other goes on the top. I need to create the
text for these.

Gord Dibben

Can I create a text on the left or right like a header & footer
 
Charles

Since this is designed just for printing, I will suggest "merged cells"

Select B1:K1 and FormatCellsAlignmentHorizontalCenter across selection.

Enter Colts.

Select A2:A11 and FormatCellsAlignmentMerge Cells.

Enter Chicago.

FormatCellsAlignmentOrientationText

Resize rows and columns to suit.


Gord Dibben MS Excel MVP

On Tue, 30 Jan 2007 15:00:00 -0800, charles
wrote:

I'm trying to create a 10 x 10 (100 squares) for my Superbowl pool. One team
goes on the left side, while the other goes on the top. I need to create the
text for these.




All times are GMT +1. The time now is 12:05 AM.

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