+ Reply to Thread
Results 1 to 3 of 3

Excel - Table Title

  1. #1
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    819

    Excel - Table Title

    I have created a Table in Excel using Format as Table and My table has headers.
    Can I add on Top of this table, one row, or two rows, ATTACHED to table ?
    I want to create a "Title" for this Table attached to Table where I can group/define the Headers
    So when I move the table, it moves too.
    For example, in Table, Header Column 1 is "Time Requested", Header Column 2 is "Time Closed"
    In the row attached on top, I would Merge Column 1 with Column 2, Name it Time so Header Column 1 became Requested, and column 2 Closed.
    I hope I was not too complicated
    I did this with a simple Row but it doesn't move with table

  2. #2
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: Excel - Table Title

    No, thats not how tables in Excel work. They are strict structures predefined in terms of layout and function. You can of course above it in cells outside the table (and thus not part of the table in a technical sense) put anything into the cells and format them however you like.

  3. #3
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    819

    Re: Excel - Table Title

    Understood !
    Excel has so many tips and tricks and I was thinking that it is possible.
    Thanks

+ 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. Sum of title in pivot table fields
    By stephme55 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-07-2016, 02:33 PM
  2. [SOLVED] Macro to put the table title left at each table's row
    By VincentNL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2014, 10:12 AM
  3. Is it possible to use VBA to insert a title into a pivot table?
    By Smudge.Smith in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2014, 11:29 AM
  4. [SOLVED] Changing data on table according to title
    By efemko in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-07-2014, 04:33 PM
  5. [SOLVED] extracting column title from a table
    By tiger234 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-06-2012, 06:20 AM
  6. Need dynamic title in pivot table in excel web access
    By SJMaye in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-12-2010, 01:36 PM
  7. How to make visible the title of the table?
    By mari - ExcelForums.com in forum Excel General
    Replies: 2
    Last Post: 02-26-2005, 12:07 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