Results 1 to 2 of 2

Thread: Break in vertical continuity of Excel spreadsheet

  1. #1

    Break in vertical continuity of Excel spreadsheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    I am using excel to make a budget spreadsheet using page layout view. My entire document is 2 pages long. When I add more rows at the top of my spreadsheet on the first page, the second page (starting with row 54) becomes empty and all rows that were previously on that page are pushed down to the page below. However when I change the viewing layout to 'normal' the rows become continuous again. I would very much appreciate it if anyone has any advice on fixing this problem.
    Many thanks,
    Megan

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,250
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Odd... what version of Excel are you using? I think I'd want to see a sample workbook with repro steps to really get my head around this, as it's a new one to me.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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