Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Deleting lines #280

Closed
marcofaga opened this issue Mar 16, 2023 · 3 comments
Closed

Deleting lines #280

marcofaga opened this issue Mar 16, 2023 · 3 comments
Labels
reprex needs a minimal reproducible example

Comments

@marcofaga
Copy link

Hi!!

Is it possible to delete a range of cells without shifting the other cells? I only want to erase all the rows within a specific range, without replacing them. For example, I have a sheet ranging from A1:J1000. I want to wipe out all lines from A8:J1000.
@jennybc
Copy link
Member

jennybc commented Mar 23, 2023

Do you want to clear cell contents but the cells should still exist?

@jennybc jennybc added the reprex needs a minimal reproducible example label Mar 23, 2023
@marcofaga
Copy link
Author

No. I want to remove all empty cells after A7. From A8:J1000. With no replacements. To have the worksheet view showing only the range A1:ZZ7

@jennybc
Copy link
Member

jennybc commented Mar 23, 2023

If I follow, I think you might want range_delete() or sheet_resize().

@jennybc jennybc closed this as completed Mar 23, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
reprex needs a minimal reproducible example
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@jennybc @marcofaga