Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-10-2015, 12:14 PM
MostHated MostHated is offline Issue where unable to edit formula bar, or use arrow keys in cell. Windows 7 64bit Issue where unable to edit formula bar, or use arrow keys in cell. Office 2013
Novice
Issue where unable to edit formula bar, or use arrow keys in cell.
 
Join Date: Feb 2015
Posts: 2
MostHated is on a distinguished road
Default Issue where unable to edit formula bar, or use arrow keys in cell.

Hello, using Excel 2013 I have came across a strange issue where when clicking on a cell, then trying to click the formula bar to edit, it will be grayed out. You can double click the cell to edit, but if you try to move the cursor with the arrow keys, it will not move away from the far left.



Anyone have any ideas?

Thanks!
Reply With Quote
  #2  
Old 02-10-2015, 12:26 PM
gebobs gebobs is offline Issue where unable to edit formula bar, or use arrow keys in cell. Windows 7 64bit Issue where unable to edit formula bar, or use arrow keys in cell. Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

What is grayed out? The formula bar or the cell? Is the sheet protected? Can you attach the sheet?
Reply With Quote
  #3  
Old 02-11-2015, 06:54 AM
MostHated MostHated is offline Issue where unable to edit formula bar, or use arrow keys in cell. Windows 7 64bit Issue where unable to edit formula bar, or use arrow keys in cell. Office 2013
Novice
Issue where unable to edit formula bar, or use arrow keys in cell.
 
Join Date: Feb 2015
Posts: 2
MostHated is on a distinguished road
Default

Thanks for the reply. I unfortunately can not attach it, as it is a company financial document, I will see if I can remove some of what is in it.

As for being grayed out, the formula bar ends up being, but not the cell. You can double click in the cell, as if you were to edit it, but then if you use the keyboard to try and move to the right, the cursor stays at the far left. If you move it with the mouse and try to edit, it just goes back to the left again.

It might be something with the PC perhaps, but not sure how, as it only happens in excel, but if you alt tab and go back to the sheet again, it may then let you edit the cell and formula bar again. Very strange.
Reply With Quote
  #4  
Old 02-11-2015, 11:33 AM
gebobs gebobs is offline Issue where unable to edit formula bar, or use arrow keys in cell. Windows 7 64bit Issue where unable to edit formula bar, or use arrow keys in cell. Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by MostHated View Post
Thanks for the reply. I unfortunately can not attach it, as it is a company financial document
Delete all the data except one cell with the issue.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Issue where unable to edit formula bar, or use arrow keys in cell. Arrow keys malfunction yemijoshua Excel 1 01-15-2015 03:16 AM
Issue where unable to edit formula bar, or use arrow keys in cell. Arrow keys move the caret to opposing direction with the Arabic keyboard. Why ? Belloc Word 4 05-27-2012 07:31 AM
Using arrow keys to move between pages Gidday Word 0 03-27-2012 04:05 PM
Arrow keys not working within text boxes snarfii Word 0 06-20-2011 09:24 AM
Using ms word arrow with text ball graphic - how do i edit once saved kcar Word 1 04-30-2010 03:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft