Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I edit a cell in Excel without clicking on the cell first?
I cannot find the shortcut keys
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I edit a cell in Excel without clicking on the cell first?
F2?
HTH Regards, Howard "Alisa" wrote in message ... I cannot find the shortcut keys |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I edit a cell in Excel without clicking on the cell fir
Thanks Howard. You're a gem
"L. Howard Kittle" wrote: F2? HTH Regards, Howard "Alisa" wrote in message ... I cannot find the shortcut keys |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I edit a cell in Excel without clicking on the cell first?
to use F2 you'd have to select the cell, first.
AFAIK there'd be only 2 ways to do this - either a formula that would put updated info into the correct cell without selecting it, or by macro. hth susan On Apr 1, 7:07 pm, "L. Howard Kittle" wrote: F2? HTH Regards, Howard "Alisa" wrote in message ... I cannot find the shortcut keys- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I edit a cell in Excel without clicking on the cell first?
"Susan" wrote...
.... AFAIK there'd be only 2 ways to do this - either a formula that would put updated info into the correct cell without selecting it, or by macro. .... Formulas can't affect other cells' contents, only the values of formulas in other cells that refer to the cell containing the formula in question. Macros are the only direct way to change the contents of cells that aren't in the selected range. As for indirect ways, it's a matter of semantics, but you could use defined names to change the way formulas calculate without selecting the cells containing those formulas. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I edit a cell in Excel without clicking on the cell first?
As for indirect ways, it's a matter of semantics, but you could use
defined names to change the way formulas calculate without selecting the cells containing those formulas. yes, that's what i meant, but didn't say correctly or completely. :) susan On Apr 2, 1:07 pm, "Harlan Grove" wrote: "Susan" wrote... ...AFAIK there'd be only 2 ways to do this - either a formula that would put updated info into the correct cell without selecting it, or by macro. ... Formulas can't affect other cells' contents, only the values of formulas in other cells that refer to the cell containing the formula in question. Macros are the only direct way to change the contents of cells that aren't in the selected range. As for indirect ways, it's a matter of semantics, but you could use defined names to change the way formulas calculate without selecting the cells containing those formulas. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i execute a VBA function by clicking on an excel cell? | Excel Discussion (Misc queries) | |||
How to highlight an Excel row by clicking on a cell | Excel Worksheet Functions | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Mouse continues to select after clicking on a cell in excel. | Excel Discussion (Misc queries) | |||
I can't edit excel by right clicking | Excel Worksheet Functions |