View original (French)

Excel: Formatting, the Creation tab that no longer appears

Solved
morgane 12345 -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Hello everyone!

I created a table from a column of another table (which I think was locked) because now whenever I want to modify the formatting, the "Design" tab doesn't appear..
I have checked that no cell is locked (I can write in them, etc..)
but it's impossible to change the color of the entire table

Do you have any ideas to unlock this?

Thanks in advance!!

Configuration: Windows 7 / Mozilla 11.0

1 answer

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    Which software to have the creation tab?
    Looking forward to your response

    --
    To err is human, to persist is diabolical
    2
    1. MoMo1234567890AZERTY Posted messages 5 Status Member
       
      It is about Excel 2010
      when you have a table, the creation tab should normally appear in the ribbon, but with one of my tables, it is impossible to see it.
      0
    2. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      Sure, it automatically shows when we select the table. But I don't see an option in Excel (2007) on my end to show or hide this "table tools" tab.
      Do you have the "format as table" icon in the Home tab in 2010?
      Which gives access to cell formatting via "new table style" and "Format"?
      And if possible, could you upload a file with the table in question, even a dummy one, to
      https://www.cjoint.com/
      to test?
      (and come back here to paste the link provided by the site)
      Looking forward to hearing from you.
      0