Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Navigate to specific cells using Ctrl+arrow keys

image description

image description

Greetings All,

I regularly use Ctrl+downarrow to find next values in columns in Calc.

I made a diary recently.

I used conditional formatting to highlight the current day in red, as shown in Image 2. Lovely.

I'd like to use Ctrl+downarrow to move to the current day, but of course I can't because all the cells in that column (C) contain formulas and resultant values.

So, I made a formula that shows TX in column A if the value of the adjacent cell C == C1. You can see, for example, that C70 == C1 in the images. Again, just what I wanted.

When the sheet opened I tried using Ctrl+downarrow (in column A) to jump to A70 (the current day and the only cell showing TX). The problem is that Ctrl+downarrow jumps not only to cells with displayed values, but also to cells containing formulas even though such cells aren't displaying any values.

Effectively, it moves down to the last cell in column A with a formula (A365 in this sheet) rather than to the next displayed value (TX). Not what I wanted.

I'd like to find, or create, a key combination that finds only the next cell with a displayed value in column A and doesn't include cells that display nothing but which contain formulas.

Here's what's in my cells:

C1 contains =TODAY()
C2 contains 01/01/2018
C3 contains =C2+1 The remaining cells in column C continue to reference the cells above them.

A70 (and all the cells above and below it) contains =IF(C70=C$1,"TX","")

(The numbers in column B are just the manually entered week numbers, in case anyone was wondering)

Thanks in advance for any help offered.

Navigate to specific cells using Ctrl+arrow keys

image description

image description

Greetings All,

I regularly use Ctrl+downarrow to find next values in columns in Calc.

I made a diary recently.

I used conditional formatting to highlight the current day in red, as shown in Image 2. Lovely.

I'd like to use Ctrl+downarrow to move to the current day, but of course I can't because all the cells in that column (C) contain formulas and resultant values.

So, I made a formula that shows TX in column A if the value of the adjacent cell C == C1. You can see, for example, that C70 == C1 in the images. Again, just what I wanted.

When the sheet opened I tried using Ctrl+downarrow (in column A) to jump to A70 (the current day and the only cell showing TX). The problem is that Ctrl+downarrow jumps not only to cells with displayed values, but also to cells containing formulas even though such cells aren't displaying any values.

Effectively, it moves down to the last cell in column A with a formula (A365 in this sheet) rather than to the next displayed value (TX). Not what I wanted.

I'd like to find, or create, a key combination that finds only the next cell with a displayed value in column A and doesn't include cells that display nothing but which contain formulas.

Here's what's in my cells:

image description

image description

C1 contains =TODAY()
C2 contains 01/01/2018
C3 contains =C2+1 The remaining cells in column C continue to reference the cells above them.

A70 (and all the cells above and below it) contains =IF(C70=C$1,"TX","")

(The numbers in column B are just the manually entered week numbers, in case anyone was wondering)

Thanks in advance for any help offered.

Navigate to specific cells using Ctrl+arrow keys

Greetings All,

I regularly use Ctrl+downarrow to find next values in columns in Calc.

I made a diary recently.

I used conditional formatting to highlight the current day in red, as shown in Image 2. Lovely.

I'd like to use Ctrl+downarrow to move to the current day, but of course I can't because all the cells in that column (C) contain formulas and resultant values.

So, I made a formula that shows TX in column A if the value of the adjacent cell C == C1. You can see, for example, that C70 == C1 in the images. Again, just what I wanted.

When the sheet opened I tried using Ctrl+downarrow (in column A) to jump to A70 (the current day and the only cell showing TX). The problem is that Ctrl+downarrow jumps not only to cells with displayed values, but also to cells containing formulas even though such cells aren't displaying any values.

Effectively, it moves down to the last cell in column A with a formula (A365 in this sheet) rather than to the next displayed value (TX). Not what I wanted.

I'd like to find, or create, a key combination that finds only moves to the next cell with a displayed value in column A and doesn't include cells that display nothing but which contain formulas.

image description

image description

C1 contains =TODAY()
C2 contains 01/01/2018
C3 contains =C2+1 The remaining cells in column C continue to reference the cells above them.

A70 (and all the cells above and below it) contains =IF(C70=C$1,"TX","")

(The numbers in column B are just the manually entered week numbers, in case anyone was wondering)

Thanks in advance for any help offered.

Navigate to specific cells using Ctrl+arrow keys

Greetings All,

I regularly use Ctrl+downarrow to find next values in columns in Calc.

I made a diary recently.

I used conditional formatting to highlight the current day in red, as shown in Image 2. the lower image. Lovely.

I'd like to use Ctrl+downarrow to move to the current day, but of course I can't because all the cells in that column (C) contain formulas and resultant values.

So, I made a formula that shows TX in column A if the value of the adjacent cell C == C1. You can see, for example, that C70 == C1 in the images. Again, just what I wanted.

When the sheet opened I tried using Ctrl+downarrow (in column A) to jump to A70 (the current day and the only cell showing TX). The problem is that Ctrl+downarrow jumps not only to cells with displayed values, but also to cells containing formulas even though such cells aren't displaying any values.

Effectively, it moves down to the last cell in column A with a formula (A365 in this sheet) rather than to the next displayed value (TX). Not what I wanted.

I'd like to find, or create, a key combination that moves to the next cell with a displayed value in column A and doesn't include cells that display nothing but which contain formulas.

image description

image description

C1 contains =TODAY()
C2 contains 01/01/2018
C3 contains =C2+1 The remaining cells in column C continue to reference the cells above them.

A70 (and all the cells above and below it) contains =IF(C70=C$1,"TX","")

(The numbers in column B are just the manually entered week numbers, in case anyone was wondering)

Thanks in advance for any help offered.

Navigate to specific cells using Ctrl+arrow keys

Greetings All,

I regularly use Ctrl+downarrow to find move to the next values cell containing a value in columns in Calc.

I made a diary recently.

I used conditional formatting to highlight the current day in red, as shown in the lower image. Lovely.

I'd like to use Ctrl+downarrow to move to the current day, but of course I can't because all the cells in that column (C) contain formulas and resultant values.

So, I made a formula that shows TX in column A if the value of the adjacent cell C == C1. You can see, for example, that C70 == C1 in the images. Again, just what I wanted.

When the sheet opened I tried using Ctrl+downarrow (in column A) to jump to A70 (the current day and the only cell showing TX). The problem is that Ctrl+downarrow jumps not only jumps to cells with displayed values, but also to cells containing formulas even though such cells aren't displaying any values.

Effectively, it moves down to the last cell in column A with a formula (A365 in this sheet) rather than to the next displayed displayed value (TX). Not what I wanted.

I'd like to find, or create, a key combination that moves to the next cell with a displayed value in column A and doesn't include cells that display nothing but which contain formulas.

image description

image description

C1 contains =TODAY()
C2 contains 01/01/2018
C3 contains =C2+1 The remaining cells in column C continue to reference the cells above them.

A70 (and all the cells above and below it) contains =IF(C70=C$1,"TX","")

(The numbers in column B are just the manually entered week numbers, in case anyone was wondering)

Thanks in advance for any help offered.

Navigate to specific cells using Ctrl+arrow keys

Greetings All,

I regularly use Ctrl+downarrow to move to the next cell containing a value in columns in Calc.

I made a diary recently.

I used conditional formatting to highlight the current day in red, as shown in the lower image. Lovely.

I'd like to use Ctrl+downarrow to move to the current day, but of course I can't because all the cells in that column (C) contain formulas and resultant values.

So, I made a formula that shows TX TX in column A if the value of the adjacent cell C == C1. You can see, for example, that C70 == C1 in the images. Again, just what I wanted.

When the sheet opened I tried using Ctrl+downarrow (in column A) to jump to A70 A70 (the current day and the only cell showing TX). The problem is that Ctrl+downarrow not only jumps to cells with displayed values, but also to cells containing formulas even though such cells aren't displaying any values.

Effectively, it moves down to the last cell in column A with containing a formula (A365 in this sheet) rather than to the next cell displayeddisplaying a value (TX). Not what I wanted.

I'd like to find, or create, a key combination that moves to the next cell with a displayed value in column A and doesn't include cells that display nothing but which contain formulas.

image description

image description

C1 contains =TODAY()
C2 contains 01/01/2018
C3 contains =C2+1 The remaining cells in column C continue to reference the cells above them.

A70 (and all the cells above and below it) contains =IF(C70=C$1,"TX","")

(The numbers in column B B are just the manually entered week numbers, in case anyone was wondering)

Thanks in advance for any help offered.