#1
|
|||
|
|||
Excel 2010 view of cel missing
I just bought Excel 2010 and does not see the view of the cel being worked on.
I noted that the edit function of the cel that is copied from another locatiion. Is there a toggle or setting to view and edit the cels? |
#2
|
|||
|
|||
Hello, If I understand you, you can see the cell where are you working in? Do you have some rows or columns hide?
To unhide you can click on the up-left corner of the worksheet. It's a rectangle that selects all the rows and columns of the sheet. When you are selecting all, right click over a column and click in Unhide Then right click over a row and click Unhide. I don't know if that answers your question, |
#3
|
||||
|
||||
I'm not sure, either, what you're saying, isla, but in case jsuarezg is barking up the wrong tree here's my own theory on what's going on: You're used to seeing a cell's formula being edited up at the top in the formula bar, but now Excel thinks it's supposed to display it in the cell itself. Or vice versa. Either way, you're looking for the editing as it happens, and not seeing it because you're looking in the wrong place.
This is controled in Excel's options: Select File, then Options, then click on Advanced at the left. The first set of options under Advanced is headed "Editing options" in bold; look in that section until you see "Allow editing directly in cells", and check or uncheck that option to suit you. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Get just grey box when opening Excel Document 2010 | sebbero | Excel | 1 | 11-10-2010 04:24 AM |
Access to an Office 2010 Excel file over network | lohith.korp | Office | 2 | 09-27-2010 08:32 AM |
Office 2010 : Unable to view the outlook properties window | Harikumar | Outlook | 0 | 08-26-2010 08:37 PM |
Help resolving missing DLL issue in Excel 2007 | pete72 | Excel | 3 | 01-17-2010 04:31 PM |
Excel indicates missing SKU111.CAB file | tn312c | Office | 6 | 11-07-2005 02:04 PM |