Deleting lines
Closed this issue · 3 comments
marcofaga commented
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 commented
Do you want to clear cell contents but the cells should still exist?
marcofaga commented
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 commented
If I follow, I think you might want range_delete()
or sheet_resize()
.