Results 1 to 3 of 3
  1. #1
    Junior Member
    Join Date
    Aug 2006
    Posts
    85

    Default unhide rows in excel

    I'm trying to modify someone else's spreadsheet. I'm unable to contact the person who created it.

    I need to modify some formulas that are in rows 180 - 190, but nothing at all is displayed after row 70. The rows are not hidden the normal way, so I can't figure out how to unhide them.

  2. #2
    Señor Member nofam's Avatar
    Join Date
    Feb 2008
    Location
    Mollywood
    Posts
    2,323

    Default Re: unhide rows in excel

    Did you try clicking on the origin button at the top left of the sheet, and then right-clicking over any row number and selecting Unhide??
    .
    .
    .

    Got a natural pearl in my calloused hand
    ...Saved for the girl who could really understand
    ......What it takes to see
    .........The gold from the alchemy

  3. #3
    ~ >*()))><( andrew93's Avatar
    Join Date
    Dec 2004
    Posts
    1,556

    Default Re: unhide rows in excel

    Hi

    My guess is the sheet, or the workbook, has been password protected. Check under menu option Tools > Protection. One of the options when protecting a sheet is the specify that the row/column formats cannot be altered. Changing the row is a formatting change so I'm guessing that option is probably greyed out on the main menu, and the right click menu. On that basis I reckon you need the password. One place to check for the password is in the VBA section of the spreadsheet - some developers put it in there for themselves as either a constant or a comment.

    Andrew

Similar Threads

  1. Excel to delete rows with no data or zeros
    By lightfoot in forum PressF1
    Replies: 7
    Last Post: 18-11-2007, 08:22 PM
  2. excel macro to hide rows
    By bpt2 in forum PressF1
    Replies: 3
    Last Post: 09-11-2006, 12:52 PM
  3. Excel 2002 - reversing rows
    By alands in forum PressF1
    Replies: 3
    Last Post: 01-10-2003, 04:00 PM
  4. Replies: 0
    Last Post: 15-07-2000, 03:27 PM
  5. deleting rows in excel
    By in forum PressF1
    Replies: 0
    Last Post: 18-10-1999, 07:03 PM

Posting Permissions

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