Adding a text label to a worksheet

[vivo4]

Back again! I have a worksheet which that genius, Andy Brown from the UK, helped me create. You're the greatest Andy. Only problem is, it has no space at all or even as a row across the top for me to label the worksheet with my organization's name, my name, and the month and year. Can anyone help? I've tried embedding the worksheet into a Word document containing the above-noted info and, after about 20 tries, I finally got my mind around the terminology used. Unfortunately, the result was a microscopic version of the entire workbook (not just the sheet I wanted) embedded into the Word document. Since then, I've been unable to duplicate even that sorry outcome. Help! I need this for the office on Monday
Thanks for any help
Mark

 

[Andy Brown]

Hi Mark.

You should stick to the original thread rather than start a fresh one, or
stuff gets confusing.

1. Unprotect the sheet if necessary (Tools -- Protection).

2. Select cell A1.

3. Rightclick and Insert -- Entire Row.

Rgds,
Andy

 

[vivo4]

Thanks again, Andy. Sorry about starting a new thread, but frankly, I thought it was a different problem. Anyway, I finally was able to insert a row at the top and change its height so I could get more than one line of text in there. However, everytime I try to type text into the new large cell across the top, it won't allow me to move text into 3 lines (which is what I want) like this
Vancouver MP
Mileage Claim For
Month/Year: __________ Program: _________ Employee: ____________
(all three lines of text centred at the top of the worksheet
I can't seem to get it to simply highlight the row. The row number indicator to the left goes black and almost every potential formatting option becomes unavailable. I have done a word wrap for the row yet I still have to hit the spacebar countless times to get the text onto 3 lines. When I check that out in print preview, a dog's breakfast of text comes up with Vancouver etc crushed to the far left and the balance pushed off the far right margin so it's obviously not working. It's determined to only allow me to type one row's worth of text in that cell at the top. Any suggestions?
Thanks
Mar

 

[Andy B]

vivo

If you want to insert a line break into a cell use Alt and Enter. Type the
first line of information, then hold Alt and press Enter. This will start
you on a fresh line in the same cell.

Andy.

Thanks again, Andy. Sorry about starting a new thread, but frankly, I

thought it was a different problem. Anyway, I finally was able to insert a
row at the top and change its height so I could get more than one line of
text in there. However, everytime I try to type text into the new large
cell across the top, it won't allow me to move text into 3 lines (which is
what I want) like this:

Vancouver MPA
Mileage Claim Form
Month/Year: __________ Program: _________ Employee: _____________
(all three lines of text centred at the top of the worksheet)
I can't seem to get it to simply highlight the row. The row number

indicator to the left goes black and almost every potential formatting
option becomes unavailable. I have done a word wrap for the row yet I still
have to hit the spacebar countless times to get the text onto 3 lines. When
I check that out in print preview, a dog's breakfast of text comes up with
Vancouver etc crushed to the far left and the balance pushed off the far
right margin so it's obviously not working. It's determined to only allow
me to type one row's worth of text in that cell at the top. Any
suggestions??

 

[vivo4]

Okay, Andy. Got that and it seems to work. Good trick to
know. However (there's always a however), when I do that
the row appears to maintain its original size and anything
I type in subsequent lines within the row is lost,
although it appears on the screen. The formula box gets
larger and larger so that it covers the top of the
worksheet and I'm unable to see what's actually appearing
in that row of the worksheet.
Mark

 

[Andy Brown]

Hi Mark.

I explained how to insert a row & assumed that you'd insert more if
required. Andy B pointed out an option I neglected (hopefully that will kill
off the 'genius' tag).

You can click & drag the borders between row headers (the "1", "2", etc.
numbers) and column headers ("A", "B", etc.) to change widths. You may be
able to doubleclick them to AutoFit.

To prevent the formula bar spilling onto the worksheet, select the offending
cell(s). Select Cells from the Format menu. On the Protection tab, check
Hidden. Click OK. This feature kicks in when you protect the worksheet.

Rgds,
Andy

 

[Andy B]

vivo

Whatever you type into the cell won't be 'lost', but you may not be able to
see it if the cell is not wide enough or deep enough. Either increase the
column width or the row height to see what is there. If you need to see the
formula bar, you can always get rid of it by Clicking on View / Formula Bar.

Andy.