I write in hope. I’m experimenting with using Google Docs as I would a localized office tools package, and I’ve discovered an unwelcome drawback.
I have a four-column spreadsheet. I need to insert data into a new row in the middle of the data, but only in columns three and four. All goes well when creating a new row in the correct location and entering the information, but then I’m presented with two empty cells in columns one and two on that same row.
In Excel and Open Office I could highlight those two cells and select “Edit” from the dropdown menu and then “Delete”; I’d be offered a choice of moving the cells below that point in the columns to the left, to the right, up or down. In Google Docs that option doesn’t appear to exist. All I’m presented with is “Delete Row X.”
I don’t want to delete the entire row; I have perfectly good data in columns three and four of that row.
I see that there are outstanding requests for this feature in your Help Center dating back to March of 2009. Is this so hard to do?
I await your reply.
Cordially,
Link