Results 1 to 7 of 7

Thread: ?Locking Cell?

  1. #1

    ?Locking Cell?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Is there a way to lock a cell in place? I am importing an excel file[COLOR=blue !important][COLOR=blue !important][/COLOR][/COLOR] into CAD and my excel file changes all the time, I would like to be able to define column headings every 75 or so rows. If I insert a row near the top of file I want the rows to shift down as usual but I want my column headings to stay where they are...any ideas?

  2. #2
    Select the cell in column A below your headings, and use

    View>Freeze Panes

  3. #3
    Oops, just spotted a cross-posting at Excel User Group http://excelusergroup.org/forums/t/2632.aspx

  4. #4
    sorry if I crossed posted, not sure what that means.

    Thanks for the reply Bob, but I am not looking to keep the column headings at the top of the page. I am importing an excel file into CAD and only 75 rows fit on each page(CAD). In CAD I can import rows 1-75 then 76-150(so I retype my column headings at row 75).The problem is that I add and delete rows all the time which causes the column headings to shift up and down. This causes me to have to reformat where my column headings appear....I was hoping I could find a way around this.

  5. #5
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,195
    Articles
    57
    Blog Entries
    14
    Hi Samlit,

    Here's some info on the cross/multi forum posting, and what our board policy is: http://www.excelguru.ca/forums/faq.p...osting_details

    Personally, I'd set up with the frozen panes, as Bob described, then just use VBA to insert column headings for export when needed. With another VBA routine, you could remove those rows when not needed as well. (There's no other way to freeze the headings as you described.)
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  6. #6
    Thank you, I am/was coming to the same conclusion, can't be done.

  7. #7
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,195
    Articles
    57
    Blog Entries
    14
    Can't be done as you originaly specified, but with VBA you can get it to serve you what you need for export. I wouldn't discount it entirely.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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