Liaison avec plages Excel : supprimer l'affichage des entêtes

  • 1
  • Idea
  • Updated 5 years ago
Bjr, comment enlever les entêtes de ligne et de colonnes Excel (A, B, C, D & 1, 2, 3...) lors de la liaison avec des plages excel
Photo of Isabelle Mayor

Isabelle Mayor

  • 2 Posts
  • 0 Reply Likes

Posted 5 years ago

  • 1
Photo of aHa!Coaching

aHa!Coaching, Champion

  • 1192 Posts
  • 115 Reply Likes
Apologies for my reply in English, but this might also benefit others in the community.

To hide the row headers and/or column headers of embedded spreadsheets, right-click on the topic with the embedded spreadsheet, choose 'Spreadsheet' and then choose 'Spreadsheet Properties'. In the Spreadsheet Properties screen you can enable and disable the display of row headers and column headers.
Photo of Esther van Wijngaarden

Esther van Wijngaarden

  • 154 Posts
  • 61 Reply Likes
But this does not work for Excel ranges embedded in the mindmap. There is no option to hide the headers.
So a new idea for Mindjet?
Photo of Michael Deutch

Michael Deutch, Official Rep

  • 438 Posts
  • 75 Reply Likes
I will move this topic into the idea bucket. Vote for it (or other topics) if you want to raise the priority!
Photo of aHa!Coaching

aHa!Coaching, Champion

  • 1192 Posts
  • 115 Reply Likes
There is a work-around, but only If you don't need to have the embedded Excel range to be updated automatically future: you can also disconnect the spreadsheet from Excel (right click on embedded Excel range > Microsoft Excel Range > Disconnect from Microsoft Excel) so it transforms in a normal embedded spreadsheet and then hide the row headers as described above.