AnswerBun.com

Remove outline/page border in Microsoft Excel

How do I hide the outside grid lines (at the edges of my data header) in Microsoft Excel?

I need to have gridlines print/view ON for the rest of the data. I can hide some gridlines in my header, by filling the cells with white color, but I cannot get rid of the grid lines on the outside edges (Top Left, Top, Top right). Basically I always have a line/box around my data header.

I have tried changing the line color to white but it does not work. I changed the line color to green. You see a green line on top of a black line.
Any ideas?

Super User Asked on December 30, 2020

1 Answers

One Answer

I have Excel 2010

  1. Click on the Office button in the top left corner.

  2. Select the Excel Options button at the bottom right side of the Office menu.

  3. Select Advanced in the left column. Scroll down to the Display Options for this Worksheet section. Uncheck the box. Click OK.

enter image description here

Answered by 0m3r on December 30, 2020

Add your own answers!

Related Questions

Clonezilla not enough free memory

2  Asked on December 16, 2021 by furjoza

 

An operating system wasn’t found

4  Asked on December 16, 2021

   

Sorting XML having xsd format using xslt

1  Asked on December 16, 2021 by harshi

   

Lower FPS than expected on laptop

1  Asked on December 16, 2021 by bobleeswagger

       

VLC Player Mac View Playlist Keyboard Shortcut

1  Asked on December 16, 2021 by operation420-net

     

Weird Windows 10 Update bug/glitch

0  Asked on December 16, 2021 by rakib-hasan

   

Virtual box shared folder is not mounted in guest

1  Asked on December 13, 2021 by whitecolor

 

Ask a Question

Get help from others!

© 2022 AnswerBun.com. All rights reserved.