I figured I'd post this since most in the industry use excel every day.
Two problems:
I use a laptop with windows 8. When I was adding columns to a worksheet, I pressed (Fn)+ F4 to add a ton of columns. My laptop requires me to press the Fn key to freaking use any of the F# functions. I don't know if I exactly pressed Fn F4, but basically, this made my ribbon extremely huge. I can deal with it, but it takes up like 1/3 of the screen when I'm doing some sort of shortcut that involvest Alt + [random shortcut here]. My laptop is touch screen, but I've already unchecked that option from the ribbon, so that is not it.
Also
Whenever I copy paste an entire worksheet (say appprox 60 rows and 30 columns) and paste it into another worksheet within the same book, the whole workbook gets really slow. After that, if I want to add a column, an error saying that the action would take too long pops up. Saving the file also takes a lot of time. What is the problem with pasting worksheets?
I think I'm using Excel 2014 (Microsoft University 365, bought it last september).
EDIT: Apparently Paint has also oversized ribbons. This seems to be system-wide, but it all started with Excel. The formatting options take the whole spreadsheet length-wise, as seen in the 2nd pic.
| Attachment | Size |
|---|---|
| messed_up_excel.jpg 133.54 KB | 133.54 KB |
| oversized_ribbons.jpg 151.46 KB | 151.46 KB |
| oversized_ribbons2.jpg 148.21 KB | 148.21 KB |
If its the most recent update (office 2016/windows 10 is being released this week), it could be issues that microsoft is having converting excel to a more touch friendly system. Or it could have to do with your processing power/what you're trying to do. What're the specs (ram and processor) on your computer and what are you trying to do (pull live data with VBA, Add-ins etc)? Another trick, trying closing completely out of excel, right click on the desktop, and click "refresh".
Have you tried restarting your computer?
se_ib I've tried restarting my computer. I use a Lenovo Yoga; RAM is 4GB intel i5. Also tried the refresh on the desktop. Didn't work. I'll upload a picture of what excel looks like when I open it. Itll seem obvious that it's oversized when you see it.
maybe try this for the ribbon stuff, sorry if you've already looked at it. https://support.office"DOT.COM"/en-us/article/Minimize-the-Ribbon-3e3dc828-e9c6-408a-bac1-3cbda6b8ded3. Another thing to check would be your actual display settings. The fact that it is happening in paint would indicate that its a display issue, not an excel issue.
Aut sit aut eum error cum similique. Ducimus aliquam soluta et officia. Facilis omnis possimus praesentium rerum suscipit. Quisquam eius asperiores et molestias non. Eos soluta alias at sequi. Quod nihil a maiores aut facere voluptatem magni. Quia et necessitatibus fugiat quia.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...