Ask Your Question

Worksheet help

asked 2018-12-08 14:36:07 +0100

Dumbbunny gravatar image

Hi, What are the 5 squares and minus signs above my column headers for and how do I get rid of them. C:\fakepath\Screen Shot 2018-12-08 at 5.25.49 AM.png

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-12-08 15:09:34 +0100

BigRAl gravatar image

You have grouped cells in column H.

To remove the groups, hit Ctrl+F12 four times until the group markers disappear.

edit flag offensive delete link more


Thanks for your answer. Ctrl+F12 didn't work for me (I have PC keyboard and a Mac mini) so I found Data>Group and Outline and ungrouped four times.

I still have two small squares left to delete but can't figure out how.

Dumbbunny gravatar imageDumbbunny ( 2018-12-08 15:29:22 +0100 )edit

I just figured out how to remove the tiny numbered squares - Data>Groups and Outline>Remove Outline

Dumbbunny gravatar imageDumbbunny ( 2018-12-08 15:33:46 +0100 )edit

You are right, of course.

I should have mentioned the menu alternative in my answer - sorry.

BigRAl gravatar imageBigRAl ( 2018-12-08 15:59:44 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-08 14:36:07 +0100

Seen: 23 times

Last updated: Dec 08 '18