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
JBF_54's avatar
JBF_54
Brass Contributor
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
      • JBF_54's avatar
        JBF_54
        Brass Contributor
        Feb 17, 2020
        But won't that break all the formula on the other sheets (which were deleted to send you the sample data) that refer to the existing tab and table?

Resources