HOW DO I GET THE CURSOR TO SHOW UP


A

austin63

I am having trouble with getting the cursor to show up when I type. All I
get is the + sign.For instance I have spreadsheet premade and when I go into
the spreadsheet to add new data,there is no cursor to add info to the text
that is already in the cell. ie:
in the cell might say module and I need to add December to make it December
Module, but there is not cursor so what ever I type, it clears the entire box
instead of adding the info to it. Or if I misstype something and try and
correct it. Nothing.
I can change it in the formula bar, but I want to change on the spreadsheet.

Also, when I try to copy and paste say a tracking # in the cell, It goes
into some fourmula and I can right click on the cell, and format cells and go
to #'s and move the decimal point, and hit ok. That changes it, but it makes
me have to right click every cell. I tried highlighting the whole colum and
right click and format and change the decimal point, but it will not change.
 
Ad

Advertisements

G

Gord Dibben

In 2003 and earlier.

Tools>Options>Edit. Checkmark "edit directly in cell"

To change the decimal point on all cells in a range with numbers like
10000.00 to numbers like 100.00, enter 100 in an unused cell.

Copy, select the range to change then Paste Special>Divide>OK>Esc

All numbers will be divided by 100 to return 100.00

Clear the contents of the helper cell.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top