In the newer versions of Excel and Word 2011 for Mac, the applications will start hiding items from your "ribbon" if the Excel/Word window is not full screen. For instance, when you shrink an Excel Spreadsheet, you'll end up with a sub-set of the tools available, and there's not a way to get them back without making the window larger (or digging in the menu to find them)
In the screen shot below, the Excel window is set to be almost the entire width of the screen, and you get the full set of items in the ribbon (note the format borders icon is showing).
In the screen shot below, the Excel window is set to be about 1/2 the width of the screen, and the format borders icon, which was between the underline U and the fill background paint bucket, along with many others, have been dropped off the ribbon!
One solution is to drag the window using the right lower corner to make the ribbon show more items.
If you want, you can customize the ribbon by opening "Excel" menu, then going to Preferences. Click the ribbon item, and uncheck some of the items that you don't use. This will allow more items that you DO use to show up when the window is more narrow, hopefully keeping the items that are "must haves" for you!
You're Awesome! Thanks!!!!!
ReplyDeleteAlternatively, you could make excel half the height of the screen instea of half the width. That might lead to other problems though, depending on whether you need to work more diagonally or horizontally. You could use the zoom function of excel (http://www.excel-aid.com/using-the-excel-zoom-function.html has a short description on how to use that) to mitigate the smaller window size a little bit. Of course it will be harder to read the data that way, but if your monitor is big enough, that might be a possibility. I hope i could help. Or maybe its just nonsense to you, i am not quite sure ;)
ReplyDelete