+ Reply to Thread
Results 1 to 2 of 2

HOW? - Exported worksheet has column title move into column label area (not freeze panes)

  1. #1
    Registered User
    Join Date
    06-19-2012
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    7

    HOW? - Exported worksheet has column title move into column label area (not freeze panes)

    Hi,

    I have an excel worksheet which is exported from a Company data portal.

    I've noticed that the column headings move into the column label area when you scroll down. For example column label A is replaced with PoNo, column label B is replaced with SystemNo.

    It's a neat feature and I want to know how to replicate it so I can add columns with same formatting. Note this feature is only on the number of columns from the original export query, when you go beyond that it reverts to plain text and if your cell is selcetde outside of the original area the label replace feature stops working.

    Format painter does not work. However, if you type a new column heading and then press return then the formatting is copied over.

    It looks like a macro but I can't find it.

    I've attached a couple of screen shots to illustrate this.

    Really interested to figure this out.

    Thanks in advance!
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    06-19-2012
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    7

    Re: HOW? - Exported worksheet has column title move into column label area (not freeze pan

    I've solved it.

    It's Header Row option in Table Style options under Design Ribbon.

    Hope this helps someone else

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Freeze Panes, Column D ONLY!
    By JimmyWilliams in forum Excel General
    Replies: 5
    Last Post: 09-10-2017, 06:30 PM
  2. macro w/ Freeze panes keeps shifting where panes freeze on worksheet
    By sschwant in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2015, 02:30 AM
  3. Replies: 1
    Last Post: 09-30-2013, 09:52 AM
  4. Freeze panes or rows that don't move when you scrool down
    By kitu_gudu in forum Excel General
    Replies: 4
    Last Post: 12-24-2011, 11:04 AM
  5. Freeze panes title row & merged cells
    By sepi in forum Excel General
    Replies: 1
    Last Post: 09-19-2011, 11:43 AM
  6. Freeze Panes-When freeze panes is employed it leave a black line
    By peter.thompson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2006, 01:40 AM
  7. Freeze Panes-can you freeze more than one column
    By rexmann in forum Excel General
    Replies: 4
    Last Post: 06-09-2005, 11:05 AM

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