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.

Fixing a cell in a formula

To fix a cell in a formula, click on the cell (you want to fix) in the formula bar, and hit the F4 key.

• Hit the F4 key once to fix the cell (dragging a formula down or across will keep the row and column of the reference cell constant)



• Hit the F4 key twice to fix the row (dragging a formula down will keep the row of the reference cell constant)
  


• Hit the F4 key three times to fix the column (dragging a formula across will keep the column of the reference cell constant)
  

Building simple macros

If you want to create a macro to perform certain actions, and you are unsure of the syntax/code to use, the best way to get the code is to record a macro, manually perform the task, and check what code is produced once you stop recording.