Articles

Title on Excel Spreadsheet

March 11, 2010 at 08:26:00
Specs: Windows 7

How do I add a title to a Spreadsheet? I tried to add a title but I can't get the cells stay the same size in the title if I change the size of the cell below it. When I expand the cell below it, the cell that contains the title also expands and distorts the title.

See More: Title on Excel Spreadsheet

Report •


#1
March 11, 2010 at 08:32:12

Have you tried a Custom Header?

http://office.microsoft.com/en-us/e...


Report •

#2
March 11, 2010 at 08:33:44

Hi,

What exactly happens. You say the title 'distorts'. Do the characters in the text change shape, or are you putting an image in the cell that gets stretched.

Have you merged some cells to make room for the title.

Regards


Report •

#3
March 11, 2010 at 09:23:12

I am putting words in a cell that get's stretched. Nothing is happening to the text itself. I can't use a header because in the first cell is an image the second cell contains text and the third cell contains a button with a macro. Below is a table that has data that is collapsed but when it expands the cells in the title that I describe above get stretched.

Report •

Related Solutions

#4
March 11, 2010 at 09:23:57

Oh and yes I have merged cells to make the title.

Report •

#5
March 11, 2010 at 11:07:51

Hi,

As you are having trouble with text in a cell or merged cells, how about putting your title text into a text box, and setting the text box to not change size with the cells.

From the Ribbon select Insert, then Text and the 'Text Box'.

Draw the text box to the required size and shape.

Enter the text then select the text to choose font, font size and font color.
Right-click on the text box outline and select 'Size and properties'
In the Properties tab choose 'Don't move or size with Cells' Click OK

You can also right-click the text box outline and select 'Format Shape' to adjust the outline - line color, 3D effects etc.

Hope this does what you want.

Regards


Report •

#6
March 11, 2010 at 14:04:52

So that solution works for the text and pictures however when I try to add a button with a macro written I can't get it to paste inside the text box. Is there a way to do this where I can paste a button with a marco and not have it stretch when I resize the columns underneath?

Report •

#7
March 11, 2010 at 14:13:59

Hi,

I don't have Excel 2007 on this PC, so I can't give you exact instructions, but you can do the same with a button as you did with the text box, so that it does not change size.

Right-click the button and look for something like 'Format Control' and look for a Properties Tab. Select 'Don't move or size with Cells'

Regards


Report •

#8
March 11, 2010 at 14:18:53

It worked!! you are awesome!! thanks so much! :)

Report •

#9
March 11, 2010 at 14:48:29

You're welcome.

Regards

Humar


Report •


Ask Question