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
 
Back
Top