Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-18-2017, 01:57 AM
Muncey Muncey is offline Windows 8 Office 2016
Novice
 
Join Date: Jul 2017
Posts: 1
Muncey is on a distinguished road
Default Locked Area Creating A Line Down The Collumn Of The Spreadsheet

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?


Reply With Quote
  #2  
Old 07-18-2017, 05:43 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
A Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 121
NBVC is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 06:47 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft