I have a spreadsheet that has extra cells at the bottom which are empty. They seem to go to infinity. How can I delete them. I didn't create the spreadsheet.
It looks like it just has a border that goes on forever (no data inside).
Please help.
I have a spreadsheet that has extra cells at the bottom which are empty. They seem to go to infinity. How can I delete them. I didn't create the spreadsheet.
It looks like it just has a border that goes on forever (no data inside).
Please help.
Hi chakotay, and welcome to the forum.
For starters, can you select all of those rows of cells, then right-click on the selection and choose Delete?
Ok, I guess then my question really is, how do I select from current point to end (infinity)?
If you want to delete from row 230 down to "infinity" (aka "row 65536" in Office 2003 and earlier), then:
1. Select row 230
2. While holding down SHIFT, tap the END key then tap the DOWN ARROW; this will select every row from 230-65536
3. Click Edit -> Delete (or right-click on the selected rows and choose Delete)
Great! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks