Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Mar 19, 2008, 03:51 AM   #1
Ian S
macrumors newbie
 
Join Date: Mar 2008
Excel 2008 formula bar problem

The left edge of my excel formula bar is not showing-almost as if it was pushed off the left side of the desktop (see picture). Unfortunately, the only part of the formula bar that allows it to move is now hidden, so I can no longer move the formula bar. I have tried switching the formula bar on and of in "View" and also tried re-loading excel, but it is stuck.

Does anybody know how to reset the formula bar position?

Thanks in advance.

Ian S.
Attached Thumbnails
Click image for larger version

Name:	Picture 1.jpg
Views:	223
Size:	496.7 KB
ID:	108466  
Ian S is offline   0 Reply With Quote
Old Mar 19, 2008, 10:31 AM   #2
wrldwzrd89
macrumors G4
 
wrldwzrd89's Avatar
 
Join Date: Jun 2003
Location: Solon, OH
Try moving Excel's preference file to your desktop then relaunching Excel. It's probably in /Users/username/Library/Preferences and called com.microsoft.Excel.plist.
__________________
iMac Intel (Rev H, 27"), 1TB HDD, 16GB RAM, 10.8.4
wrldwzrd89 is offline   0 Reply With Quote
Old Mar 19, 2008, 11:49 AM   #3
nemex
macrumors regular
 
Join Date: Nov 2007
Location: Mexico
Quote:
Originally Posted by Ian S View Post
The left edge of my excel formula bar is not showing-almost as if it was pushed off the left side of the desktop (see picture). Unfortunately, the only part of the formula bar that allows it to move is now hidden, so I can no longer move the formula bar. I have tried switching the formula bar on and of in "View" and also tried re-loading excel, but it is stuck.

Does anybody know how to reset the formula bar position?

Thanks in advance.

Ian S.
Gee! this is bad, have you tried ctrl-clicking in the Formula bar? I just did and a Reset toolbar option appears there (in my case appears greyed out but my formula bar is in the correct position)

Hope this helps!
__________________
"...Never interrupt your enemy when he is making a mistake..."
nemex is offline   0 Reply With Quote
Old Mar 19, 2008, 08:08 PM   #4
Ian S
Thread Starter
macrumors newbie
 
Join Date: Mar 2008
The control clicking idea did not work, but deleting the excel plist file worked perfectly. Thanks wrldwzrd89
Ian S is offline   0 Reply With Quote
Old May 8, 2008, 11:55 AM   #5
dduff617
macrumors newbie
 
Join Date: Sep 2006
i had the same problem. i was able to fix it. but it has come back again a few more times since. there's definitely something screwy here. shouldn't be this much work to straighten out basic toolbars.
dduff617 is offline   0 Reply With Quote
Old Apr 20, 2009, 02:14 PM   #6
bigchiefmunkey
macrumors newbie
 
Join Date: Apr 2009
Quote:
Originally Posted by wrldwzrd89 View Post
Try moving Excel's preference file to your desktop then relaunching Excel. It's probably in /Users/username/Library/Preferences and called com.microsoft.Excel.plist.
Hey, I launched excel this morning and my titlebar was all sorts of jacked up - it was like 10px wide and scrolled any selected cell's text downwards one character wide. wow, annoying.

I reset this plist file and it now works like a champ. Registered to just thank thank you *(:
bigchiefmunkey is offline   0 Reply With Quote
Old May 31, 2009, 09:59 PM   #7
tthornyone
macrumors newbie
 
Join Date: Jan 2004
Location: Orange, CA
Formula Bar Alignment Fix

I'm using Excel 12..

I was unable to fix with others mentioned here, until I found the preference "Excel Toolbars (12)"

I moved Excel's Toolbar preference file to my desktop (could have trashed it) then relaunched Excel. Mine was in /Users/username/Library/Preferences/Microsoft/Office 2008 and called "Excel Toolbars (12)".

I hope this helps others! Good Macin' to you!!
__________________
tthornyone is offline   0 Reply With Quote
Old Jan 7, 2013, 12:48 PM   #8
Vincent63
macrumors newbie
 
Join Date: Jan 2013
You saved my life ! Works fine with me

You saved my life ! Works fine with me
Vincent63 is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Excel 2008 formula bar A---B Mac Basics and Help 1 Sep 27, 2013 07:07 AM
Excel formula to tally numbers by month? jent Mac Applications and Mac App Store 11 Aug 8, 2013 12:30 PM
Excel formula to recalculate averages? jent Mac Basics and Help 1 Jun 2, 2013 03:42 PM
A Curious Excel 2008 file Problem.. Cairbreo Mac Applications and Mac App Store 7 Mar 6, 2013 03:32 AM
Excel Formula group days into weeks ezekel Mac Applications and Mac App Store 1 Jan 19, 2013 03:18 PM

Forum Jump

All times are GMT -5. The time now is 09:43 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC