Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Getting rid of empty cells
I have a column with values in cells A1, A2, A3, A7, A8, A9. Is there a way
to have the values in cells A7, A8, A9 move to cells A4, A5, A6 with cutting and pasting. I have a lot of values and empty cells so if there is a formula that would be a lot quicker than cutting and pasting. Thanks. |
#2
|
|||
|
|||
If the rest of the row is empty, why not just sort by blanks and delete en
masse? -- Don Guillett SalesAid Software "Jambruins" wrote in message ... I have a column with values in cells A1, A2, A3, A7, A8, A9. Is there a way to have the values in cells A7, A8, A9 move to cells A4, A5, A6 with cutting and pasting. I have a lot of values and empty cells so if there is a formula that would be a lot quicker than cutting and pasting. Thanks. |
#3
|
|||
|
|||
Jam
Select A4, 5 and 6 then EditDeleteShift Up. Gord Dibben Excel MVP On Tue, 22 Feb 2005 05:41:06 -0800, Jambruins wrote: I have a column with values in cells A1, A2, A3, A7, A8, A9. Is there a way to have the values in cells A7, A8, A9 move to cells A4, A5, A6 with cutting and pasting. I have a lot of values and empty cells so if there is a formula that would be a lot quicker than cutting and pasting. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trendlines to ignore empty cells | Charts and Charting in Excel | |||
How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions | |||
CountIF cells are not empty | Excel Discussion (Misc queries) | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) |