<b>Tabelle1</b>
<table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:47px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:33px;" /><col style="width:46px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td><td >O</td><td >P</td><td >Q</td><td >R</td><td >S</td><td >T</td><td >U</td><td >V</td><td >W</td></tr><tr style="height:27px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td colspan="2" style="background-color:#ffff00; color:#ff0000; font-weight:bold; ">Tippreihen</td><td style="color:#ffffff; "> </td><td colspan="20" style="background-color:#000080; color:#ffff00; font-weight:bold; font-size:16pt; text-align:center; "> 2 x 20 Wahlzahlen a´24 Reihen = 48 Reihen</td></tr><tr style="height:27px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">U/G</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">Anz</td><td colspan="11" style="font-weight:bold; text-align:left; ">EXCEL-Tabelle 2009 by Peter Franke (Deutschland)</td><td colspan="10" style="background-color:#ffff00; font-weight:bold; font-size:14pt; text-align:left; ">7 H / 13 N 20 Wahlzahlensystem </td></tr><tr style="height:25px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">6/0</td><td style="font-weight:bold; text-align:center; ">0</td><td style="color:#ffffff; "> </td><td colspan="6" style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">ungerade/gerade Verteilung</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">U</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">G</td><td style="color:#ff0000; font-weight:bold; "> </td><td style="color:#ff0000; font-weight:bold; "> </td><td colspan="10" style="background-color:#ffff00; font-weight:bold; font-size:14pt; text-align:left; ">von Thomas</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">5/1</td><td style="font-weight:bold; text-align:center; ">7</td><td style="color:#ffffff; "> </td><td style="color:#ffffff; "> </td><td style="color:#ffffff; "> </td><td style="color:#ffffff; "> </td><td colspan="3" style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:right; ">Zahlenpool</td><td style="font-weight:bold; text-align:center; ">22</td><td style="font-weight:bold; text-align:center; ">18</td><td style="color:#ff0000; font-weight:bold; "> </td><td style="color:#ff0000; font-weight:bold; "> </td><td colspan="8" style="background-color:#ffff00; color:#ff0000; font-weight:bold; text-align:center; ">ungerade/gerade Verteilung in Ziehung</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">U</td><td style="background-color:#c0c0c0; font-weight:bold; text-align:center; ">G</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">4/2</td><td style="font-weight:bold; text-align:center; ">18</td><td style="color:#ffffff; "> </td><td style="color:#ffffff; "> </td><td style="color:#ffffff; "> </td><td style="color:#ffffff; "> </td><td style="color:#ffffff; "> </td><td style="color:#ffffff; "> </td><td style="color:#ffffff; "> </td><td style="color:#ffffff; "> </td><td style="color:#ffffff; "> </td><td style="color:#ffffff; "> </td><td style="color:#ffffff; "> </td><td style="color:#ffffff; "> </td><td colspan="7" style="background-color:#000080; color:#ffff00; font-weight:bold; font-size:9pt; text-align:center; ">Gewinnzahlen zur Gewinnkontrolle</td><td style="font-weight:bold; text-align:center; ">4</td><td style="font-weight:bold; text-align:center; ">3</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">3/3</td><td style="font-weight:bold; text-align:center; ">18</td><td colspan="9" style="background-color:#ff0000; color:#ffff99; font-weight:bold; text-align:center; ">Die Pools können sich auch überschneiden!</td><td > </td><td > </td><td > </td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">1</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">2</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">3</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">4</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">5</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">6</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">ZZ</td><td > </td><td > </td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">2/4</td><td style="font-weight:bold; text-align:center; ">5</td><td style="background-color:#ffff00; font-weight:bold; ">P 1</td><td colspan="5" style="background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">Hauptzahlen 1 -7</td><td colspan="5" style="font-weight:bold; font-size:12pt; text-align:center; ">Nebenzahlen 8 - 20</td><td style="color:#ff0000; font-weight:bold; "> </td><td style="color:#ff0000; background-color:#ffff00; font-weight:bold; text-align:center; ">5</td><td style="color:#ff0000; background-color:#ffff00; font-weight:bold; text-align:center; ">19</td><td style="font-weight:bold; text-align:center; ">23</td><td style="color:#ff0000; background-color:#ffff00; font-weight:bold; text-align:center; ">34</td><td style="font-weight:bold; text-align:center; ">40</td><td style="color:#ff0000; background-color:#ffff00; font-weight:bold; text-align:center; ">41</td><td style="color:#0000ff; background-color:#00ffff; font-weight:bold; text-align:center; ">48</td><td > </td><td > </td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">1/5</td><td style="font-weight:bold; text-align:center; ">0</td><td style="background-color:#ffff00; font-weight:bold; ">P 2</td><td colspan="5" style="background-color:#ffcc99; color:#0000ff; font-weight:bold; font-size:12pt; text-align:center; ">Hauptzahlen 1 - 7</td><td colspan="5" style="background-color:#ccffff; color:#0000ff; font-weight:bold; font-size:12pt; text-align:center; ">Nebenzahlen 8 - 20</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="color:#ff0000; font-weight:bold; text-align:center; ">0/6</td><td style="font-weight:bold; text-align:center; ">0</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">1</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">2</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">3</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">4</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">5</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">6</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">7</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">8</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">9</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">10</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">11</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">12</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">13</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">14</td><td style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">15</td><td > </td><td colspan="5" style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">Richtige Zahlen im Pool 1</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td colspan="2" style="font-weight:bold; text-align:center; ">Poo 1</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">10</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">15</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">30</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">21</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">28</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">29</td><td style="color:#000080; background-color:#00ff00; font-weight:bold; font-size:12pt; text-align:center; ">33</td><td style="color:#ff0000; background-color:#ffff00; font-weight:bold; font-size:12pt; text-align:center; ">5</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">6</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">9</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">18</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">27</td><td style="color:#ff0000; background-color:#ffff00; font-weight:bold; font-size:12pt; text-align:center; ">41</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">31</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">32</td><td colspan="2" > </td><td style="background-color:#ffff99; color:#0000ff; font-weight:bold; font-size:12pt; text-align:center; ">2</td><td colspan="2" style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">Zusatzz.</td><td style="background-color:#ffff99; color:#0000ff; font-weight:bold; font-size:12pt; text-align:center; ">1</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td colspan="2" style="font-weight:bold; text-align:center; ">Pool 1</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">37</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">38</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">39</td><td style="color:#0000ff; background-color:#00ffff; font-weight:bold; font-size:12pt; text-align:center; ">48</td><td style="color:#000080; font-weight:bold; font-size:12pt; text-align:center; ">49</td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td > </td><td colspan="5" style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">Richtige Zahlen im Pool 2</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td colspan="2" style="font-weight:bold; text-align:center; ">Pool 2</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">15</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">20</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">21</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">28</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">37</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">43</td><td style="color:#0000ff; background-color:#ffcc99; font-weight:bold; font-size:12pt; text-align:center; ">49</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">3</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">6</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">10</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">11</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">16</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">18</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">31</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">33</td><td colspan="2" > </td><td style="background-color:#ffff99; color:#0000ff; font-weight:bold; font-size:12pt; text-align:center; ">2</td><td colspan="2" style="background-color:#000080; color:#ffff00; font-weight:bold; text-align:center; ">Zusatzz.</td><td style="background-color:#ffff99; color:#0000ff; font-weight:bold; font-size:12pt; text-align:center; ">1</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td colspan="2" style="font-weight:bold; text-align:center; ">Pool 2</td><td style="color:#ff0000; background-color:#ffff00; font-weight:bold; font-size:12pt; text-align:center; ">34</td><td style="color:#ff0000; background-color:#ffff00; font-weight:bold; font-size:12pt; text-align:center; ">19</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">46</td><td style="color:#0000ff; background-color:#00ffff; font-weight:bold; font-size:12pt; text-align:center; ">48</td><td style="color:#0000ff; background-color:#ccffff; font-weight:bold; font-size:12pt; text-align:center; ">38</td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td style="background-color:#c0c0c0; "> </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr></table>
Excel Tabellen im Web darstellen >> <a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4 </a>
Hallo Liane,
um die Tabelle so reinzustellen, mußt Du folgendes tun:
zunächst kontrolliere die Zeilen, die Schrift enthalten und über mehrere Zellen gehen, ob diese miteinander verbunden sind.
Der Text
Gewinnzahlen zur Gewinnkontrolle ist beispielsweise nicht verbunden. markiere den Text bis zum letzten Wort und klicke dann oben in der Menuleiste auf das Symbol
verbinden und zentrieren. Das befindet sich neben dem Symbol
rechtbündig
Wenn Du alle Texte, die über mehrere Zellen gehen verbunden hast, solltest Du die Tabelle speichern. Dann mußt Du das nicht noch einmal machen.
Somit hast Du erreicht, daß alle Zellen ihre Größe behalten
Anschließend markierst Du das gesamte Tabellenblatt (Mausklick links neben dem
A und über der 1)
und kopierst die gesamte Tabelle in ein neues, leeres Tabellenblatt.
Cursor im neuen Blatt auf A1 dann im Menu
Bearbeiten-->Inhalte einfügen auswählen
Spaltenbreite
dann
Inhalte einfügen
Werte
zum Schluß
Inhalte einfügen
Formate
somit erreicht Du, daß keine Formeln mit übertragen werden und die Tabelle im Forum so aussieht wie oben dargestellt.
Damit alles richtig ins Forum paßt mußte ich noch den Text
7 H / 13 N 20 Wahlzahlensystem
von Thomas
anders formatieren. Am besten ich schicke Dir ne neue Tabelle wo ich das schon gemacht habe.
Gruß Peter
Erfahrung ist eine nützliche Sache.
Leider macht man sie immer erst kurz nachdem man sie brauchte.