SOLVED

Not Showing Gridlines

%3CLINGO-SUB%20id%3D%22lingo-sub-2616692%22%20slang%3D%22en-US%22%3ENot%20Showing%20Gridlines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2616692%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20using%20a%20spreadsheet%20and%20have%20set%20it%20to%20NOT%20display%20any%20gridlines%2C%20when%20locking%20the%20top%20row%2C%20there%20is%20a%20horizontal%20line%20that%20is%20still%20visible.%26nbsp%3B%20How%20can%20I%20get%20the%20line%20to%20NOT%20show%20when%20locking%20the%20top%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20is%20not%20possible%2C%26nbsp%3BI%20would%20like%20to%20submit%20an%20enhancement%20request%20to%20have%20excel%20updated%20to%20not%20show%20ANY%20lines%20when%20%E2%80%9CGridlines%E2%80%9D%20has%20been%20unselected.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2616692%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2616755%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20Showing%20Gridlines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2616755%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1121567%22%20target%3D%22_blank%22%3E%40jguymon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20mean%20the%20Freeze%20Panes%20feature%2C%20that%20line%20indicates%20which%20part%20of%20the%20sheet%20is%20%22frozen%22.%3C%2FP%3E%0A%3CP%3EI%20don't%20think%20Microsoft%20would%20be%20willing%20to%20implement%20your%20request.%20It%20would%20be%20very%20confusing%20for%20users%20not%20to%20be%20able%20to%20see%20which%20rows%20and%2For%20columns%20have%20been%20frozen%20(if%20any).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2617145%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20Showing%20Gridlines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2617145%22%20slang%3D%22en-US%22%3EThanks%20for%20your%20reply%20as%20to%20what%20you%20think%20Microsoft%20are%20or%20are%20not%20willing%20to%20do.%20I%20would%20like%20to%20get%20an%20enhancement%20request%20submitted%20to%20them%20to%20actually%20follow%20their%20own%20features.%20In%20this%20example%20when%20Gridlines%20are%20unselected%20then%20ALL%20gridlines%20or%20any%20other%20lines%20should%20not%20be%20visible.%20As%20far%20as%20those%20who%20may%20be%20confused%2C%20we%20can't%20control%20or%20should%20speculate%20on%20how%20they%20may%20or%20may%20not%20react.%20It%20would%20be%20great%20if%20we%20as%20users%20could%20actually%20control%20what%20we%20do%20and%20do%20not%20see%20regarding%20lines.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2617268%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20Showing%20Gridlines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2617268%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1121567%22%20target%3D%22_blank%22%3E%40jguymon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20submit%20your%20suggestion%20through%20File%20%26gt%3B%20Feedback%20%26gt%3B%20Send%20a%20Suggestion%20in%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2617273%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20Showing%20Gridlines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2617273%22%20slang%3D%22en-US%22%3EPerfect!%20That%E2%80%99s%20what%20I%20asked%20for%20in%20the%20first%20place%2C%20but%20was%20directed%20to%20the%20community%20instead%20of%20the%20answer.%20%3Asmiling_face_with_smiling_eyes%3A%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2633781%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20Showing%20Gridlines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2633781%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20what%20to%20do%20with%20this%20but%20let%20me%20explain%20it%20and%20maybe%20you%20can%20either%20forward%20this%20to%20the%20correct%20person%20or%20let%20me%20know%20who%20to%20contact.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20received%20an%20email%20today%20asking%20me%20if%20I%20got%20the%20answer%20I%20needed.%26nbsp%3B%20I%20replied%20that%20I%20did%20not%2C%20but%20was%20directed%20to%20the%20correct%20place%20to%20submit%20an%20enhancement%20request.%26nbsp%3B%20I%20then%20received%20a%20message%20that%20my%20email%20reply%20was%20blocked%20for%20spam%20with%20a%20useless%20message%20on%20how%20to%20fix%20it.%26nbsp%3B%20What%20is%20there%20to%20fix%3F%20It%20was%20one%20simple%20email%20reply.%26nbsp%3B%20In%20the%20email%20was%20a%20link%20for%20%22Was%20this%20helpful%3F%20Send%20feedback%20to%20Microsoft%22%2C%20so%20I%20attempted%20to%20use%20the%20link%20so%20I%20can%20send%20feedback%2C%20but%20now%20got%20message%20that%20the%20page%20I%20was%20looking%20for%20can't%20be%20found.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20let%20me%20know%20who%20I%20should%20report%20this%20too%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jguymon_1-1628627346346.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F302237i8A5D5DCCFECDEE35%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jguymon_1-1628627346346.png%22%20alt%3D%22jguymon_1-1628627346346.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jguymon_2-1628627357448.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F302238i6F553A492B7D0793%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jguymon_2-1628627357448.png%22%20alt%3D%22jguymon_2-1628627357448.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jguymon_3-1628627395332.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F302239iFE85F12149E37EA4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jguymon_3-1628627395332.png%22%20alt%3D%22jguymon_3-1628627395332.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20all%20the%20help%20you%20give%20us%20in%20the%20Excel%20community!%26nbsp%3B%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2633800%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20Showing%20Gridlines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2633800%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1121567%22%20target%3D%22_blank%22%3E%40jguymon%3C%2FA%3E%26nbsp%3Bthat's%20better%20to%20publish%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fcommunity-lounge%2Fct-p%2FCommunity-Info-Center%22%20target%3D%22_blank%22%3ECommunity%20Lounge%20-%20Microsoft%20Tech%20Community%3C%2FA%3E%26nbsp%3Bor%20report%20to%20techcommunity%40microsoft.com%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2633801%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20Showing%20Gridlines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2633801%22%20slang%3D%22en-US%22%3EThanks!%3C%2FLINGO-BODY%3E
Occasional Contributor

When using a spreadsheet and have set it to NOT display any gridlines, when locking the top row, there is a horizontal line that is still visible.  How can I get the line to NOT show when locking the top row.

 

If this is not possible, I would like to submit an enhancement request to have excel updated to not show ANY lines when “Gridlines” has been unselected.

14 Replies

@jguymon 

If you mean the Freeze Panes feature, that line indicates which part of the sheet is "frozen".

I don't think Microsoft would be willing to implement your request. It would be very confusing for users not to be able to see which rows and/or columns have been frozen (if any).

Thanks for your reply as to what you think Microsoft are or are not willing to do. I would like to get an enhancement request submitted to them to actually follow their own features. In this example when Gridlines are unselected then ALL gridlines or any other lines should not be visible. As far as those who may be confused, we can't control or should speculate on how they may or may not react. It would be great if we as users could actually control what we do and do not see regarding lines.

@jguymon 

You can submit your suggestion through File > Feedback > Send a Suggestion in Excel.

Perfect! That’s what I asked for in the first place, but was directed to the community instead of the answer.

@Hans Vogelaar 

 

I'm not sure what to do with this but let me explain it and maybe you can either forward this to the correct person or let me know who to contact.

 

I received an email today asking me if I got the answer I needed.  I replied that I did not, but was directed to the correct place to submit an enhancement request.  I then received a message that my email reply was blocked for spam with a useless message on how to fix it.  What is there to fix? It was one simple email reply.  In the email was a link for "Was this helpful? Send feedback to Microsoft", so I attempted to use the link so I can send feedback, but now got message that the page I was looking for can't be found.

 

Can you let me know who I should report this too?

 

jguymon_1-1628627346346.png

 

 

jguymon_2-1628627357448.png

 

 

jguymon_3-1628627395332.png

 

 

Thanks for all the help you give us in the Excel community! 

 

 

 

 

 

@jguymon that's better to publish here Community Lounge - Microsoft Tech Community or report to techcommunity@microsoft.com

Thanks!
You can copy the content to new Excel file.
I'm sorry, but what does copying the content to a new Excel file have to do with making sure that ALL the gridlines are not showing when locking the top row?
You could always stop using freeze panes if you do not like seeing the visible cues that indicate such panes. If you use Tables, names of the columns then appears in place of the sheet column number (normally represented by a strange sequence of letters so there is much scope for improvement)

I need the top row to be fixed. I keep all my macro buttons on the top row and do not want ANY lines shown unless I activate them myself. If I can't hide the line, how can I change the line color?  Regarding the macro buttons,  I set the button to "Don't move or size with cells", but when I scroll the page the button moves.

best response confirmed by jguymon (Occasional Contributor)
Solution

@jguymon 

I think you are out of luck; if you need to freeze the first row, Excel will show the border.  It is possible to use the ribbon as an alternative means of control, either with xml or by using an add-in such as

Home (ribboncommander.com)

Otherwise you could always format the 'button bar' and pretend you actually wanted the feature!

image.png

I'll make that work and let this "beat to death" issue go away.

Thanks for the help!