How to fill cells down and change function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Erin - 11 Apr 2008 21:36 GMT

Ok, weird question...a co-worker has been teaching me a lot about
Excel but his computer is set up in Spanish (he's from Mexico). There
is a 2-part command that is:

Shift + Ctrl. + down arrow (to fill all cells down that have values)

and then Shift + J (or maybe it's Ctrl. + J) to update the function

Does anyone know what the 2nd command is on the American/English
Excel? I can't figure it out.

Thanks.

Reply to this Message

Pete_UK - 11 Apr 2008 22:03 GMT

You can find a list of all the keyboard shortcuts in Excel Help - type
in keyboard shortcuts in the index.

F9 recalculates all sheets in all open workbooks, Shift-F9
recalculates the active worksheet, and Ctrl-Alt-F9 recalculates all
sheets in the active workbook.

Hope this helps.

Pete

> Ok, weird question...a co-worker has been teaching me a lot about
> Excel but his computer is set up in Spanish (he's from Mexico). There
[quoted text clipped - 8 lines]
>
> Thanks.

Reply to this Message

Shane Devenshire - 12 Apr 2008 05:21 GMT

Hi,

I'm not sure what Shift+J means on a Spanish system, but if it is a
calculate command, then to be complete:

Ctrl+Alt+Shift+F9: Rechecks dependent formulas and then calculates all
cells in all open workbooks, including cells not marked as needing to be
calculated.

Cheers,
Shane Devenshire
Microsoft Excel MVP

> Ok, weird question...a co-worker has been teaching me a lot about
> Excel but his computer is set up in Spanish (he's from Mexico). There
[quoted text clipped - 8 lines]
>
> Thanks.

Reply to this Message

Rate this thread: