excel data on a line not in a cell

June 19, 2011 at 14:46:08
Specs: Windows XP
Hi There - Help please - i am creating a schedule in excel and when i write the time it goes into a cell. - that's fine but people don't seem to get the fact that the 8am meeting starts at the top line of the cell and finishes at the bottom line... i was wondering for clarity, can i put 8am,9am 10am etc next to the line that indicates the start of the meeting. sorry to be pedantic. Please help.

many thanks

Jim


See More: excel data on a line not in a cell

Report •


#1
June 19, 2011 at 14:53:49
top line of the cell

Are you splitting the cell in some manner?

Unless your formatting the cell using Wrap Text, not sure what your talking about.

MIKE

http://www.skeptic.com/


Report •

#2
June 20, 2011 at 01:08:01
hi mike - sorry not explaining myself super clearly - as usual the data goes into a cell - i just want the data to sit on the top line of the cell - thus it would look like the line of the top of the cell actually runs under the data. not in the gap (Cell) underneath the line.

any better?Jim


Report •

#3
June 20, 2011 at 03:00:52
thus it would look like the line of the top of the cell actually runs under the data

Can not do it quite like that.
Best I can offer is try this:

On the Task Bar/Ribbon
Select the Home Tab
Select Format
Select Format Cells (at the bottom)
Select Alignment Tab
In the box titled Vertical
Change Bottom to Top

That should do something like what your looking for.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
June 20, 2011 at 03:50:52
Think about what you are asking for.

The top line of the cell defines the upper border of the cell.

If the top line of the cell is under the data, then the data can't be in the cell.

Compare it to your house. The roof defines the top border of your house.

If the roof was underneath you, you wouldn't be in the house.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •


Ask Question