Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to edit cells
Hi,
There used to be a field at the top of the excel worksheet in which I could edit a cell's contents. It has dsisappeared and no matter what I try in Help, I can't find it. As it is now, the only way I can change the contents of a cell is by retyping everything in the cell. I cant place the cursor into a cell and change one letter only. Help does mention the formula bar but it doesn't tell you where to find it. Sincerely, Ralf Dieckmann |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to edit cells
Try this:
Goto the View menu, select Formula bar. -- Biff Microsoft Excel MVP "Ralf Dieckmann" <Ralf wrote in message ... Hi, There used to be a field at the top of the excel worksheet in which I could edit a cell's contents. It has dsisappeared and no matter what I try in Help, I can't find it. As it is now, the only way I can change the contents of a cell is by retyping everything in the cell. I cant place the cursor into a cell and change one letter only. Help does mention the formula bar but it doesn't tell you where to find it. Sincerely, Ralf Dieckmann |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to edit cells
I cant place the cursor into a cell and change one letter only.
With a cell selected: F2 should put the editing cursor in-cell. F2 is also useful in some dialog boxes. For instance, when editing RefersTo: addresses in the Names dialog, F2 will get you out of PointTo mode and into Edit mode. Getting out of PointTo mode allows you to use left-right arrow keys to move around the too-narrow input area without creating a mess of the reference. -- HTH, George "T. Valko" wrote in message ... Try this: Goto the View menu, select Formula bar. -- Biff Microsoft Excel MVP "Ralf Dieckmann" <Ralf wrote in message ... Hi, There used to be a field at the top of the excel worksheet in which I could edit a cell's contents. It has dsisappeared and no matter what I try in Help, I can't find it. As it is now, the only way I can change the contents of a cell is by retyping everything in the cell. I cant place the cursor into a cell and change one letter only. Help does mention the formula bar but it doesn't tell you where to find it. Sincerely, Ralf Dieckmann |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit Multiple Cells | Excel Worksheet Functions | |||
How can i Edit many Cells at a time. | Excel Discussion (Misc queries) | |||
Edit Excel Cells | Excel Discussion (Misc queries) | |||
Prevent edit of cells | Excel Worksheet Functions | |||
edit cells only with authority | Excel Discussion (Misc queries) |