Blank cells and empty cells

[tanababa]

Hi,
I have selected all cells in my sheet and did "clean all".
When I press CTRL+END the cursor goes to cell R202. The sheet should be empty!
When I use the "goto special..." window and command it to go to blank cells I get a whole range from A1 to R202 selected.
How do I get rid of that?
What is the difference between a blank cell to an empty cell?
Thank you,
Tamir

 

[Aladin Akyurek]

Hi,
I have selected all cells in my sheet and did "clean all".
When I press CTRL+END the cursor goes to cell R202. The sheet should be empty!
When I use the "goto special..." window and command it to go to blank cells I get a whole range from A1 to R202 selected.
How do I get rid of that?
What is the difference between a blank cell to an empty cell?
Thank you,
Tamir

A cell, say A2, is referred to as a blank cell when:

=COUNTA(A2)

==> 1

=ISBLANK(A2)

==> FALSE

Such evaluations generally obtain if A2 houses a formula returning "" as result.

A cell is empty if it's unused and when:

=COUNTA(A2)

==> 0

or

=ISBLANK(A2)

==> TRUE

Blank and empty are also used interchangeably, specifically if the context permits such.

 

[tanababa]

I checked and the cells A1:P202 are all empty.
=COUNTA(A1:P202) returns 0.
So... why CTRL+END goes to cell P202?
Thankx,
Tamir

p.s - will it help if I load the file to a server and put a link?

 

[Aladin Akyurek]

I checked and the cells A1:P202 are all empty.
=COUNTA(A1:P202) returns 0.
So... why CTRL+END goes to cell P202?
Thankx,
Tamir

p.s - will it help if I load the file to a server and put a link?

What do you get with:

A2:

=LEN(P202)

B2:

=CODE(P202)

 

[tanababa]

ctrl+end go to cell R202.

=CODE(R202)
==>#VALUE

=LEN(R202)
==>0

see file:
http://cid-80fec7e3752c4b76.office.live.com/view.aspx/EXCELPUBLIC/blank or empty cells.xls

 

[Aladin Akyurek]

ctrl+end go to cell R202.

=CODE(R202)
==>#VALUE

=LEN(R202)
==>0

see file:
http://cid-80fec7e3752c4b76.office.live.com/view.aspx/EXCELPUBLIC/blank or empty cells.xls

See whether these help:

http://www.mrexcel.com/forum/showthread.php?t=554553&highlight=reset+cell

http://www.mrexcel.com/forum/showthread.php?t=216846&highlight=reset+cell

 

[tanababa]

Bingo...
The solution for me is:
"...to reset the last cell, is like mention delete all rows and coloums that are not used then select cell A1 and save..." from http://www.mrexcel.com/forum/showthread.php?t=216846&highlight=reset+cell

However, I still did not understand the difference in definition or in terms of excel between blank vs. empty cell ( I understood wjat the result of the various functions will do to those cells...)
Thanks,
Tamir

 

[JackDanIce]

A blank cell appears empty - it contains characters that are not visible to the user, i.e. LEN(A1) of such a cell is a positive integer

An empty cell contains nothing at all, i.e. LEN(A1) of such a cell is 0

 

[Aladin Akyurek]

Bingo...
The solution for me is:
"...to reset the last cell, is like mention delete all rows and coloums that are not used then select cell A1 and save..." from http://www.mrexcel.com/forum/showthread.php?t=216846&highlight=reset+cell

That's great.

However, I still did not understand the difference in definition or in terms of excel between blank vs. empty cell ( I understood wjat the result of the various functions will do to those cells...)
Thanks,
Tamir

In A1 enter:

=""

In B1 enter:

=IF(C1="","",10)

Both A1 and B1 will "look" empty, but they are not. They house formulas returning/calculating nothing. Such cells are "blank". Unused, untouched cella are often referred as empty cells, but also as blank. The latter usage might create some confusion.