Locked Area Creating A Line Down The Collumn Of The Spreadsheet

Muncey · #1 07-18-2017, 01:57 AM

As pictured below, the area from "Grade" to the left is locked in place however it has created a line that goes down the entire length of the spreadsheet and goes straight through graphs.

Could someone tell me how I could remove this?

NBVC · #2 07-18-2017, 05:43 AM

I don't think you can. That line is there to show where the "freeze pane" is set. The only to remove it, is to remove the "freeze pane" option.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a master spreadsheet for sorting information	Notsonerdy	Excel Programming	8	05-31-2016 04:39 AM
Creating Invoices using data from a spreadsheet	tjcusick	Excel Programming	3	12-05-2013 08:36 AM
Creating a list in Word from an Excel spreadsheet	gingernut	Mail Merge	1	03-19-2013 02:12 PM
Creating multiple emails from a spreadsheet	StephenGreen1985	Excel	1	05-04-2011 07:03 PM
Creating a spreadsheet	nickypatterson	Excel	1	01-14-2010 03:21 PM