Delete cells/rows but keep row info intact

Solved/Closed
lenice - Mar 23, 2011 at 01:03 PM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Mar 25, 2011 at 10:55 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Mar 23, 2011 at 01:08 PM
why not use CLEAR instead of delete ?
0
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Mar 25, 2011 at 10:55 AM
?????
You want to remove the contents of empty cells/rows?
?????
0