Vertical Text to straddle grid lines

[tim_james79]

Is there any way to get text in say row 1 to appear as though it is over the line of the cells in row 2?
A B
i.e row 1 C| |...
... row 2 | |...

Hope this makes sense
Cheers
Tim.
This message was edited by tim_james79 on 2002-08-28 14:10

 

[Derek]

Hi there Tim, welcome to the Board.

Yes, you can give this "appearance".
Try the following:
1. Type "My text" in a say cell G7.
2. Turn off gridlines (Tools/Options/View/Gridlines)
3. Select G7
4. Hold down Shift and select Edit from your toolbar.
5. Select Copy Picture
6. Select H10, hold down Shift and select Paste Picture.
7. Turn gridlines back on.
8. Click on your picture and move it over
your gridlines. (if you doubleclick your picture you can edit it - remove lines if it has a border etc)
9 Protect this object by protecting your sheet and selecting the objects box.

If you want this text picture to update whenever the original text in G7 is altered, use the camera icon to take the picture (customise toolbars under Tools)

Hope this gives you some ideas
regards
Derek

 

[Todd Bardoni]

Wow! I never knew that holding down the shift key you could copy as a picture! What else can Excel do...where do you find these little tricks because they sure aren't talked about much. I gotta know.

 

[PaddyD]

here

 

[Derek]

Hi
Keep reading this Board. There's a lot of clever people contributing here, (and anything I post was probably learned from other posters)
have fun
regards
Derek

 

[RichardS]

You could also merge the cells, and align the text vertically, that way it remains "live" text. Not sure which version that started in. I'm on 2000.

Richard