Microsoft Excel Problem with access to cells?
I have had this weird problem with Excel the past few months. I cannot double-click cells to edit the content in the cell - to input/edit content I have to use the text bar under the menu bar. This means that I cannot enter multiple paragraphs among other things. Likewise, when I copy from one cell to another I can only get out of copy mode by clicking into that top edit field. This problem started suddenly, I don't know what I might have done to initiate it? Has anyone heard about this problem before? Do I really need to re-install it?
Update:F2 does not work either.
More Questions From This User See All
Answers & Comments
Verified answer
Go to Tools, Option, Edit. Then click Edit Directly in Cell.
(I've used Excel for 20 years. I never knew you could double click a cell. I've always used F2.) Thanks!
-MM
i don't think of i'm able to respond to your finished question because of fact it may be too long, yet correct to the form subject, one ordinary approach is to create a "grasp form" column which will shop your archives interior the order you like. No fancy formulation, I promise you. 3 steps to retaining your form order preserved in Excel: a million) Get your archives interior the order you like it. 2) Create the “grasp form” column; ideally it is going to be the 1st column. Label the row header "grasp form" or something comparable. 3) quantity the rows a million, 2, 3, 4, and so on. till the very final row containing archives. whenever you form via the different column, the unique form order would be preserved because of grasp form column's series (a million, 2, 3, and so on.). Excel is a good application to apply for becoming spreadsheets, formulation, training archives get right of entry to, formatting archives get right of entry to, column's series and so on. however the Microsoft get right of entry to application is designed for uncomplicated database manipulation. i won't have the ability to tell you what you need to use, yet get right of entry to may be much less complicated to apply. there's a mac version for get right of entry to and it incredibly is downloaded for unfastened in case you seek on line. optimistically i've got been powerful on your seize 22 subject and good success with your database! =P
Try
Tools
Options
Edit tab
see if there is a checkmark next to "edit in the cell"