PC Review


Reply
Thread Tools Rate Thread

Clearing Empty Cells.

 
 
Michael Koerner
Guest
Posts: n/a
 
      1st Jul 2007
Using Excel 2007, when I click on Ctrl+End, it puts the cursor in a cell in
never never land which is not even close to the last cell with data. how do
I clear all of these so-called empty cells? TIA

--

Regards
Michael Koerner



 
Reply With Quote
 
 
 
 
shah shailesh
Guest
Posts: n/a
 
      1st Jul 2007
See below page by Debra .

http://contextures.com/xlfaqApp.html#Unused


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.


"Michael Koerner" <(E-Mail Removed)> wrote in message
news:%23uYgKK%(E-Mail Removed)...
> Using Excel 2007, when I click on Ctrl+End, it puts the cursor in a cell
> in never never land which is not even close to the last cell with data.
> how do I clear all of these so-called empty cells? TIA
>
> --
>
> Regards
> Michael Koerner
>
>
>



 
Reply With Quote
 
Michael Koerner
Guest
Posts: n/a
 
      1st Jul 2007
Thanks, I'll give that a try.

--

Regards
Michael Koerner


"shah shailesh" <(E-Mail Removed)> wrote in message
news:%23eeCNP%(E-Mail Removed)...
> See below page by Debra .
>
> http://contextures.com/xlfaqApp.html#Unused
>
>
> Regards,
> Shailesh Shah
> http://in.geocities.com/shahshaileshs/
> (Excel Add-ins Page)
> If You Can't Excel with Talent, Triumph with Effort.
>
>
> "Michael Koerner" <(E-Mail Removed)> wrote in message
> news:%23uYgKK%(E-Mail Removed)...
>> Using Excel 2007, when I click on Ctrl+End, it puts the cursor in a cell
>> in never never land which is not even close to the last cell with data.
>> how do I clear all of these so-called empty cells? TIA
>>
>> --
>>
>> Regards
>> Michael Koerner
>>
>>
>>

>
>



 
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
Clearing cells but also not clearing other dependent cells rtlars Microsoft Excel Programming 4 13th Mar 2010 04:46 AM
clearing values of cells in named range(s) so the cells are empty BRC Microsoft Excel Programming 1 10th Jan 2010 06:54 AM
Clearing cells without clearing formulas marsjune68 Microsoft Excel Misc 2 10th Apr 2009 07:39 PM
Filter, clearing visible cells in a range, but leaving hidden cells Jason Chapman Microsoft Excel Discussion 2 27th Jun 2008 02:15 PM
macro to colour empty cells (cells not recognized as empty) Gerben Microsoft Excel Programming 5 30th Jun 2005 03:29 PM


Features
 

Advertising
 

Newsgroups
 


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