Excel 2007, Formatting A Worksheet 8-30-07

2y ago
32 Views
2 Downloads
265.64 KB
5 Pages
Last View : 2m ago
Last Download : 2m ago
Upload by : Allyson Cromer
Transcription

Excel 2007:Formatting a WorksheetThe topics in this section will cover the following: UndoClearing CellsFormatting ValuesFormatting LabelsFormat PainterCentering Text Across ColumnsUndoExcel and other Windows applications have a convenient method of correctingmistakes known as Undo. In many applications, including Excel, you can undoan almost limitless number of commands. The Undo button has a small downpointing arrow next to it. When pressed, it will display a list of actions that can beundone. Redo works in the same way, allowing you to repeat actions.Excel will undo actions in reverse chronological order, meaning that the mostrecent command is reversed first, then the one prior to that, and so on. Youcannot reverse an earlier action using Undo without first undoing the actions thatwere performed after it.NOTE: The list of commands to undo is reset after the file is saved. Youcannot use Undo to fix an error after the file is saved.To Undo a Command:Click UndoClearing CellsAs we begin to look at formatting, it is important to understand what makes upthe contents of a cell. There are three distinct items that can be in a cell: Contents Formats CommentsThese allow items to be formatted properly, even if the values change. However,when trying to delete or clear a cell, it can be a bit tricky. Excel stores formatsand contents separately, simply deleting the contents does not delete the format.8/30/07 Rev11

To Clear a Cell Format:1) Click in the cell that contains formatting2) Select the arrow on the Clear button on the Home Ribbon (EditingSection)3) Select Clear FormatsFormatting ValuesApplying formats to any cell can be done either using the Format menu or usingthe Formatting toolbar, which has the most commonly used formatting options onit.To Apply the Currency Format:1) Highlight cells2) Click on the Currency Style buttonon the Home Ribbon3) If necessary, click on the Increase or Decrease Decimal buttonHome Ribbonon theTo Apply the Comma Format:1) Highlight cells2) Click on the Comma Style buttonon the Home Ribbon3) If necessary, click on the Increase or Decrease Decimal buttonHome Ribbonon the2

Formatting LabelsA Label, or text formatting is applied virtually the same way it is done in wordprocessing programs.To Format the Title Labels:1) Highlight the cell(s)2) Select a font from the Font Section of the Home Ribbon3) Select a Point size from the Font Section of the Home Ribbon3

Format PainterFrequently, you will need to take a format that is applied to one cell and apply itto other cells. A quick way to do this is by using the Format Painter.To Apply a Format to Cells:1) Highlight cell(s)2) Format the cell(s) to the desired format3) Select the formatted cell(s)from the Clipboard Section of the Home4) Click the Format PainterRibbon5) Highlight the cells you wish to formatTips and Tricks: If you would like the Format Painter to remain active, doubleclick the Format Painter. It will remain active until you press the Esc key.To Change a Cell’s Alignment:1) Highlight the cell(s)2) Click the orientation button on the Alignment Section of the HomeRibbon3) Select an alignment4

Centering Text Across ColumnsWhen it comes to titles, it may be preferable to have the information centeredacross the document, rather than in only one cell. Excel uses the feature MergeCells to accomplish this.To Center the Title Across Columns:1) Highlight cell(s)2) Click the Merge and Center buttonHome Ribbonon the Alignment Section of theNOTE: Each cell must be done individually. Excel will delete the contentsof all but the top most cell if multiple cells are selected.This option basically takes all the cells in the highlighted range and merges theminto one large cell. For example, the range A1:F1 became cell A1 after theMerge Cells button was selected. There is no cell B1, C1, etc. any longer.5

Excel 2007: Formatting a Worksheet The topics in this section will cover the following: Undo Clearing Cells Formatting Values Formatting Labels Format Painter Centering Text Across Columns Undo Excel and other Windows applications have a convenient method of correcting mistakes known as Undo. In many applications .

Related Documents:

Excel 5.0 Excel 5.0 1993 Excel 5.0 1993 Excel 7.0 Excel 95 1995 Excel 8.0 Excel 97 1997 Excel 98 1998 Excel 9.0 Excel 2000 1999 Excel 2001 2000 Excel 10.0 Excel XP 2001 Excel v.X 2001 Excel 11.0 Excel 2003 2003 Excel 2004 2004 2.1.2 Worksheet Document Definition: Worksheet Document A worksheet document consists of a single sheet only.

Worksheet 7 Worksheet 8 Worksheet 9 Worksheet 10 Worksheet 11 Worksheet 12 Worksheet 13 Worksheet 14 Worksheet 15 Worksheet 16 Worksheet 17 Worksheet 18 Worksheet 19 . Word Search Brass Family Crossword Percussion Family The Orchestra Facts about the Orchestra Odd One Out Aerophones Scrambled Letters Reed Instruments

Excel 2007 - Part I: Getting Started I. Introduction What is Microsoft Excel 2007? Microsoft Excel is a spreadsheet program. The version covered in this tutorial is Excel 2007. Excel 2007 is different than Excel 2000. The function of a spreadsheet is to store and manipulate data, in particular numerical data.

Excel 2007 Cheat Sheet Find Excel 2003 Commands in Excel 2007 Use this handout to find where Excel 2003 commands are located in Excel 2007. It consists of the following three sections: Navigation tips about getting around in Excel 2007. New location of buttons from the old Standard and

Microsoft Excel 2010 provides a variation on formatting known as conditional formatting. With conditional formatting, cells can be formatted in different colours schemes. Rather than this formatting being applied to all cells in a range, it is applied selectively and based on specific rules. This type of formatting allows you to see,

SECTION: 1 CORE EXCEL (16 Hrs.) EXCEL INTRODUCTION & ADVANCED PASTE SPECIAL TECHNIQUES o Excel Interface o Shortcut Keys o Customizing Excel o Paste Formats, Values, Formulas, Comment, Validations o Operation - Sum, Multiple, Subtract, Divide o Transpose Table FORMULA REFRENCE o Relative o Absolute o Mixed FORMATTING BASIC o Custom Formatting o Conditional Formatting-Readymade

Unit-I: MS-Excel Features of Ms-Excel, Parts of MS-Excel window, entering and editing data in worksheet, number formatting in excel, . Templates and Template wizard: Excels template facility has been greatly enhanced. You can . your spreadsheet more effective. Excel Charts:Excel charts help

Am I My Brother's Keeper? On Personal Identity and Responsibility Simon Beck Abstract The psychological continuity theory of personal identity has recently been accused of not meeting what is claimed to be a fundamental requirement on theories of identity - to explain personal moral responsibility. Although they often have much to say about responsibility, the charge is that they cannot say .