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.
Here are three highly useful (well, in my opinion) tips for Excel. They're not complicated, they're not "hidden," and their directions aren't hard to follow. I'll bet you'll have times when you can really use them. So try them out and file them in your noggin's Excel folder for future use.
You want to have a fraction in a cell but each time you enter it (1/2, 3/4, 5/8, etc.) it formats as a date (2-Jan, 4-Mar, 8-May). Annoying!
You created a table from some data and now you want to delete the table without losing your data or the table formatting.
To stop working with your data in a table without losing any table style formatting that you applied, you can convert the table to a regular range of data on the worksheet.
Now, note that once you do, the table features are no longer available. For example, the row headers no longer include the sort and filter arrows. But they still look cute...
Excel doesn't normally print row and column headings on each printed page. But you want it to!
Let me know what other sort of tips you'd like to see (for Excel or any other Office program); I have quite the stash I'm just dying to unload...
"Hunger is the best sauce in the world." — Cervantes
I want to know how to change the data fill default. When I am using the click on the bottom right of a cell and drag it down to the last cell I want to copy into, the default is to fill with a sequential pattern - and I always have to click on it to change it to copy - is there a way to set copy as the default? Thanx for your tips - I always learn something new!!
@cheryl: The best way I know how to copy multiple cells is to simply select the cell, press Ctrl + C, hold down SHIFT and use the Arrow Keys (or Page Down) to go to where you want to, and hit Enter.
Cheryl, I use the auto-fill function and specify "copy cells" rather than "fill series". Maybe that would work for you..
In Excel, when I hit enter the cursor moves to the right, which is what I want - most of the time. How can I change it to move down?
@Kathy - Here's where you can control the cursor movement:
Excel 2010 - Press File > Options > Advanced > Editing Options > "After pressing Enter, move selections > MAKE YOUR CHOICE
Excel 2007 - Same as 2010 but instead of the FIle menu, press the Office button near the File menu
Exel 2003 - office.microsoft.com/.../move-the-cursor-after-entering-data-HP005199274.aspx
(Hmmm...this would be a good Dear Crabby becasue I didn't even know one could change that~~~)
Excellent ! Thank you!
I have created multiple worksheets in a workbook. All are set to landscape. When I print preview or print, they all change to protrait. Why does this happen and how can I make sure all worksheets print landscape.