[nabs-l] Excel question

Philip S philso1003 at gmail.com
Wed Oct 27 22:47:44 UTC 2010


Hi Sean,
Thanks for the clarification. Yeah the Ctrl arrows to move to
beginning work only if the whole row or column is empty. Do you know
how to move to the top of a column then when there's data?  Let's say
to move from B80 to B1, with data in all the cells except say for B40.
Thanks.
philip


On 10/27/10, Sean Whalen <smwhalenpsp at gmail.com> wrote:
> Control plus up, down, left, or right arrow will move you to the edge of a
> region, but not necessarily the beginning or end of a row or column. For
> example, if you have data in column A from A1 down to A100, but no data in
> cell A50, pressing control plus down arrow while you are in cell A1 will
> take you down to A49, and not A100. Pressing control up arrow while in cell
> A100 will take you to cell A51. Similarly, if you have column B empty except
> for cells B25 and B50, which have data in them, pressing control down arrow
> while in cell B1 will take you to the first cell containing data, B25.
> Another press of control down arrow will take you to B50. This is a great
> way to scan for records that are missing data in a particular column.
>
> One other note: pressing "home" will always take you to the first cell in a
> row, regardless of whether or not it is filled.
>
> Hope it's useful,
>
> Sean
>
>
> _______________________________________________
> nabs-l mailing list
> nabs-l at nfbnet.org
> http://www.nfbnet.org/mailman/listinfo/nabs-l_nfbnet.org
> To unsubscribe, change your list options or get your account info for
> nabs-l:
> http://www.nfbnet.org/mailman/options/nabs-l_nfbnet.org/philso1003%40gmail.com
>




More information about the NABS-L mailing list