Speziell für dieses Probelm gibt es in Excel die Funktion ANZAHL. Nummerierung bei Excel: Spalte oder Zeile mit Zahlenreihe einfügen. Um diese wieder zu aktualisieren, markieren Sie zwei der bereits existierenden Zahlen der Nummerierung und ziehen Sie das Ausfüllkästchen über den unterbrochenen Bereich.Die ZEILE-Funktion beginnt Ihre Nummerierung nun mit 1 in Zeile B3, da B1 und B2 von der Nummerierung abgezogen wurden:Ziehen Sie das Ausfüllkästchen wieder nach unten. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f3\/Add-Autonumber-in-Excel-Step-1-Version-4.jpg\/v4-460px-Add-Autonumber-in-Excel-Step-1-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f3\/Add-Autonumber-in-Excel-Step-1-Version-4.jpg\/v4-728px-Add-Autonumber-in-Excel-Step-1-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f9\/Add-Autonumber-in-Excel-Step-2-Version-4.jpg\/v4-460px-Add-Autonumber-in-Excel-Step-2-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f9\/Add-Autonumber-in-Excel-Step-2-Version-4.jpg\/v4-728px-Add-Autonumber-in-Excel-Step-2-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a8\/Add-Autonumber-in-Excel-Step-3-Version-3.jpg\/v4-460px-Add-Autonumber-in-Excel-Step-3-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a8\/Add-Autonumber-in-Excel-Step-3-Version-3.jpg\/v4-728px-Add-Autonumber-in-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/ac\/Add-Autonumber-in-Excel-Step-4-Version-4.jpg\/v4-460px-Add-Autonumber-in-Excel-Step-4-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ac\/Add-Autonumber-in-Excel-Step-4-Version-4.jpg\/v4-728px-Add-Autonumber-in-Excel-Step-4-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4c\/Add-Autonumber-in-Excel-Step-5-Version-4.jpg\/v4-460px-Add-Autonumber-in-Excel-Step-5-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4c\/Add-Autonumber-in-Excel-Step-5-Version-4.jpg\/v4-728px-Add-Autonumber-in-Excel-Step-5-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/57\/Add-Autonumber-in-Excel-Step-6-Version-4.jpg\/v4-460px-Add-Autonumber-in-Excel-Step-6-Version-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/57\/Add-Autonumber-in-Excel-Step-6-Version-4.jpg\/v4-728px-Add-Autonumber-in-Excel-Step-6-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d9\/Add-Autonumber-in-Excel-Step-7.jpg\/v4-460px-Add-Autonumber-in-Excel-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d9\/Add-Autonumber-in-Excel-Step-7.jpg\/v4-728px-Add-Autonumber-in-Excel-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/38\/Add-Autonumber-in-Excel-Step-8.jpg\/v4-460px-Add-Autonumber-in-Excel-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/38\/Add-Autonumber-in-Excel-Step-8.jpg\/v4-728px-Add-Autonumber-in-Excel-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/13\/Add-Autonumber-in-Excel-Step-9.jpg\/v4-460px-Add-Autonumber-in-Excel-Step-9.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/13\/Add-Autonumber-in-Excel-Step-9.jpg\/v4-728px-Add-Autonumber-in-Excel-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a8\/Add-Autonumber-in-Excel-Step-10.jpg\/v4-460px-Add-Autonumber-in-Excel-Step-10.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a8\/Add-Autonumber-in-Excel-Step-10.jpg\/v4-728px-Add-Autonumber-in-Excel-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/11\/Add-Autonumber-in-Excel-Step-11.jpg\/v4-460px-Add-Autonumber-in-Excel-Step-11.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/11\/Add-Autonumber-in-Excel-Step-11.jpg\/v4-728px-Add-Autonumber-in-Excel-Step-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/73\/Add-Autonumber-in-Excel-Step-12.jpg\/v4-460px-Add-Autonumber-in-Excel-Step-12.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/73\/Add-Autonumber-in-Excel-Step-12.jpg\/v4-728px-Add-Autonumber-in-Excel-Step-12.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/50\/Add-Autonumber-in-Excel-Step-13.jpg\/v4-460px-Add-Autonumber-in-Excel-Step-13.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/50\/Add-Autonumber-in-Excel-Step-13.jpg\/v4-728px-Add-Autonumber-in-Excel-Step-13.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"
<\/div>"}In Excel Kleinbuchstaben in Großbuchstaben umwandelnIn Excel Kleinbuchstaben in Großbuchstaben umwandeln
Copyright 2020 excel zeilen nummerieren