numbered squares top left corner of spreadsheet

M

Michel Maksoud

I received a spreadsheet that has three numbered squares
(1, 2 & 3) in the top left corner of a worksheet.
Pressing the squares seems to only hide and unhide rows.
There is no help available for them using SHIFT-F1. Right
click on that area produces nothing. There are no macros
in the workbook. There are no custom view. Can somebody
tell me what those squares are and how to get rid of them?
 
D

Dave Peterson

They could have been put there by Data|subtotals, too.

If that's what did it and you want to keep the subtotals, but lose the
outlining, you can hide them.

Tools|options|View tab|Outline symbols.

If they're from data|subtotals, it's a nice way to see those subtotal rows
(uncluttered by the details).
 

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

Similar Threads

How to get rid of embedded grey squares over cells 2
Clicking on numbered boxes, plus and minus sign to show and hide d 1
Edit / Enter sign in lower left hand corner of spreadsheet 6
My spreadsheet only appears in the top left of the page. 1
green mark in the top left corner of cells 4
Cannot unhide the hidden rows in my spreadsheet 3
How do I get rid of a backround image? 2
what are the little black squares to the left of some of lines of 1

Top