Lets see how it can be used to find and replace text and numbers in a spreadsheet and also some of its advanced features.

Type the text or number you want to use as a replacement value within the Replace With text box.

Click the Options button to expand the window and see these.

On most days, he can be found teaching Excel in a classroom or seminar.

Alan gets a buzz from helping people improve their productivity and working lives with Excel.

Since we launched in 2006, our articles have been read more than 1 billion times.

However, when working with a cell containing multiple lines of text, it can be frustrating to create a new line.

Below are the keyboard shortcut keys to make this task easy.

When ready for a new line, press and hold down the Alt key, then press the Enter key.

For help creating a comment, see: How to create, edit, and delete a comment in Microsoft Excel.

To use this keyboard shortcut, type text in the cell and when ready for a new line, press and hold down the Alt key, then press the Enter key.

To create a new line on the Mac, use the Control Option Return keyboard shortcut.

To use this keyboard shortcut, type text in the cell and when ready for a new line, press and hold down the Control key, Option key, and Return key.

Excel For Mac 2011 Center Text