Formatting Problem

D

Dudley Wright

I have a workbook with 9 worksheets. All but one of them are used to
track different company projects, one is used for summary: various
counts and sums. On the summary sheets, the individual project are
separated by two blank rows. The summary data was formatted with
borders.
I need to remove the borders, which is easy to do. The problem is
that when all the borders are removed, vertical "lines" remain that
span many rows, between several columns. Removed gridlines, with no
effect.
These are not drawn objects.
Does anyone have an idea how to remove this?

Thanks
Dudley
 
D

Debra Dalgleish

Could the lines be controls that have been squished?

Choose View>Toolbars, and select the Control Toolbox
Click the Design Mode button
Choose Edit>Go To
Click Special
Select Objects, click OK
Press the Delete key, to delete any objects
Click the Design Mode button on the Control toolbox
Close the Control toolbox
 
D

Dudley Wright

Debra
Right on. That was a great call. That would have taken me weeks of
research to figure out, if ever, given the fact that I have rarely
worked with controls in Excel and then limited to check boxes.
Many thanks.
Dudley
 
Top