Excel

Send Documents as E-mails Directly from Word & Excel

Submitted by schwarz on January 14, 2011 - 4:50pm

Lots of people know you can email a Word document or Excel spreadsheet by attaching it to an email message in Outlook, but not everyone knows you can do this right from the document itself. Here's how:

Office 2007:

Make Reports from SirsiDynix WorkFlows Sortable by Using Excel

Submitted by schwarz on November 15, 2010 - 5:06pm

When you view a report in SirsiDynix WorkFlows, you can use Excel 2007 to sort the data to make the information easier to read & use. For example, you can sort titles in alphabetical order, call numbers or zip codes in numerical order, or whatever suits your needs.

Here's how to do it:

Use Templates to Save Time in Word & Excel

Submitted by schwarz on September 15, 2010 - 10:37am

flyer templates If you need to create a flyer, budget, labels, award certificate, invitation, brochure, invoice, or other specialized document...

Before you create it from scratch, use as a starting-point one of the free templates that already exist for Microsoft Office (Word, Excel, etc.)

Use Print Preview to Improve Your Excel Spreadsheets

Submitted by schwarz on June 17, 2010 - 11:54am

print preview in Excel Before you print an Excel 2007 worksheet, use Print Preview to control the way your spreadsheet looks.

Watch this 3-minute video demo to find out how you can ...

Don't Make This Mistake When Editing Word & Excel Attachments

Submitted by admin on May 14, 2010 - 5:37pm

If someone sends you an email with a Word or Excel file attachment you're supposed to revise, first save the attachment to your computer before you begin editing it. Then — when you're finished editing it — attach the revised document to your email reply.

If you instead work directly on an attached e-mail file, chances are good the edits you made will be ignored, and when you reply all the person will see is the file as he or she first sent it to you.

Print Only Selected Areas of a Spreadsheet in Excel

Submitted by schwarz on March 12, 2010 - 1:27pm

print area in Excel If you need to print out information in an Excel spreadsheet — but printing out the whole document would end up wasting extra paper — follow the instructions at The How-To Geek to find how to use Print Area and Page Layout to print only the specific areas you need.

Download Cheat Sheets for Office 2007 (Word, Excel & more)

Submitted by schwarz on November 16, 2009 - 4:25pm

Download these convenient one-page cheat sheets for Office 2007, Word, Excel, Office, PowerPoint, and Outlook to reference the next time you need concise reminders of how to do stuff in each of these tools.

Freeze Column Headers & Rows in Excel

Submitted by schwarz on September 15, 2009 - 4:51pm

Navigating a large worksheet with lots of cells is a challenge. When you scroll down or across, column and row labels aren't visible any longer, so it's hard to tell what the data in a cell you're looking at refers to. By using the Freeze Panes command in Excel, you can make sure header columns and specific rows stay visible while you scroll.

Freezing and unfreezing panes changes how you can view the data, without affecting the data itself.

Embiggen Any Web Page or Document

Submitted by schwarz on September 15, 2009 - 4:48pm

You can enlarge the text on any web page by pressing the Ctrl key as you scroll the wheel on top of your mouse.

Bonus: it also works on Word and Excel documents!

Change Direction of the Enter Key in Excel

Submitted by schwarz on July 15, 2009 - 4:25pm

Excel 2007 Excel's default is when you press the Enter key after putting data into a cell, the cursor moves down to the next row.

But if you want it to go in a different direction (like to the cell in the next column), you can change the direction to which the cell pointer will move. Here's how:

Excel 2007:

The Ides