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

Question

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

Report

lenice - Mar 23, 2011 at 01:03 PM
TrowaD

Posts: 2697
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: February 23, 2021

- 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.

Delete cells/rows but keep row info intact
VBA: Delete empty rows based on value of cells ✓ - Forum - Excel
Excel - A macro to delete alternate rows - How-To - Office Software
How to delete one row in word - How-To - Word
Macro to Deleting Multiple Rows ✓ - Forum - Excel
Macro to delete blank rows? ✓ - Forum - Excel

2 replies

Ask a question

rizvisa1 · Answer 1 · 2011-03-23T13:08:26-0400

Answer 1 / 2

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

764
Mar 23, 2011 at 01:08 PM

why not use CLEAR instead of delete ?

TrowaD · Answer 2 · 2011-03-25T10:55:55-0400

Answer 2 / 2

TrowaD

Posts: 2697
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: February 23, 2021

457
Mar 25, 2011 at 10:55 AM

?????
You want to remove the contents of empty cells/rows?
?????

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

2 replies

Your reply

Subscribe To Our Newsletter!