Drawing Toolbar In Excel For Mac

Posted : admin On 16.01.2020
Drawing Toolbar In Excel For Mac Average ratng: 9,7/10 1143 reviews
  1. Microsoft Excel Drawing Toolbar

I wish I could help, Excel toolbars have been giving me a fit recently too. It sounds like a preference file may be set to read-only for you. Are all your other preferences resetting too or just toolbars? I'm not sure where the info in stored, try looking around at Library/Preferences/com.microsoft.Excel.plist and similar files to see if permissions are correct. You might try running repair permissions (in Disk Utility). I'm not sure if it would help in this case or not.

Pick 'View' from the top of the Excel window. If there is not a check mark next to the Drawing toolbar option, click 'View,' 'Toolbars' and 'Drawing.' A separate toolbar along the side, bottom or top of your window will appear. Choose the 'Draw' option on the Drawing toolbar. In most versions of Excel it has an arrow pointing up or down next to it. Jan 13, 2014 - I believe there used to be a Drawing Toolbar. I recall it was easy to use. Can't find how to draw a circle using Excel for Mac 2011. In Excel, using Mac OS10, drawing toolbar has the check next to it, suggesting it's active; I can't see it; I've moved existing toolbars around; restarted computer; somehow I saw it move out to the side of the screen never to return.

That's the first place I'd check. I have all kinds of fits with Excel toolbars that show up when I switch Spaces. For instance, I have Excel set up to always work on Space 5. Sometimes I will be working on Excel, switch to Space 4, and the toolbar vanishes. I later find it hiding behind all open windows on Space 4, and I can't click it because when I try to it moves me back to the normal Excel app on Space 5.

Turning the toolbars off and back on doesn't help any. I have to quit out of Excel to get the thing back where it belongs. Long story short, if you are using Spaces that may be the problem. Office and Spaces is a bad combo on my machine. I wish I could help, Excel toolbars have been giving me a fit recently too.

It sounds like a preference file may be set to read-only for you. Are all your other preferences resetting too or just toolbars? I'm not sure where the info in stored, try looking around at Library/Preferences/com.microsoft.Excel.plist and similar files to see if permissions are correct. You might try running repair permissions (in Disk Utility).

I'm not sure if it would help in this case or not. That's the first place I'd check. Click to expand.You do have com.microsoft.Excel.plist or maybe com.microsoft.Excel.prefs.plist somewhere. Try adding YourUserFolder and Microsoft to the path: Users/ YourUserFolder/Library/Preferences/ Microsoft That's where it's found in Leopard. I have 10.5.8 Find it, and drag it to the Desktop Fire up Excel A new plist file for Excel will be created in the Microsoft folder (above path) You will now be back to Excel defaults Make a change to a toolbar, and see if it sticks If not, you can always put the file on your Desktop back You can overwrite the default file It's easy to remake it, as you've seen.

You do have com.microsoft.Excel.plist or maybe com.microsoft.Excel.prefs.plist somewhere. Try adding YourUserFolder and Microsoft to the path: Users/ YourUserFolder/Library/Preferences/ Microsoft That's where it's found in Leopard. I have 10.5.8 Find it, and drag it to the Desktop Fire up Excel A new plist file for Excel will be created in the Microsoft folder (above path) You will now be back to Excel defaults Make a change to a toolbar, and see if it sticks If not, you can always put the file on your Desktop back You can overwrite the default file It's easy to remake it, as you've seen. Are you sure Excel is the active application when the toolbars are not visible? If it says Excel in the upper left, and they are checked but not visible, that is not normal. But, if it says Finder or something besides Excel up there, then invisible toolbars is normal.

The toolbars are supposed to remain in the state you have them when you Quit out of Excel (or Word). That plist trick is the only simple thing I can think of that might cure this 'forgetfulness' you're seeing. The next step might be to reinstall Excel.if no one else has another simple trick to try. (I don't think a new User Account or Repairing Permissions, two tricks commonly suggested, apply in this situation.). I have all kinds of fits with Excel toolbars that show up when I switch Spaces.

For instance, I have Excel set up to always work on Space 5. Sometimes I will be working on Excel, switch to Space 4, and the toolbar vanishes. I later find it hiding behind all open windows on Space 4, and I can't click it because when I try to it moves me back to the normal Excel app on Space 5. Turning the toolbars off and back on doesn't help any.

I have to quit out of Excel to get the thing back where it belongs. Long story short, if you are using Spaces that may be the problem. Office and Spaces is a bad combo on my machine. Are you sure Excel is the active application when the toolbars are not visible? If it says Excel in the upper left, and they are checked but not visible, that is not normal. But, if it says Finder or something besides Excel up there, then invisible toolbars is normal.

The toolbars are supposed to remain in the state you have them when you Quit out of Excel (or Word). That plist trick is the only simple thing I can think of that might cure this 'forgetfulness' you're seeing. The next step might be to reinstall Excel.if no one else has another simple trick to try. (I don't think a new User Account or Repairing Permissions, two tricks commonly suggested, apply in this situation.). You beat me to it!

Trying a different User Account was going to be my next suggestion. Creating a new Main Administrator Account can be a pain. (I've never had to.) You have to move your stuff before you can delete the corrupt one. Mac Help has some guidance to offer. But, you might want to create another new account just to be sure that it works there.

Microsoft Excel Drawing Toolbar

Drawing toolbar in excel 2016

Two against one gives you much better odds that a permanent switch will solve the problem. Unfortunately, I don't know how to fix your account, if it is indeed corrupt. Dreamplan home design software download. It's just one of those unsolved mysteries, like corrupt plist files. If i understood your problem right - i had the same thing that was killing me all the time: i needed toolbars for highlighting and so on but every time i was opening new work book - i was choosing view -then toolbars-then formatting (although it was already ticked) - so i untick it - then tick it again - so it would appear on the top of my excel sheet. Finally i realized that i need to leave 'formatting' ticked and just tick some grey button in the upper right corner so now every time i open new excel work book the toolbar is on the top of the excel sheet and stays there. If i understood your problem right - i had the same thing that was killing me all the time: i needed toolbars for highlighting and so on but every time i was opening new work book - i was choosing view -then toolbars-then formatting (although it was already ticked) - so i untick it - then tick it again - so it would appear on the top of my excel sheet.

Finally i realized that i need to leave 'formatting' ticked and just tick some grey button in the upper right corner so now every time i open new excel work book the toolbar is on the top of the excel sheet and stays there.

In Excel, using Mac OS10, drawing toolbar has the check next to it, suggesting it's active; I can't see it; I've moved existing toolbars around; restarted computer; somehow I saw it move out to the side of the screen never to return. Evidently, it appears as an icon on one of the other toolbars; however, whenever I click on it, it shoots out to the side off the screen; when I click on it again to close it, it swoops back into the icon. Where is it going when I try to open it? How to get it back as a toolbar on the screen so I can use it? In MS Word, it works fine, so I feel it is an Excel puzzle.

The toolbars can either be docked or 'float'. When a toolbar is floating it can appear anywhere on the screen. You will probably find your drawing toolbar has been dragged to the right hand side of your screen. A toolbar cannot be dragged off the screen to the left but can be dragged off the screen to the right with only the title bar (drag bar) showing. Is it possible that you accidently moved it off the screen to the right and can't see the title bar because your screen settings are cutting off a small part of the right hand side of your screen?

Interesting point from Suzie; a student did this; I think you are on the right track; The desktop icons are fairly large; under the student login, I cannot change the resolution of the display; when I logout/login as admin and change the display, I do get the smaller icons on that desktop, but when I go back to the student login, I still have the large icons; how do I change the display for the student desktop and maybe then I will see the drawing toolbar off to the right side. Only a guess. Help is appreciated.