+ Reply to Thread
Results 1 to 4 of 4

After cutting & pasting the whole row Excel contracts original now-empty rows

  1. #1
    Registered User
    Join Date
    04-11-2020
    Location
    Europe
    MS-Off Ver
    365
    Posts
    16

    After cutting & pasting the whole row Excel contracts original now-empty rows

    Cut paste.png

    So I was often cutting/pasting full rows from one sheet to another. Before, the original sheet would just have those rows removed from the sheet after paste is done. Suddenly, when doing the same cut/paste operation I see different result in the original sheet - those rows that I cut/pasted just get to row height 0 (not even hidden). And now every time I have to expand those rows and delete them manually after cut/paste is done. Any idea why?

  2. #2
    Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    115

    Re: After cutting & pasting the whole row Excel contracts original now-empty rows

    Can you post a copy of your worksheet?

  3. #3
    Registered User
    Join Date
    04-11-2020
    Location
    Europe
    MS-Off Ver
    365
    Posts
    16

    Re: After cutting & pasting the whole row Excel contracts original now-empty rows

    Added now.

    Another weird view you can see there when I removed all the rows below I see now grey area instead of regular Excel view..
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    115

    Re: After cutting & pasting the whole row Excel contracts original now-empty rows

    Not sure how but somehow your rows had different sizes and then were hidden.

    So here is what I did. Select all.
    Move your mouse between rows 1 and 4 (the mouse should change where it is an up and down arrow)
    Then move your mouse down and the rows should appear.
    You then should be able to double-click on the rows and it should auto-format the row height.

    Let me know if you still have issues with copy and paste
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Cutting and pasting Filtered Rows
    By exnyorker55 in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 02-14-2018, 10:37 PM
  2. Trouble cutting and pasting rows
    By BrianSells in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-06-2015, 02:53 PM
  3. cutting and pasting row in other sheet if cell is empty
    By flunzy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-02-2014, 09:42 AM
  4. Cutting and Pasting rows loopwise as per the same value in Proposal(Column E)
    By mvneema in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2014, 04:40 PM
  5. Inserting, Cutting, and Pasting Rows Based on What's in a Cell
    By 4EverLearning in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-05-2010, 04:42 PM
  6. Cutting/Pasting Rows based on content PT 2
    By Lmsloman in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-21-2006, 06:36 AM
  7. Replies: 7
    Last Post: 02-14-2006, 03:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1