+ Reply to Thread
Results 1 to 2 of 2

How do I stop an Excel sheet from automatically hiding rows when .

  1. #1
    kazyreed
    Guest

    How do I stop an Excel sheet from automatically hiding rows when .

    When I open an Excel worksheet, several rows of data are automatically
    hidden. How can I change this? It's annoying

  2. #2
    JulieD
    Guest

    Re: How do I stop an Excel sheet from automatically hiding rows when .

    Hi

    I'm guessing there's some code running that's doing this.

    After you've opened your workbook, right mouse click on a sheet tab, and
    choose view code. On the left hand side of the VBE window (under where you
    see your workbook's name in bold) you'll see ThisWorkbook - double click on
    it and some code should come up on the right ... i'm guessing your problem
    is in there.

    Cheers
    JulieD

    "kazyreed" <kazyreed@discussions.microsoft.com> wrote in message
    news:6A022F64-450B-4E78-BD19-A7BF7AF67951@microsoft.com...
    > When I open an Excel worksheet, several rows of data are automatically
    > hidden. How can I change this? It's annoying




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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