Delete cells/rows but keep row info intact

[Solved/Closed]
Report
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
hello,
I am trying to import data from an excel spread sheet to access. I want to clean up my excel report before I import the date. In my report, my cells overlap. I need to delete "blank" cells/rows, but when I delete them, using "editing" and "delete cells" it moves all the cells up and does not keep the data in the same rows, thus moving my totals. I have tried coping and pasting special, values only, but the cells over lap and again I cannot keep my totals in rows.
thank you for your help.


2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
why not use CLEAR instead of delete ?
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
?????
You want to remove the contents of empty cells/rows?
?????