Microsoft Office Forums Locked Area Creating A Line Down The Collumn Of The Spreadsheet

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-18-2017, 01:57 AM
Muncey Muncey is offline Locked Area Creating A Line Down The Collumn Of The Spreadsheet Windows 8 Locked Area Creating A Line Down The Collumn Of The Spreadsheet Office 2016
Novice
Locked Area Creating A Line Down The Collumn Of The Spreadsheet
 
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 Locked Area Creating A Line Down The Collumn Of The Spreadsheet Windows 10 Locked Area Creating A Line Down The Collumn Of The Spreadsheet Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 202
NBVC will become famous soon enough
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
Locked Area Creating A Line Down The Collumn Of The Spreadsheet Creating Invoices using data from a spreadsheet tjcusick Excel Programming 3 12-05-2013 08:36 AM
Locked Area Creating A Line Down The Collumn Of The Spreadsheet Creating a list in Word from an Excel spreadsheet gingernut Mail Merge 1 03-19-2013 02:12 PM
Locked Area Creating A Line Down The Collumn Of The Spreadsheet Creating multiple emails from a spreadsheet StephenGreen1985 Excel 1 05-04-2011 07:03 PM
Locked Area Creating A Line Down The Collumn Of The Spreadsheet Creating a spreadsheet nickypatterson Excel 1 01-14-2010 03:21 PM


All times are GMT -7. The time now is 05:16 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft