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. DaveM121 Win User

    Excel formatting problem

    Hi Felix,

    I am Dave, I will help you with this.

    Enter a ' character in the cell and then the very long number does that stop Excel formatting the number like that?

    For example, if you are entering 123456789 in a cell, enter '123456789
  5. Axel Bier Win User

    Warum kann man im aktuellen XLS nicht mehr Bilder in Tabellen in andere Bereiche durch Formeln kopieren?

    Hi, thanks for your reply.
    The Version is MS office 365, Excel 2208.
    I know how to insert graphics in XLS, but if one photo is in a cell, there is no way to simply get that image into another cell just by typing "=A2".
    Years ago that was easy to do, like that.
    Now, e.g. doing a list of products with photos, it takes hours to use the "work around" getting images to the define cell from another table.
    My question: why had that been changed and for what reason?
    I thought a cell content is a cell content, either text or images, I see no difference handling the "content".
    Honestly I miss that "old" functionality since years, and looking in YouTube you see lots of videos helping to get that simple job done - in 10-15 minutes.... Got it ? :)
    BR
    Axel
  6. 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
  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

HTML Code does not work for Signature

HTML Code does not work for Signature: I am getting really frustrated. I have a perfectly working HTML Signature, which works for all the other email clients I am using, but when I try to add it in Outlook, it just shows the code but...
Outlook.com 14. Februar 2024

Microsoft Learning Pathways videos from a custom playlist no longer work

Microsoft Learning Pathways videos from a custom playlist no longer work: Hi everyone, I have created a customized Microsoft Learning pathway playlist for the tools OneDrive, SharePoint, Teams, etc. However, the videos within the learning pathway do not work anymore,...
Microsoft Office 23. Januar 2024

Setup of Outlook in Windows 11 does not work

Setup of Outlook in Windows 11 does not work: Outlook Setup bringt die Nachricht:WIr konnten keine Verbindung unter Verwendung der angegebenen Verschlüsselungsmethode mit dem eingehend IMAP-Server herstellen. Überprüfen nsie die...
Outlook.com 25. Dezember 2023

“The item might not exist or is no longer available”.

“The item might not exist or is no longer available”.: My recent files in Documents got lost. I never intended to synchronize my Documents, therefore I deleted the folder from the OneDrive folder on one of my Windows PC. And behold, it disappeared on...
Apps 14. Juli 2023

“The item might not exist or is no longer available”.

“The item might not exist or is no longer available”.: My recent files in Documents got lost. I never intended to synchronize my Documents, therefore I deleted the folder from the OneDrive folder on one of my Windows PC. And behold, it disappeared on...
Games und Spiele 14. Juli 2023

Surface Book 3 keyboard backlight no longer works, solution?

Surface Book 3 keyboard backlight no longer works, solution?: HelloI have a problem with my keyboard on the Surface Book 3. The backlight no longer works, although it worked perfectly at first. For some time now, the backlight has suddenly gone out....
Surface 25. Juni 2023

Sharepoint no longer released for membergroup

Sharepoint no longer released for membergroup: Hello. In one of my Teams/Sharepoint the membergroup don't have access any more. How can i give them the permissions again?
Microsoft Office 21. April 2023
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.
    Auf dieser Website werden Cookies für die Zugriffsanalyse und Anzeigenmessung verwendet.
    Wenn du dich weiterhin auf dieser Seite aufhältst, akzeptierst du unseren Einsatz von Cookies.