PDA

View Full Version : Excel - text at top, not bottom of a cell



Strommer
05-06-2008, 08:29 AM
Within a cell (a paragraph area of merged columns, about 3 cm height) when I start typing text, the text appears at the bottom of the cell. How do I get it to start back up at the top?

pctek
05-06-2008, 08:38 AM
Alignment. Format - cells, Alignment, change Vertical to top.

Strommer
05-06-2008, 08:45 AM
Alignment. Format - cells, Alignment, change Vertical to top.

Thanks for QUICK reply, but there is no Alignment tab under the Format menu. Excel Help says that there should be an Alignment tab, but: [Format > Cells] only brings up a Font tab.

I am using Excel 2002.

Strommer
05-06-2008, 09:51 AM
Screenshot showing that Alignment Tab is not present, also shows text at bottom of cell.
http://www.imagef1.net.nz/files/Excel.jpg

the_bogan
05-06-2008, 09:57 AM
You'll have to do that when the cell(s) are not active. (e.g halfway through typing)

Strommer
05-06-2008, 10:19 AM
You'll have to do that when the cell(s) are not active. (e.g halfway through typing)

Thanks - that did it. Dunno - thought I tried the inactive option but guess not.

Here is another simple question:
How do I close this cell that has a missing vertical line (see screenshot, the cell has a missing boundary on the right side).
http://www.imagef1.net.nz/files/Excel_2.jpg

the_bogan
05-06-2008, 10:56 AM
Try playing with the border tab in format Cells. (CTRL 1 to get there quickly)

Strommer
05-06-2008, 11:02 AM
Try playing with the border tab in format Cells. (CTRL 1 to get there quickly)

:thumbs: Thanks again ! :D

pctek
05-06-2008, 12:34 PM
there is no Alignment tab under the Format menu.

Alignment. Format - cells, Alignment, change Vertical to top.

Strommer
06-06-2008, 06:42 AM
Alignment. Format - cells, Alignment, change Vertical to top.

PCT, this did not work. When I tried Format > Cells, there was no Alignment tab - I posted this above, with a screenshot.

The problem was that the cell had to be inactive, as the_bogan pointed out.