+ Reply to Thread
Results 1 to 2 of 2

Cell outline showing up at start of 2nd page

  1. #1
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,662

    Cell outline showing up at start of 2nd page

    Hi, i have a worksheet where at the last row on the first page has cell outlines on the top and bottom. For some reason the cell outline seems to have gone to the top of the 2nd page......not sure why. You can see this when you go to print preview.

    Not sure how to fix this. i tried playing with the cell outlines and this did not help so now i am thinking maybe its somethign else but i just dont know.

    Any thoughts?
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,662

    Re: Cell outline showing up at start of 2nd page

    so i think ifixed it.....initial testing looks good but have to do more.

    Turns out the problem is this (so i think....): You have a row of cells (lets say this row is Y) as the last row on a page. This row (Y) of cells has a border around it.
    This row has top, bottom, right and left borders. The row below (Y+1) turns out also has boarder but only "Top". So what i did was select row Y of cells. Then i removed the
    BOTTOM border from this row. THen i went and added the bottom only border. What i think (i say think) was happening was i had a bottom border in one cell and for the cell below
    i had a top boarder. So if you can remove the top border and only have the bottom border it should work.

+ 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. Repeating the header at the start of each page with the page number
    By Viswateja in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2017, 02:17 PM
  2. Showing bars that does not start from zero
    By eustechin in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-19-2017, 02:09 AM
  3. [SOLVED] Vba code to start page numbers from current page (bottom of the pate right side)
    By satputenandkumar0 in forum Word Formatting & General
    Replies: 2
    Last Post: 04-04-2014, 01:09 AM
  4. Stop/Start charcters and showing 0's
    By Plazma in forum Excel General
    Replies: 5
    Last Post: 09-19-2013, 05:21 PM
  5. [SOLVED] Make page numbering start on Page 2
    By The Skipper in forum Excel General
    Replies: 2
    Last Post: 01-15-2013, 01:16 AM
  6. Format page number in excel footer to start at a specific page #
    By straitctrydncr in forum Excel General
    Replies: 3
    Last Post: 04-11-2006, 08:00 AM
  7. only last cell on page to have bottom border (cell area outline)
    By Wiggum in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-29-2005, 11:06 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