ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding data to cells (https://www.excelbanter.com/excel-discussion-misc-queries/240189-adding-data-cells.html)

sm-urk

Adding data to cells
 
Hi,

I used to be able to double-click on a cell to get a cursor within the cell
(not in the formula bar), so I could then navigate with the cell itself to
edit the information in it.

Now I can't seem to get the text cursor to work, it stays as a white cross
and I have to edit cell information in the formula bar.

Any ideas?

FSt1

Adding data to cells
 
hi.
yes. on the 2003 menu bar...
tooloptionsedit tabCHECK edit directly in cell.

Regards
FSt1

"sm-urk" wrote:

Hi,

I used to be able to double-click on a cell to get a cursor within the cell
(not in the formula bar), so I could then navigate with the cell itself to
edit the information in it.

Now I can't seem to get the text cursor to work, it stays as a white cross
and I have to edit cell information in the formula bar.

Any ideas?


Pete_UK

Adding data to cells
 
This is a setting controlled by Tools | Options | Edit tab - check the
option for Edit directly in cell, then click OK.

Hope this helps.

Pete

On Aug 20, 1:21*am, sm-urk wrote:
Hi,

I used to be able to double-click on a cell to get a cursor within the cell
(not in the formula bar), so I could then navigate with the cell itself to
edit the information in it.

Now I can't seem to get the text cursor to work, it stays as a white cross
and I have to edit cell information in the formula bar.

Any ideas?



sm-urk[_2_]

Adding data to cells
 
Thankyou thankyou! It was really annoying me

"FSt1" wrote:

hi.
yes. on the 2003 menu bar...
tooloptionsedit tabCHECK edit directly in cell.

Regards
FSt1

"sm-urk" wrote:

Hi,

I used to be able to double-click on a cell to get a cursor within the cell
(not in the formula bar), so I could then navigate with the cell itself to
edit the information in it.

Now I can't seem to get the text cursor to work, it stays as a white cross
and I have to edit cell information in the formula bar.

Any ideas?



All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com