View Single Post
  #1   Report Post  
Leo
 
Posts: n/a
Default How do I display textboxes without any content in a spreadsheet?

I have an Excel workbook that is extremely slow in opening up and saving. It
freezes up when I try to resize it and there is a time-lag when I scroll
within certain worksheets. There are about 7 sheets within the workbook.
Now, it came to my notice that some of the spreadsheets have many text boxes
without any content in them. As a result, they are invisible until you click
on them.

My question is: Is there a way where I can have the spreadsheet show all the
text boxes or a way that I could just delete all of them at once?

Or if you think that there might be another alternative please advise.

Thanks,
Leo