ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula Bar (https://www.excelbanter.com/excel-discussion-misc-queries/132629-formula-bar.html)

Saravanan

Formula Bar
 
Hi,

My formula bar is disappeared. How can I get it back? Also I am not able to
click my right moust button.

Thanks,
Saravanan

OssieMac

Formula Bar
 
Select menu Item View- Formula bar.
Older versions I think were Options-workspace-formula bar

"Saravanan" wrote:

Hi,

My formula bar is disappeared. How can I get it back? Also I am not able to
click my right moust button.

Thanks,
Saravanan


FSt1

Formula Bar
 
hi,
if it's just the formula bar, click toolsoptionsview tab and check forumla
bar at the top. I am not sure why you can't right click the mouse. sorry.

regards
FSt1

"Saravanan" wrote:

Hi,

My formula bar is disappeared. How can I get it back? Also I am not able to
click my right moust button.

Thanks,
Saravanan


Saravanan

Formula Bar
 
Thanks a lot for the help.

~saravanan

"FSt1" wrote:

hi,
if it's just the formula bar, click toolsoptionsview tab and check forumla
bar at the top. I am not sure why you can't right click the mouse. sorry.

regards
FSt1

"Saravanan" wrote:

Hi,

My formula bar is disappeared. How can I get it back? Also I am not able to
click my right moust button.

Thanks,
Saravanan


FSt1

Formula Bar
 
you're welcome.
regards
FSt1

"Saravanan" wrote:

Hi,

My formula bar is disappeared. How can I get it back? Also I am not able to
click my right moust button.

Thanks,
Saravanan


Gord Dibben

Formula Bar
 
What does or does not occur when you right-click?

No menu drops down? See below to reset.

A menu drops down but options are grayed out?

Maybe the sheet is protected.

Can you access the commands from the Edit menu?

If no menu appears with a right-click you shoud try re-setting the r-click.

Hit ALT + F11 to go to the VBEditor.

Then ViewImmediate Window.

Copy/paste this line into the window and hit <enter

Application.CommandBars("Cell").Reset

OR copy/paste this sub to a module and run it.

Sub reset()
Application.CommandBars("Cell").Reset
End Sub


Gord Dibben MS Excel MVP

On Tue, 27 Feb 2007 20:16:15 -0800, Saravanan
wrote:

Hi,

My formula bar is disappeared. How can I get it back? Also I am not able to
click my right moust button.

Thanks,
Saravanan




All times are GMT +1. The time now is 05:36 PM.

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