E-mailing a single sheet from a workbook

There are two ways in which this can be done.

1. If you click on the "Send to mail recipient" button, you can select the option Send the current sheet as the message body. This will allow you to send the information in the sheet as part of the body of the message (not as an attachment). (Note: You can add the "Send to mail recipient" button to your quick access toolbar by clicking on the arrow on the toolbar and selecting More commands -> Select Choose commands from: Commands Not in the Ribbon -> Find Send to Mail Recipient and click on Add>>)
2. If you need to send the sheet as an attachment then make a copy of the sheet and add it to a new workbook: Right click on the sheet tab, select Move or copy, select new book from the drop-down list, and select Create a copy. Then send the newly created workbook with just the one sheet.

Selecting a block of data

To select a block of data without having to drag your mouse over the data, you can simply press Ctrl+Shift+Right arrow to select data across the columns, and Ctrl+Shift+down arrow to select data across rows.

Creating a hyperlink in Excel 2007/2010

Creating a hyperlink is very simple. All you need to do is go to the Insert tab and click on hyperlink. You can create a hyperlink to another file, to another location in the current file, or even to a web page. You will see a navigation screen where you will be able to select the relevant link type as well as the location. The "Text to display" field allows you to specify want you want the hyperlink to say.