Ctrl+PageUp/PageDown to switch between open worksheets. That’s a nice one, I think.
I live for keyboard controls, not just in Office but in Windows generally. I try to avoid mouse use as much as possible, but surfing the web isn’t very conducive to it.
One of the things I use most, (this works for pretty much any windows application), is that while tab moves you to the next field, SHIFT+TAB moves in reverse. BTW in excel, this moves the active cell backwards. Can be very helpful.
Oh, and here’s a very useful one for Excel: ALT-Enter gives you a ‘hard return’ within a single cell. That is, instead of sending you to the next cell in the spreadsheet (which happens if you just hit ‘Enter’), it gives you a new line in the same cell. At my work we were standardizing the look of some excel documents to add to our website and the supposedly knowledgable tech folks were just having us use the spacebar and ‘wrap text’ to get to a new line in a cell. But then when we tried to change the width of the cell it threw EVERYTHING out of alignment. So while everyone else was using ‘delete’ and ‘spacebar’ to try to line things up again, I figured out ALT-Enter and it made things MUCH easier. (I’m proud of myself, can you tell?)
Actually, the polite version that I’ve seen more often is “Read the fine manual”. Though in the interests of accuracy, all too often neither “friendly” nor “fine” really apply, so we fall back to the original version of the phrase.
Oh, and hitting ctrl+minus (where the minus key is on the numeric keypad) will create an en dash in Word.
First, let me say “Never let anyone limit you on knowledge.” Take the fight against ignorance into your own hands. And a manual is a pretty good weapon in the fight against computer ignorance. If you truly master Word or Excel, by reading one or 2 books and practicing what you read, you will have computer skills that generalize to a lot of office applications.
My favorite tip for those interested in using the keyboard more (it is almost always much faster, especially once you are past the absolute beginner stage) is to hit your Alt key. Now, look up at the menus. There is a letter underlined on each menu. Hit that letter to activate that menu. Then, look on the menu. Letters are underlined there, too. Hit that letter to select that item. Soon you will have frequently used combinations memorized.
Also, in a dialog box, pay attention to which option (such as OK, Enter or Cancel) is highlighted. Hitting your Enter key selects that default highlighted option. You can often use Tab or an underlined letter to change which option is highlighted, then hit Enter to select that option instead.
If you use your mouse and go to the menu at the top of the screen, pull down the menu with the mouse. For instance if it says File on the menu it will allow you to go down and click on OPEN to open the file. Next to it it will tell you the shortcut. CMD+O. Do that for all your menus and you will get the shortcuts.
Also do a google search for “excel tricks” or “word shortcuts.” You may also try ADA Compliance as software tries to be helpful for those who can’t use a mouse (bad hands etc)
If you go to www.microsoft.com and type “keyboard shortcuts” into the search box at the upper right you’ll be rewarded with a list of documents which describe every keyboard shortcut in every MS product, including the universal Windows shortcuts like Ctrl-Esc and Alt-Tab and Ctrl-F4. There, that wasn’t so tough after all, was it??
Further, in all MS Office products the menus and keyboard shortcuts are almost totally customizable. How do you do it? On the menu go to Tools | Customize … click the help button and start R-ing TFM.
Editorial comment / rant: …
It never ceases to amaze me the number of folks who use a very complex tool ever day and are unaware of most of the features, even ones that are immediately relevant to their daily use. Imagine most folks didn’t know how to operate the air conditioners in their cars, and messageboards had threads like “Wow, I found that if I move the red/blue slider to the blue side, cold air comes out!! Tell me your favorite car tricks.”
This isn’t some secret arcane knowledge available only by discovery & word of mouth. Read a couple of help pages every day and within 1 month you’ll have more than paid for the time with increased productivity.
American business wastes billions of dollars every month while untrained people struggling to misuse their spreadsheet or word processor or mail program. Sad.
You would be amazed at the number of people who Don’t how to operate their cars. I could tell you stories that would curl your hair.
Back to the answers to the OP, everyone is assuming that
[ul]
[li]The manual was distruibed with the new software[/li][li]That there is a SME available at the no-help-what-so-ever desk[/li][li]That the online help is worth a damn[/li][/ul]
So us poor working stiffs wind up learning by hunt and peck, buying books on the outside, asking our peers, and message boards (assuming that we are talking aobut something common like an MS product)
Well, the OP specifically referred to the Office suite, so the online docs are worth a damn–it can take some poking around to find, but there’s a lot of information available.
Oh, and I for one would love to hear those hair-curling stories you mention…
I spend a good deal ofmy day explaining to people how to do things that are clearly written in the manual or simply press F1 and search for it in the help files
alternatively search in google some of the following come up straight away