View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
shaunap
 
Posts: n/a
Default Typewriter Effect

The best way to achieve this is to merge the cells from A31 to H35 and unlock
the cells to allow editing. (as Huber57 suggested in his second part).

Shauna

"Skydiver" wrote:

You're thinking just like me. I failed to mention that I did use a floating
text box, however I've unlocked certain cells and have protected the sheet so
this does not allow me to type any text into the floating text box.

"Huber57" wrote:

Unless you need the data in a cell (and since it sounds like text, I would
think not), how about a text box that is sized appropriately but is
"floating" above the cells you want to have text within?

If you need it in one big text box you can highlight them all and merge the
cells.

Hope this helps.


"Skydiver" wrote:

I have a range from A31 to H35. In this range I would like to type text
beginning in A31 up until the H31 area. Upon reaching this area I would like
to continue typing without exceeding the H31 area, thus continuing in A32 all
the way until H35. Is this possible? Help.

John