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:
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.
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.
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 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.
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.