How to create a Data List in Excel 2007
Creating a new data list in a worksheet is much like creating a worksheet table except that it has only column headings and no row headings.
All articles tagged: cell
How to add WordArt to a Sheet in Excel 2007
If selecting gazillions of preset shapes available from the Shapes gallery doesn’t provide enough variety for jazzing up your worksheet, you may want to try adding some fancy text using the WordArt gallery opened by clicking the WordArt command button in the Text group of the Insert tab.
How to Modify the Fields in a Pivot Table in Excel 2007
To modify the fields used in your pivot table, first you display the Field list by following these steps:
How to Produce a Pivot Table in Excel 2007
Creating a pivot table has never been as easy as it is in Excel 2007: simply open the worksheet that contains the data list you want summarized by the pivot table, position the cell cursor somewhere in the cells of this list, and then click the Pivot Table command button on the Ribbon's Insert tab or press Alt+NVT.
Move or Copy Excel Sheets to other Workbooks in Excel 2007
In some situations, you need to move a particular worksheet or copy it from one workbook to another.
How to Lock Entire Workbooks in Excel 2007
Locking workbooks in Excel is a great way to prevent yourself of breaking the whole thing when you are not suppose to touch it. Protect yourself from such actions by locking the whole thing.
Protect an Excel Sheet by Locking the Entire Sheet in Excel 2007
After you more or less finalize a worksheet by checking out its formulas and proofing its text, you often want to guard against any unplanned changes byprotecting the document.
Naming constants in Excel 2007
Certain formulas use constant values, such as a 7.5% tax rate or a 10% discount rate. If you don't want to have to enter these constants into a cell of the worksheet in order to use the formulas, you create range names that hold their values and then use their range names in the formulas you create.
Creating a custom header or footer in Excel 2007
Most of the time, the stock headers and footers available on the Header buttons and Footer buttons drop-down menus are sufficient for your report printing needs.
Copying custom styles from one workbook into another in Excel 2007
Excel makes it easy to copy custom cell styles that you've saved as part one workbook into the workbook you're currently working on. To copy custom styles from workbook to another, follow these steps:
Nonadjacent cell selections with the keyboard in Excel 2007
Selecting more than one cell range is a little more complicated with the keyboard than it is with the mouse. When using the keyboard, you alternate between anchoring the cell cursor and moving the cell cursor to select the cell range and unanchoring the cell cursor and repositioning it at the beginning of the next range.
How to give a Cell a Name in Excel 2007
By assigning descriptive names to cells and cell ranges, you can go a long way toward keeping on top of the location of important information in a worksheet. Rather than try to associate random cell coordinates with specific information, you just have to remember a name.