You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
For the last 12 months, I've provided you with ideas, tips, tricks, a bit of humor, shopping ideas, comments on popular and inane American culture, and ways to get out of working with difficult people. Since everyone seems to be in shopping list mode—except perhaps our Jewish friends who've already done their shopping since Hanukkah started Wednesday night, or our Type A friends who shopped at last year's after-Christmas sales (both types being lucky, chosen people)—I thought I'd offer up a list of the five MOST popular (perhaps because they're useful?) tips that I came up with the past year. (Yeah, some of these will be repeats for some of you but I'm pretty sure there is at least one thing in here that's new to you.)
Tip #1: Where are my $*#(@)!*? commands in the Ribbon???
Yeah, I know: Things look difference in Office 2010 and Office 2007 if you're upgrading from Office 2003 and prior versions; really different. Here are some resources that I know you'll find invaluable as you make the switch
These guides are visual, interactive tools that help you quickly learn where commands are. SO, um, no more panicking, okay?
Tip # 2: Transposing in Excel
In Excel 2010 and 2007, to transpose data in columns to rows (and vice versa):
Tip #3: Page tabs in OneNote
Page tabs appear on the right side of your OneNote notebook by default. To display the page tabs on the left side of your notebook, in the Display category in the Options dialog box (Tools menu), select the Page tabs appear on the left check box.
Tip #5: Minimize don't marginalized the ribbon
No, you CANNOT get rid of the ribbon so STOP asking. However, you CAN make it smaller.
Minimized, adorable Ribbon
Tip #5: Copy Excel values (and ixNay on the ormulasFay)
Sometimes, when you copy the contents of a cell, you want to paste just the value and not the formula that's displayed in the formula bar. Is that such a tall order? Methinks not.
Bonus Tip: Copying styles into Excel
When you want to copy content from a Word document, a Web page, or whatever into Excel, and you want that content to have the same formatting as what's already in your Excel spreadsheet, double-click the cell before you paste the content in. (You can also select the cell and press F2.)
(I showed this little gem of a tip to a particularly excitable Frenchman around here, and he nearly hit his tête on the ceiling he was so ecstatic....)
Were these useful to you? Want more? Speak up. If you vote/don't talk to me you can't compain...
Crabby's Find of the Day: Imagine the future of newsstands
if i insert a clipart in a paragraph in word 2011 that is located in a textbox, the clipart is not printed and is also missing in pdfs. If i open the docx with word 2010 and print or save it as pdf there, everything is ok. I know, programmers often call such things a feature instead of bugs, but it would be great, if this feature could be deleted ;-).
I can't get the transpose function to work correctly. Are you selecting the entire row or column?
@Sebastian: what if it ISN'T in a text box? Can you write to me @ email@example.com so that you & I can run through some scenarios and troubleshoot? Then, if something wacky/buggy seems to be going on, I can forward your issue to the people in the know (& oh how I love to BUG them).
Sorry Crabby - transpose still not working. When I select the entire row or column to paste, I have no paste special option.
Follow up: Transpose works row to column, but not column to row. Says it's not the same shape/size. :(
Well, YES they are useful! Keep 'em coming.
@AMG: Let me do some testing on my own computer and I'll get back to you. I'm sure there's something we're missing; hold tight! I'll be back in less than an hour
@Amg: Before I go on, what version of Excel are you using? I updated the procedure a bit to reflect BOTH 2010 and 2007 and corrected one thing: You DON'T select the entire row or column you're wanting to change; just the cells themselves. Also when you want to transpose those copied cells, you place your cursor on a single cell at the top of the row/column you're transposing into; you don't select the entire row or column AND it must be outside the area you just copied from. '
Re-read the procedure and then report back!
Sebastian: There is no "Word 2011" except for Mac; and there is no Word 2010 except for PC and the two don't work together. So something is funky here...
Reporting back: Office 2007. 2 scenarios:
Column to row: selected cells to 1st cell (yes), entire column to 1st cell (no), entire column to entire row (no)
Row to column: selected cells to 1st cell (yes), entire row to 1st cell (yes), entire row to entire column (yes)
It's just not consistent; I'm betting it is because of the number of rows vs. columns.
Aren't you glad I read your column?!?
@AMG: I'm really sorry but I've done all I can. I can't reproduce your issue and neither can anyone else I've asked t (5 others). I suggest visiting Microsoft Answers and posting your question there. Be as specific as possible. ANd again, not that you do NOT select the entire column or row.
Dear Crabby, i wrote you and hope the spam filter didn't catch my mail.
I downloaded office.microsoft.com/.../CL101817133.aspx
I tried to use it but the template didn't open because the file was corrupt.
Dear Crabby Lady,
You are the best help I have gotten for my work and I appreciate it.
I am learning 2010, having used MS Word for 17 years. 2010 is really difficult. The most difficult part is the Help feature -- I can never find an answer in one place. It's frustrating. My current problem is trying to set up a very simple page layout. I want the Normal one inch all around margins. I have spent three hours today trying to make the page layout be the one I want when I open a blank document. Each time the cursor is on line 0 at the top of the page. I can't find a way to directly manipulate the vertical ruler. Where is that function?
If you can help me, I would be so grateful.
@ Sharon Bode: Thanks for your very kind words; I'm really glad I offer help to you!
Regarding your two questions:
#1: The "template" you refer to (and link off to) isn't a template at all; which of these "Ribbon reference books" did you try to open? Did you try more than once? if you give me those answers, I can investigate and then send the issue to the right people.
#2: This is a "Normal template" (the default document that opens when you start a new doc) issue and I'm going to get someone (maybe Joannie, our Word expert and blogger - blogs.office.com/.../microsoft-word) to answer your question and walk you through the process.
Note that it'd be *really* helpful if you send your 2 questions to me in email; that way we can go back and forth more efficiently:
Hang in there; we'll get this solved for you.