PC Review


Reply
Thread Tools Rate Thread

How to delete all the blanc cells in a worksheet and shift cells l

 
 
=?Utf-8?B?dGlyYW1pc3U=?=
Guest
Posts: n/a
 
      7th Dec 2006
There are a lot of blanc cells in a worksheet, and now I want to select all
of them, delete and shift cells left. is there a function to realize it? or
macro?

Thank you~

 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      7th Dec 2006
Select the range
edit|goto|special|blanks
Edit|delete (shift left)

If you need a macro, you can record one when you do it manually.

tiramisu wrote:
>
> There are a lot of blanc cells in a worksheet, and now I want to select all
> of them, delete and shift cells left. is there a function to realize it? or
> macro?
>
> Thank you~


--

Dave Peterson
 
Reply With Quote
 
T. Valko
Guest
Posts: n/a
 
      7th Dec 2006
Hit function key F5

Special>Blanks>OK

This will select all blank cells in the used range.

Then:

Edit>Delete>Shift cells left>OK

Biff

"tiramisu" <(E-Mail Removed)> wrote in message
news:51135B75-F01D-4A11-844B-(E-Mail Removed)...
> There are a lot of blanc cells in a worksheet, and now I want to select
> all
> of them, delete and shift cells left. is there a function to realize it?
> or
> macro?
>
> Thank you~
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete and Shift Cells up matt Microsoft Excel Programming 3 16th Jul 2008 09:21 PM
error message: Unable to shift cells off worksheet =?Utf-8?B?U2FuZHJh?= Microsoft Excel Crashes 1 29th Jan 2007 09:06 PM
Delete cells with text, and shift cells left? Ryk Microsoft Excel Discussion 1 10th Nov 2006 06:40 AM
Delete cells with text and shift left? Ryk Microsoft Access Macros 1 10th Nov 2006 03:03 AM
Delete - Shift Cells UP problem =?Utf-8?B?UmFscGg=?= Microsoft Excel Misc 3 22nd Mar 2005 11:19 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:52 PM.