Message for Juan Pablo G.

ar · May 22nd, 2002, 11:59 AM

This is regarding to the message at

http://www.mrexcel.com/board/viewtop...9137&forum=2&1

You told me how to get rid of empty cells but I’m not quite sure how to do it. Can you give me step by step instructions? Thanks.

Ivan F Moala · May 24th, 2002, 02:37 AM

Quote:

On 2002-05-22 10:59, ar wrote:
This is regarding to the message at

http://www.mrexcel.com/board/viewtop...9137&forum=2&1

You told me how to get rid of empty cells but I’m not quite sure how to do it. Can you give me step by step instructions? Thanks.

The easiest way to reset your range without coding is to simply Save your workbook.

Otherwise you will have to use code.
Repost if interested..

PDuPre' · May 24th, 2002, 05:40 AM

To get rid of the cells, instead of just clearing them ...
highlight all the cells you want, in this case entire rows or columns. Hit the right mouse button and hit delete. If you just hit the delete key it would only clear the contents. Choosing delete actually gets rid of the cell entirely.
- However, it does not solve your problem. That is, it will not reset the used cell range. The best way is to just hit save.

Philip

[Edit] I am using Excel '97

[ This Message was edited by: PDuPre' on 2002-05-24 04:41 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 11:59 AM	#1
ar New Member Join Date: Mar 2002 Posts: 24	This is regarding to the message at http://www.mrexcel.com/board/viewtop...9137&forum=2&1 You told me how to get rid of empty cells but I’m not quite sure how to do it. Can you give me step by step instructions? Thanks.

May 24th, 2002, 05:40 AM	#3
PDuPre' Board Regular Join Date: Apr 2002 Location: Trussville, AL Posts: 134	To get rid of the cells, instead of just clearing them ... highlight all the cells you want, in this case entire rows or columns. Hit the right mouse button and hit delete. If you just hit the delete key it would only clear the contents. Choosing delete actually gets rid of the cell entirely. - However, it does not solve your problem. That is, it will not reset the used cell range. The best way is to just hit save. Philip [Edit] I am using Excel '97 [ This Message was edited by: PDuPre' on 2002-05-24 04:41 ]