• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

If I press Ctrl+down, it was if text or number or blank go to last cell

sivaprakasam

New Member
Hi i have try to blank cell format in formula

If I press Ctrl+down, we want to go the cell (number or text) end, but it was if text or number or blank go to last cell

any provide the formula for empty cell format through formula
 

Attachments

Chihiro

Excel Ninja
Your blanks are not true blanks.

Just select G2:G29 hit Delete key.

Now, when you hit CTRL + Down Arrow, selection will jump to G30 as it should.
 
Top