+ Reply to Thread
Results 1 to 4 of 4

one of the most stopidest Q there is....

  1. #1
    Registered User
    Join Date
    11-20-2013
    Location
    israel
    MS-Off Ver
    Excel 2003
    Posts
    3

    one of the most stopidest Q there is....

    i'm trying to freeze the top row and column and i use the "freeze panes" function for that.
    i don't know why but it freezes more then the top row (it selected a few rows underneath) and the first column stops at the end of my table and does not include what underneath..
    so wired!!!
    your help would be more than appreciated!!

    10x!!!
    -M-

  2. #2
    Forum Contributor
    Join Date
    05-01-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    822

    Re: one of the most stopidest Q there is....

    Have you got any hidden rows after the top one?

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: one of the most stopidest Q there is....

    Hi, JUSTm,

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Registered User
    Join Date
    05-20-2013
    Location
    Leicester, England
    MS-Off Ver
    MS Office XP
    Posts
    22

    Re: one of the most stopidest Q there is....

    If more than the top row is being frozen then you must be positioned in something other than Row 2 when you freeze the panes.
    Sorry but I'm not understanding what you mean by "the first column stops at the end of my table and does not include what is underneath" so can't help on that part.
    Not sure how familiar you are with freeze panes but if you have only just started using the function then examples below:-
    If you want to freeze just the first row (which is usually for the headings) then position yourself in Cell A2 when you freeze panes.
    If you want to freeze the first row and first column then position yourself in Cell B2 and so on.
    Cheers - Gaynor

+ 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