Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Tables should default to "My table has headers" being ticked

It's taken me 10 years to realise this but I've never "unchecked" My Table has headers, it's ALWAYS the other way round, forgetting to remember to tick it because Excel hasn't recognised the header row.

Let's default the tick to always on ?

86 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Wyn Hopkins shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

7 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Stephen Cunliffe commented  ·   ·  Flag as inappropriate

    It would be very easy to apply some basic heuristics to at least guess if the table already has headers. (e.g. if the top cell is text, but the one's underneath are numbers or dates, or known string values (Jan/Feb/Mar...)

  • Wyn Hopkins commented  ·   ·  Flag as inappropriate

    Great tip Jon, it appears to work if the top cell is formatted differently in any way (background, font etc).

  • Jon Acampora commented  ·   ·  Flag as inappropriate

    So in your example, if the active cell is in the top row you can hit Ctrl+B then Ctrl+T to check the box. Fun workaround... :-)

  • Jon Acampora commented  ·   ·  Flag as inappropriate

    Great suggestion! If the text in the header row is bold then the box will be checked by default.

Feedback and Knowledge Base