Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Delete cells/rows but keep row info intact [Solved/Closed]

Report
-
Posts
2657
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 22, 2020
 -
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.


See more

2 replies

Answer 1 / 2
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 760
why not use CLEAR instead of delete ?
Answer 2 / 2
Posts
2657
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 22, 2020
 440
?????
You want to remove the contents of empty cells/rows?
?????
Ask a question