Forum Discussion

chipg900's avatar
chipg900
Copper Contributor
Feb 16, 2020

Deleting unwanted rows and columns

Could someone please tell me the simplest way to delete the unwanted rows and columns at the end of spreadsheets and just to save the the ones I need? Thank you.
Excel
PReagan's avatar
PReagan
Bronze Contributor

JBF_54 

 

Can you please share a sample file so that I can facilitate testing?

JBF_54's avatar
JBF_54
Brass Contributor
Feb 17, 2020
Is there a way to send you the file without it being posted for the whole world to see?
  • PReagan's avatar
    PReagan
    Bronze Contributor
    Feb 17, 2020
    I would recommend removing any sensitive information or replacing it with dummy data and attaching it as a reply to this thread.
      • PReagan's avatar
        PReagan
        Bronze Contributor
        Feb 17, 2020

        JBF_54 

         

        For some reason, copying and pasting the data into a new tab resets the last used cell. To do this:

        1. Start in cell A1
        2. Press Ctrl+Shift+Right Arrow+Down Arrow
        3. Ctrl + C
        4. Insert a new worksheet and Ctrl + P to paste data starting in cell A1
        5. Press Ctrl + End to ensure that this takes you to the last used cell

Resources