Forum Discussion
chipg900
Feb 16, 2020Copper Contributor
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.
PReagan
Bronze Contributor
JBF_54
Feb 17, 2020Brass Contributor
Is there a way to send you the file without it being posted for the whole world to see?
- PReaganFeb 17, 2020Bronze ContributorI would recommend removing any sensitive information or replacing it with dummy data and attaching it as a reply to this thread.
- JBF_54Feb 17, 2020Brass Contributor
I deleted all tabs except the one of concern. That generated some #REF! errors that can be ignored with respect to the Cntrl-End problem.
Thanks ...
- PReaganFeb 17, 2020Bronze Contributor
For some reason, copying and pasting the data into a new tab resets the last used cell. To do this:
- Start in cell A1
- Press Ctrl+Shift+Right Arrow+Down Arrow
- Ctrl + C
- Insert a new worksheet and Ctrl + P to paste data starting in cell A1
- Press Ctrl + End to ensure that this takes you to the last used cell