Ask Your Question

Make hidden rows & columns more visible

asked 2019-10-17 12:53:43 +0100

ChameleonScales gravatar image

The title seems antinomic but what I mean is that I'd like to make it more evident that rows or columns are hidden by displaying a thicker or colorized line separation directly on the sheet, rather than just having the header separators get thicker. Is that possible ?

edit retag flag offensive close merge delete


Hello - Have you ever thought of using Data - Group and Outline -> Group, which is adding an indication character (=toggle button) (+ and -) left to the row numbers / above columns to indicate hidden or shown rows / columns, could support your intention?

If this does not fit into your requirements, you are welcome to file a feature request at

Opaque gravatar imageOpaque ( 2019-10-17 13:09:03 +0100 )edit
ChameleonScales gravatar imageChameleonScales ( 2019-10-20 01:02:06 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-10-19 16:09:58 +0100

Sumner gravatar image

Change the border style of the column or row next to it.

edit flag offensive delete link more


Thanks for the idea but that's highly impractical for me. I use the hide feature quite frequently and also use border styling in my sheets so this would add too many operations to perform in my workflow.

ChameleonScales gravatar imageChameleonScales ( 2019-10-20 03:34:48 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-10-17 12:53:43 +0100

Seen: 136 times

Last updated: Oct 19 '19