Skip to search results
PRODUCT
Office.com results
Distribute the contents of a cell into adjacent columns
Article Show All Hide All You can split the contents of one or more cells in a column and distribute those contents as individual parts across other cells in adjacent c...
Excel 2007
Understanding workbooks and worksheets
Article This article is an excerpt from Excel 2007 Bible by John Walkenbach . Also known as, Mr. Spreadsheet, John is a principal of J-Walk and Associates, Inc. and a M...
Excel 2007
Insert or delete cells, rows, and columns
Article You can add columns, rows, or cells to an Excel 2007 worksheet or delete them. Columns insert to the left, rows above, and cells above or to the left.
Excel 2007
Find or replace text and numbers on a worksheet
Article Search for and replace text and numbers using wildcards or other characters in Excel 2007. You can search sheets, rows, columns, worksheets, or workbooks.
Excel 2007
Undo, redo, or repeat an action
Article The undo command works for many common actions, such as typing or pasting. You can redo something right after you undo it, and can also repeat some actions.
Excel 2007, PowerPoint 2007...
Wrap text in a cell
Article In Excel 2007, if you want text to appear on multiple lines in a cell, format the cell so that the text wraps automatically, or enter a manual line break.
Excel 2007
Merge and unmerge cells
Article You can merge more than one cell in Excel 2007 to create a larger, single cell. Only the data in the upper-left cell will remain in the merged cell.
Excel 2007
Combine the contents of multiple cells
Article You can use the ampersand ( &) operator in a formula to combine text from multiple cells into one cell, such as a first name and a last name. Select the cell i...
Excel 2007
Change the column width and row height
Article In Excel 2007, learn how to resize your table rows or columns manually using your mouse, or adjust the column width or row height automatically (auto fit).
Excel 2007
Clear cells of contents or formats
Article You can clear formats from cells (e.g., number formatting), clear comments from cells, or clear the cell contents altogether, which leaves formatting in place.
Excel 2010, Excel 2007
Creating your first worksheet
Article This article is an excerpt from Excel 2007 Bible by John Walkenbach . Also known as, Mr. Spreadsheet, John is a principal of J-Walk and Associates, Inc. and a M...
Excel 2007
What happened to the data form?
Article The Form button has not been included on the Office Fluent user interface Ribbon, but you can still use it in Office Excel 2007 by adding the Form butto...
Excel 2007
Display or hide the fill handle
Article By default, the fill handle and drag-and-drop editing is turned on in Excel so that you can drag the mouse to move and copy cells by doing the following: Move...
Excel 2007
Turn the option to edit directly in cells on or off
Article By default, the option to edit directly in cells is turned on in Excel so that you can edit the contents of a cell directly in the cell. When you turn this opti...
Excel 2007
Automatically number rows
Article Unlike other Microsoft Office programs, such as Word, Excel does not provide a button to automatically number data. However, you can easily add sequential numbe...
Excel 2007
Fill data automatically in worksheet cells
Article Automatically fill a series of data in your worksheet, like dates, numbers, text, and formulas. Use the AutoComplete feature, Auto Fill Options button and more.
Excel 2007
How to fit a multiline heading into one cell
Article By Bill Jelen Bill Jelen is the author of 24 books on Microsoft Office Excel. He is a regular guest on TechTV with Leo Laporte and the host of MrExcel.com , whi...
Excel 2007
Insert symbols and special characters on a worksheet
Article When symbols and special characters are not available on the keyboard, you can use the Symbol dialog box to insert them in a cell on a worksheet. For example...
Excel 2007
Locate and reset the last cell on a worksheet
Article When you save a workbook, Microsoft Office Excel stores only the part of each worksheet that contains data or formatting. Empty cells may contain formatting tha...
Excel 2007
Create a list of sequential dates
Article You can quickly create a list of dates in sequential order by using the fill handle or the Fill command. On a worksheet, select the cell in which you want ...
Excel 2007
Using the status bar selection statistics feature
Article This article is an excerpt from John Walkenbach's Favorite Excel 2007 Tips & Tricks by John Walkenbach . A.k.a. Mr. Spreadsheet, John is arguably the foremost a...
Excel 2007
Insert bullets in a worksheet
Article Add a bullet to a cell in a worksheet using character codes or symbols. In addition to a round bullet, you can choose to add a checkbox or other symbol.
Excel 2010, Excel 2007
Enter data manually in worksheet cells
Article You have several options when you want to enter data manually in Excel. You can enter data in one cell, in several cells at the same time, or on more than one ...
Excel 2007
Turn automatic completion of cell entries on or off
Article Microsoft Office Excel completes text entries that you start to type in a column of data  — if the first few letters that you type match an existing entry in th...
Excel 2007
Enter data in multiple worksheets at the same time
Article In Excel 2007, it's possible to enter the same data into several worksheets without retyping or copying and pasting the text into each one. As an example, let's...
Excel 2007
PREV12NEXT
Didn't find what you were looking for?Search all of Office.com