Excel for iPad - moving of cells, rows or columns does no longer work

Diskutiere und helfe bei Excel for iPad - moving of cells, rows or columns does no longer work im Bereich Microsoft Office im Windows Info bei einer Lösung; Hello - Suddenly I cannot move cells, rows or columns in Excel for iPad anymore. Usually, I just select the cell, row or column and then drag & drop... Dieses Thema im Forum "Microsoft Office" wurde erstellt von SvenBohnert, 22. November 2020.

  1. Excel for iPad - moving of cells, rows or columns does no longer work


    Hello - Suddenly I cannot move cells, rows or columns in Excel for iPad anymore. Usually, I just select the cell, row or column and then drag & drop them to another locationn in the Excel spreadsheet. Since this morning, this is no longer possible. When I do as described above, it does not move the cell contents, but copy them little green plus sign appears in the top right corner of the cell I want to move. It‘s very annoying, but I cannot get rid of it. Any ideas? Thanks much!
     
  2. Claus Busch Win User

    Makro neue Zeilen einfügen in Excel

    Hallo Steffi,

    markiere zuerst die Zeilen, die eingefügt werden sollen und lasse dann das Makro laufen:

    Sub test17()
    
    Dim rngC As Range
    
    Dim LCol As Long
    Application.ScreenUpdating = False
    
    With ActiveSheet
    
       LCol = .Cells(5, Columns.Count).End(xlToLeft).Column
    
       .Rows(4).Hidden = False
    
       .Rows(4).Copy
    
       Selection.Insert Shift:=xlDown
    
       For Each rngC In Intersect(Selection, _
    
          .Columns("A:" & Chr(LCol + 64)))
    
          If Not rngC.HasFormula Then
    
             rngC.ClearContents
    
          End If
    
       Next
    
       .Rows(4).Hidden = True
    
    End With
    
    Application.ScreenUpdating = True
    
    '    ActiveWorkbook.Save
    
    End Sub
    Oder du lässt Zeile 4 ausgeblendet und blendest die ausgeblendet eingefügten Zeilen ein:Sub test()
    
    Dim rngC As Range
    
    Dim LCol As Long
    
    Dim LRow As Long
    Application.ScreenUpdating = False
    
    With ActiveSheet
    
       LCol = .Cells(5, Columns.Count).End(xlToLeft).Column
    
       LRow = .Cells(Rows.Count, 1).End(xlUp).Row
    
       .Rows(4).Copy
    
       Selection.Insert Shift:=xlDown
    
       .Rows("5:" & LRow).Hidden = False
    
       For Each rngC In Intersect(Selection, _
    
          .Columns("A:" & Chr(LCol + 64)))
    
          If Not rngC.HasFormula Then
    
             rngC.ClearContents
    
          End If
    
       Next
    
    End With
    
    Application.ScreenUpdating = True
    
    '    ActiveWorkbook.Save
    
    End Sub
    Mit freundlichen Grüßen

    Claus
  3. 2ecc73e3-02f6-4959-9 Win User

    selbst ausführendes Makro

    Hi Claus

    Danke,

    funktioniert zu 99,9% echt super,

    wenn ich aber neue Zeilen einfügen will, "flackert jetzt die Tabelle"

    • das einfügen jeder einzelnen Zeile wird durchlaufen und abgebildet
    dafür hatte ich bis jetzt immer folgendes Makro:

    Sub Zeilen_einfügen()

    Application.ScreenUpdating = False

    Dim rngC As Range

    Dim LCol As Long

    With ActiveSheet

    LCol = .Cells(5, Columns.Count).End(xlToLeft).Column

    .Rows(4).Hidden = False

    .Rows(4).Copy

    Selection.Insert Shift:=xlDown

    For Each rngC In Intersect(Selection, _

    .Columns("A:" & Chr(LCol + 64)))

    If Not rngC.HasFormula Then

    rngC.ClearContents

    End If

    Next

    .Rows(4).Hidden = True

    End With

    Application.ScreenUpdating = True

    End Sub

    gibt es da noch eine Möglichkeit dieses zu ändern

    Danke

    BG
  4. Claus Busch Win User

    Datum Filtern / eingrenzen und in eine neue Tabelle kopieren

    Hallo Muharrem,



    probiere es mal so:



    Sub Duplikate()

    Dim LRow As Long

    Dim i As Long

    LRow = Cells(Rows.Count, "A").End(xlUp).Row

    For i = LRow To 2 Step -1

    If WorksheetFunction.CountIf(Range(Cells(2, 1), _

    Cells(i, 1)), Cells(i, 1)) > 1 Then

    Rows(i).Delete

    End If

    Next

    End Sub



    Mit freundlichen Grüßen

    Claus
  5. Martin_Gasser CH Win User

    Microsoft Office Home & Student 2016 for Mac

    Hi John

    After I've applied all of the updates for Office 2016 for Mac, this error no longer occurs.
    It was a bit complicated to find the update in the app (Reg Help, check for updates)

    But now everything works fine. Thanks for the support.

    Best regards Martin
  6. Claus Busch Win User

    VBA-Programm zum Auslesen von Daten eines Arbeitsblatts

    Hallo Adrian,

    probiere es mal so:

    Sub Transponieren()

    Dim LCol As Long

    Dim LRow As Long

    Dim arrRng As Variant

    Dim i As Long, j As Long, n As Long

    'Blattname anpassen

    With Sheets("Tabelle1")

    n = 1

    LCol = .Cells(1, Columns.Count).End(xlToLeft).Column

    LRow = .Cells(Rows.Count, 1).End(xlUp).Row

    arrRng = .Range(.Cells(2, 3), .Cells(LRow, LCol))

    For i = 1 To LRow - 1

    For j = 1 To LCol - 2

    If arrRng(i, j) = 1 Then

    'Blattname anpassen

    Sheets("Tabelle2").Cells(n, 1) = .Cells(1, j + 2)

    Sheets("Tabelle2").Cells(n, 2) = .Cells(i + 1, 1)

    n = n + 1

    End If

    Next

    Next

    End With



    End Sub

    Mit freundlichen Grüßen

    Claus
  7. User Advert


    Hi,

    willkommen im Windows Forum!
Thema:

Excel for iPad - moving of cells, rows or columns does no longer work - Microsoft Office

Die Seite wird geladen...

Excel for iPad - moving of cells, rows or columns does no longer work - Similar Threads - Excel for iPad

Forum Datum

Text highlight switches off itself, continuous highlighting does not work

Text highlight switches off itself, continuous highlighting does not work: Hi All! Can you please enlighten me on the following topic. I have 2 computers, one office computer, one private. It is Word 2016 on both. Office laptop is windows 10, private is windows 8. All...
Microsoft Office 18. August 2019

#Value error INDEX MATCH multiple search with rows and columns

#Value error INDEX MATCH multiple search with rows and columns: Good day, dear all, I am struggling to understand why my formula is not working. Tried using CTRL + SHIFT + ENTER but it still doesn't work. {=INDEX('FIN SERV'!$CQ7:$EY60;MATCH(P$5;'FIN...
Microsoft Office 14. Juni 2019

iMac HD exchanged - MS Office 2016(with key) no longer works. Alex helped yesterday but not...

iMac HD exchanged - MS Office 2016(with key) no longer works. Alex helped yesterday but not...: In November 2017 I bought a new iMac with MS Office 2016. They had to replace the hard disk this week(November 2018). The Mac runs good, but when I downloaded Office 2016, although the programs...
Microsoft Office 11. November 2018

Windows Vista upgrade kit for windows 7 does not work

Windows Vista upgrade kit for windows 7 does not work: OK, I have an older computer (Acer X3300). I was running windows 7 ( upgrade from original Vista to 7 with the upgrade kit)....but I was experiencing problems so I had to flatten my system ( I...
Allgemeines 6. Oktober 2018

Windows Vista upgrade kit for windows 7 does not work

Windows Vista upgrade kit for windows 7 does not work: OK, I have an older computer (Acer X3300). I was running windows 7 ( upgrade from original Vista to 7 with the upgrade kit)....but I was experiencing problems so I had to flatten my system ( I...
Allgemeines 5. August 2018

Excel - moving blinking minuses

Excel - moving blinking minuses: on entering data into a1 and a2 a border of moving minus signes surrounded the two fields. Why and how can I stop it. thanks
Microsoft Office 3. April 2018

Replace command does not work correctly - MS Word 2016

Replace command does not work correctly - MS Word 2016: In MS Word 2016 replace command does not replace high quotation marks (ASCII 132) by closing guillemets (ASCII 187) and low quotation marks by opening guillemets as I need it to typeset specific...
Microsoft Office 26. September 2017
Excel for iPad - moving of cells, rows or columns does no longer work solved
  1. Diese Seite verwendet Cookies, um Inhalte zu personalisieren, diese deiner Erfahrung anzupassen und dich nach der Registrierung angemeldet zu halten.
    Wenn du dich weiterhin auf dieser Seite aufhältst, akzeptierst du unseren Einsatz von Cookies.