Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 07-18-2017, 01:57 AM
Muncey Muncey is offline Windows 8 Office 2016
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
Old 07-18-2017, 05:43 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 199
NBVC is on a distinguished road

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

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 05:05 PM.

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