+ Reply to Thread
Results 1 to 17 of 17

can't get row 1

  1. 09-14-2010, 02:18 PM #1
    amsanborn
    amsanborn is offline
    Registered User
    Join Date
    12-19-2008
    Location
    Vancouver,WA
    MS-Off Ver
    2007 Excel
    Posts
    87

    can't get row 1

    I have excel 2010 on a sheet it starts at row 2 when I use goto (a1) it gives a dark blak line on the bottom of the A colum but I can't get it to expand.
    Last edited by amsanborn; 09-15-2010 at 09:49 PM. Reason: Solved
    AL
    Reply With QuoteRegister To Reply
  2. 09-14-2010, 02:26 PM #2
    NBVC
    NBVC is offline
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: can't get row 1

    Probably a hidden row..

    Click the grey square at top left corner at intersection of columns/rows..

    then right click on any row number and select Unhide.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
    Reply With QuoteRegister To Reply
  3. 09-14-2010, 02:27 PM #3
    bjohnsonac
    bjohnsonac is offline
    Registered User
    Join Date
    09-26-2008
    Location
    North Myrtle Beach
    MS-Off Ver
    365 Business
    Posts
    82

    Re: can't get row 1

    Try clicking on the top left corner of the sheet to highlight the entire sheet - then right click and "unhide"
    Reply With QuoteRegister To Reply
  4. 09-14-2010, 07:58 PM #4
    amsanborn
    amsanborn is offline
    Registered User
    Join Date
    12-19-2008
    Location
    Vancouver,WA
    MS-Off Ver
    2007 Excel
    Posts
    87

    Re: can't get row 1

    I tried that and got no results
    Last edited by shg; 09-14-2010 at 08:18 PM. Reason: deleted spurious quote
    Reply With QuoteRegister To Reply
  5. 09-14-2010, 07:59 PM #5
    amsanborn
    amsanborn is offline
    Registered User
    Join Date
    12-19-2008
    Location
    Vancouver,WA
    MS-Off Ver
    2007 Excel
    Posts
    87

    Re: can't get row 1

    Quote Originally Posted by NBVC View Post
    Probably a hidden row..

    Click the grey square at top left corner at intersection of columns/rows..

    then right click on any row number and select Unhide.
    I tried that and got no results
    Reply With QuoteRegister To Reply
  6. 09-14-2010, 08:18 PM #6
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: can't get row 1

    Try selecting everything, Format > Row > Autofit
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  7. 09-15-2010, 05:13 PM #7
    amsanborn
    amsanborn is offline
    Registered User
    Join Date
    12-19-2008
    Location
    Vancouver,WA
    MS-Off Ver
    2007 Excel
    Posts
    87

    Re: can't get row 1

    Quote Originally Posted by shg View Post
    Try selecting everything, Format > Row > Autofit
    Tried it it did nothing. Also tried Format> Visability > un hide row, still nothing.

    This is crazy
    Reply With QuoteRegister To Reply
  8. 09-15-2010, 05:18 PM #8
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: can't get row 1

    Do Alt+F11 to open the VBE

    Press Ctrl+R if the VBAProject window is not showing. Click Sheet1.

    Press F4 if the Properties window is not showing. If there is anything in the Scroll area property, clear it.

    Do Alt+Q to return to Excel.

    If it's still not there, clear the data and post the workbook.
    Reply With QuoteRegister To Reply
  9. 09-15-2010, 06:06 PM #9
    amsanborn
    amsanborn is offline
    Registered User
    Join Date
    12-19-2008
    Location
    Vancouver,WA
    MS-Off Ver
    2007 Excel
    Posts
    87

    Re: can't get row 1

    OK will give it a try
    Last edited by shg; 09-15-2010 at 06:25 PM. Reason: deleted quote
    Reply With QuoteRegister To Reply
  10. 09-15-2010, 06:19 PM #10
    amsanborn
    amsanborn is offline
    Registered User
    Join Date
    12-19-2008
    Location
    Vancouver,WA
    MS-Off Ver
    2007 Excel
    Posts
    87

    Re: can't get row 1

    It did nothing here is a workbook with row 1 gone
    Attached Files Attached Files
    Last edited by shg; 09-15-2010 at 06:25 PM. Reason: deleted quote
    Reply With QuoteRegister To Reply
  11. 09-15-2010, 06:24 PM #11
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: can't get row 1

    View > Freeze panes, Unfreeze

    Please don't quote whole posts. It's just clutter.
    Reply With QuoteRegister To Reply
  12. 09-15-2010, 09:19 PM #12
    amsanborn
    amsanborn is offline
    Registered User
    Join Date
    12-19-2008
    Location
    Vancouver,WA
    MS-Off Ver
    2007 Excel
    Posts
    87

    Re: can't get row 1

    SHG I tryed the Unfreeze nothing changed
    Reply With QuoteRegister To Reply
  13. 09-15-2010, 09:25 PM #13
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: can't get row 1

    works for me. Toggle a few times between freezing top row and unfreezing panes. Don't forget to up-arrow to row 1 in between to see if you can now see it. It won't come into focus automatically. You have to navigate there.
    Microsoft MVP
    http://www.teylyn.com
    Twitter: http://twitter.com/IngeborgNZ
    Reply With QuoteRegister To Reply
  14. 09-15-2010, 09:32 PM #14
    amsanborn
    amsanborn is offline
    Registered User
    Join Date
    12-19-2008
    Location
    Vancouver,WA
    MS-Off Ver
    2007 Excel
    Posts
    87

    Re: can't get row 1

    Thanks all you guys & girls I secected row 2 and unfreeze, then went to find and select> go to> A1 and row 1 showed up.

    Thanks Agien
    Reply With QuoteRegister To Reply
  15. 09-15-2010, 09:39 PM #15
    amsanborn
    amsanborn is offline
    Registered User
    Join Date
    12-19-2008
    Location
    Vancouver,WA
    MS-Off Ver
    2007 Excel
    Posts
    87

    Re: can't get row 1

    Now that it is fixed how to I place a solved on to my first thread?
    Reply With QuoteRegister To Reply
  16. 09-15-2010, 09:44 PM #16
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: can't get row 1

    All explained in the forum rules.
    Reply With QuoteRegister To Reply
  17. 06-21-2012, 11:14 AM #17
    sidney102
    sidney102 is offline
    Registered User
    Join Date
    04-25-2011
    Location
    New York, USA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: can't get row 1



    Thanks that was great!

    same problem, I was frustrated with not seeing row 1, your unfreeze and arrow up works!

    Brian
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1