+ Reply to Thread
Results 1 to 2 of 2

Can't Freeze entire portion of doc???

  1. #1
    Registered User
    Join Date
    02-08-2007
    Posts
    4

    Can't Freeze entire portion of doc???

    I have a spreadsheet on my MAC with 3000 names and addresses. I want to have the names stay stationary and the other information scrollable. I've been expirementing with the "freeze pane" function. However I'm doing this with 3000 names. When I do this it seems to only freeze those names seen on the viewable screne. Even when I follow the instructions. IE " click the field just below and just to the right of the field you want freeze." It either freezes the last 20 or so or the viewable top 50. Am I missing something? Is there an easier way to go about doing this? Or can I move the line it places as a seperator? I know you can move the line you using a pc. Thanks for any and all help.

    Josh
    Last edited by jnc007; 03-23-2007 at 08:34 AM.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    If your information is setup as follows:
    Please Login or Register  to view this content.
    Then click on cell B2, which would be your first address column entry and click Window -> Freeze Panes. This will freeze both column A, with your names, and row #1 with your column headers (Name, Address, City...)

+ 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