Excel 2103 adding digits to column

  1. Posts : 107
    WIndows 10 Pro 64 Bit

    Excel 2103 adding digits to column

    Hi guys can I ask for a little advice please I have an excel 2013 spreadsheet formatted as a table

    I have attached a screenshot to explain better

    As you can see I have a rows of dates in the header row IE 12th 13th 14th and so on to the left of the yellow column but when I add the same dates to the right of the yellow column excel add the digit 2.

    I understand it is telling me that's the second time the same date has been used, but is it possible to stop this please
    Attached Thumbnails Attached Thumbnails Excel 2103 adding digits to column-excell-screenshot.jpg  
      My Computer

  2. Lugh's Avatar
    Posts : 109
    Windows 10 Home x64 1803

    sam02 said:
    is it possible to stop this please

    It's not that it's the second time you use the same thing. It's that Excel doesn't allow the same heading label to be used for 2+ columns in tables.

    You can get what you want by not formatting it all as a table—ie format as a Range:
    Click Table Tools > Design tab > Tools section > Convert to Range
      My Computer

  3. SoFine409's Avatar
    Posts : 1,084
    Win10 Pro

    When you format an Excel spreadsheet as a table you are actually creating a database and the column headings are a data categories. For any database to function it must have different names for each category. Duplicate names are not allowed.
      My Computer

  4. Posts : 107
    WIndows 10 Pro 64 Bit
    Thread Starter

    Ok guys thanks for the advice i understand now
      My Computer


Related Threads
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 08:25.
Find Us

Windows 10 Forums