+ Reply to Thread
Results 1 to 4 of 4

Freezing Panes

  1. #1
    Forum Contributor
    Join Date
    11-23-2013
    Location
    San Diego
    MS-Off Ver
    Excel 2013
    Posts
    457

    Freezing Panes

    Is there an option when freezing panes to not have that line show on the worksheet where the panes are officially frozen. I want the panes frozen just not with the black line showing. Thanks!

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,053

    Re: Freezing Panes

    You can add black border to cells so you won't see where a panes frozed
    Never use Merged Cells in Excel

  3. #3
    Forum Contributor
    Join Date
    11-23-2013
    Location
    San Diego
    MS-Off Ver
    Excel 2013
    Posts
    457

    Re: Freezing Panes

    Quote Originally Posted by zbor View Post
    You can add black border to cells so you won't see where a panes frozed
    I'm talking about the black line that runs vertically to the top of the worksheet all the way to the bottom.

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,053

    Re: Freezing Panes

    I know. I'm not sure it can dissapear but you can mask it by creating all cells to have border of same ticknes.

    Something like this
    Last edited by zbor; 01-16-2014 at 08:18 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Freezing Panes within panes already frozen...
    By jpcsolutions in forum Excel General
    Replies: 1
    Last Post: 12-12-2011, 03:24 PM
  2. freezing panes...
    By cstanyer in forum Excel General
    Replies: 4
    Last Post: 01-16-2009, 11:58 AM
  3. Freezing panes?
    By addylad in forum Excel General
    Replies: 3
    Last Post: 06-12-2008, 09:36 AM
  4. [SOLVED] Freezing Panes
    By JB in forum Excel General
    Replies: 1
    Last Post: 10-22-2005, 10:05 AM
  5. Freezing panes
    By LAF in forum Excel General
    Replies: 1
    Last Post: 09-16-2005, 10:56 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1