I also can't really bring focus to the excel window if something else (ie. But if I type anything else (numbers, letters, or symbols) then it types 2 instances of the key every time, yet when I hit enter, nothing changes in the cell. If I use the delete key to delete the contents of a cell, then it gets deleted. If I'm in the excel window, I can click alt on the keyboard and the shortcut keys for the menu come up, but I can't go deeper than that by clicking the letter shortcuts, they do nothing. When it gets locked up like this, I can still do anything in the VBE (edits cells, run macros, etc.) with no problems. Still having trouble, and the same thing is happening with this workbook on two different computers, so I don't think it's a hardware, or OS specific issue. The only way I've been able to get back to normal is by force closing excel altogether and re-opening. If I go into the VBE, I can manually run procedures and they all work fine. I've made sure that screenupdating is turned back on at the end of every procedure. I can't think of anything in my macro that would have these kinds of effects. I don't understand what's going on at all. So if I press "s' it will input "ss" into the cell, and then when I press enter it will auto-move to the next cell down, but nothing ends up getting saved into the previous cell. Then it gets really strange - when I have a cell highlighted and press any key to input text, it gets duplicated. BUT, if I use the keyboard arrow keys, I can see that the active cell selection moves accordingly. When I click anywhere (trying to select a cell, or an excel menu item.clicking anywhere in excel) I'll get the a 'ding' system sound and nothing will happen. Occasionally it will run as expected but as soon as the macro ends, excel becomes unresponsive to mouse-clicks. I have a fairly lengthy macro that works perfectly most of the time. I've been having a strange problem lately. Slowest: Use your mouse to click on the slider on the bottom right of your screen (and either drag the slider left/right or click on the ‘+’ or ‘-‘).Posted this on the Ozgrid forums, but haven't gotten any help yet, so I thought I'd try here too! After each key in the sequence, Excel will show you what key to press next (a “hot key”), as shown above in the red circles.
If you know how Excel Alt shortcuts work, you’ll notice that once you hit Alt-W, you can also extend your sequence with either J (to go back to the default 100%) or G (to zoom to selection), instead of Q - see below:Įxcel Alt shortcuts are great because Excel guides you every step of the way - you don’t have to memorize. Note: you can also bring up the Zoom menu by going to View > Zoom on the Ribbon with your mouse (which is exactly what Alt-W-Q accomplishes). To use the menu, either (a) select a button with your mouse and click OK or (b) type the underlined hot key (e.g., Alt-W-Q-7- will take you to a 75% zoom, since the number 7 is underlined in the 75% option).
Second Fastest: Alt-W-Q (type in succession, not simultaneously) will bring up the following Zoom menu (or Alt-V-Z to use a legacy Alt sequence):
I call this a “ hybrid shortcut” since you’re using both mouse and keyboard in one shortcut.
This will zoom you in and out, and you can see exactly how far (what %) you are zoomed in/out by looking at the Zoom Slider at the bottom right of Excel (see picture below). Three Excel Zoom Shortcuts (Actually, Four)įastest: Ctrl+mouse-scroll - in other words, press the Ctrl key and (while it’s pressed) roll your mouse wheel forwards/backwards. So here are some shortcuts so you can zoom faster in Excel. (3) it helps you share your screen with someone standing behind you In other words: it can save your it helps your eyes when you’re in the office until 11pm for the fourth straight night Zooming out will show you clearly whether you’ve omitted anything. (1) it helps confirm that you’ve selected everything you want to select (important with big selections where you’re using Ctrl+A or Ctrl+Shift+End).