+ Reply to Thread
Results 1 to 4 of 4

blue row numbers

  1. #1
    Grannet
    Guest

    blue row numbers

    I have blue row numbers and hidden rows that won't unhide but I see no
    evidence of grouping. There isn't any numbers at the top or anything. I can
    manually resize the row height but even if I save it afterwards when I go
    back into it the rows are hid again. Does anyone know why? And how to fix it?

  2. #2
    Bob Phillips
    Guest

    Re: blue row numbers

    Do any of your columns have a dropdown arrow on them? there might be a
    filter applied. Go into Data>Filter, and if the Autofilter has a tick mark,
    click it and see if this reveals all the rows.

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Grannet" <[email protected]> wrote in message
    news:[email protected]...
    > I have blue row numbers and hidden rows that won't unhide but I see no
    > evidence of grouping. There isn't any numbers at the top or anything. I

    can
    > manually resize the row height but even if I save it afterwards when I go
    > back into it the rows are hid again. Does anyone know why? And how to fix

    it?



  3. #3
    Ken Johnson
    Guest

    Re: blue row numbers

    Hi Grannet,
    Is a filter responsible for this.
    On the main menu bar click on Data then Filter. Is there a tick next to
    any of the indicated filters? If so click to remove the filter.
    Ken Johnson


  4. #4
    Gord Dibben
    Guest

    Re: blue row numbers

    And if no drop-down arrows and Data>Autofilter is grayed out check
    Tools>Options>View>Objects

    Put a Checkmark at "Show all"

    Now do you have dropdown arrows?


    Gord Dibben Excel MVP


    On Thu, 8 Dec 2005 00:04:20 -0000, "Bob Phillips"
    <[email protected]> wrote:

    >Do any of your columns have a dropdown arrow on them? there might be a
    >filter applied. Go into Data>Filter, and if the Autofilter has a tick mark,
    >click it and see if this reveals all the rows.


+ 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