Feedback by UserVoice

Ben

My feedback

  1. 808 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.

    Thanks,
    John [MS XL]

    An error occurred while saving the comment
    Ben commented  · 

    @Ivan I think you missed the point: The ability to skip over cells that are NULL as the result of a formula computation is a desired behavior.

    An error occurred while saving the comment
    Ben commented  · 

    @Ivan Does CTRL+arrow skip over those cells as if they were as empty as they appear to be? No. That's part of why we need a function which returns true NULL.

    An error occurred while saving the comment
    Ben commented  · 

    First260: that does not provide the functionality of using some formula to flag "interesting" rows (or columns) with others as blank, and using CTRL+arrow to skip over the blank ranges.

    An error occurred while saving the comment
    Ben commented  · 

    CTRL+arrow jumps to the "edge" of contiguous data-containing cell blocks. You can use this to skip large contiguous blocks of empty cells to jump to what may be relative anomalies. If a cell has a formula setting it up to contain a value if a certain condition is met, and be blank otherwise, this trick doesn't work and you have to manually scan/scroll through. A proper NULL() function should allow those blank cells to be skipped over in bulk.

    Ben supported this idea  · 

Feedback and Knowledge Base