Can't edit cells in my rectangle

  • Thread starter Thread starter Laurel
  • Start date Start date
L

Laurel

I have an old spreadsheet with several rectangles on it. The rectangles are
"hollw", in that I can edit cells inside them. I can copy those rectangles
and edit them to make new ones. But if I create a new one from the Drawing
toolbar, the cells inside are inaccessible. Instead, it acts like a big
text box. How can I create those "empty" rectangles from scratch?
 
Try: Right-click on a new rectangle > Add Text

Alternatively, draw / use a text box instead of the rectangle autoshape
 
Laurel, for any new rectangle you create, right-click the border and select
Format AutoShape -> Colors and Lines -> Color: No Fill. That will give you
access to the cells inside. Note that as an alternative to rectangles, you
might want to use cell borders.

DDM
"DDM's Microsoft Office Tips and Tricks"
http://ddmara.tripod.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top