Formatting Excel 2010 Cells & Worksheets

View:  
Sorted by:  

How to Insert a Hyperlink to a Different Cell in an Excel 2010 Workbook

You can insert a hyperlink in Excel 2010 that anyone can click to jump to a different cell in the current workbook. The hyperlink can appear in a worksheet cell, or it can be associated with a graphic [more…]

How to Insert a Hyperlink to a File or Web Site in Excel 2010

You can insert a hyperlink in Excel 2010 that anyone can click to jump to Web sites or open other files. The hyperlink can appear in a worksheet cell, or it can be associated with a graphic object, such [more…]

How to Insert a Link to Send an E-mail in an Excel 2010 Worksheet

You can insert a "mailto" hyperlink in Excel 2010 that anyone can click to create an e-mail to a specific address. The hyperlink can appear in a worksheet cell, or it can be associated with a graphic object [more…]

How to Indent Cell Data in Excel 2010

In Excel 2010, use the Increase Indent and Decrease Indent buttons in the Alignment group on the Home tab to change the indentation of cell contents. This feature is commonly used to enhance the appearance [more…]

How to Rotate Cell Data in Excel 2010

Use the Orientation button on the Home tab in Excel 2010 to rotate data in cells. You can rotate data clockwise, counterclockwise, or vertically. Use the Format Cells dialog box to set a more precise orientation [more…]

How to Wrap Excel 2010 Data to See All the Text

Use the Wrap Text button on the Home tab of Excel 2010 to wrap lengthy text in a cell by displaying it on multiple lines within the cell. This feature helps you to avoid the problem of having to abbreviate [more…]

How to Format Fonts in Excel 2010

Excel 2010 includes several ways to format the fonts in your worksheets. You can change the font face, font size, and font color using the commands in the Font group on the Home tab. [more…]

How to Change Excel 2010's Default Font and Font Size

By default, Excel 2010 uses the 11-point Calibri font for cell entries, but you can change this to another font or font size of your choice for all new workbooks. [more…]

Merging and Splitting Cells in Excel 2010

You can merge and center data horizontally or vertically across multiple cells in Excel 2010. You also can unmerge or split a merged cell into its original, individual cells. A common use of merge and [more…]

How to Add Cell Borders in Excel 2010

In Excel 2010, you can add borders to individual cells to emphasize or define sections of a worksheet or table. Use the Borders button in the Font group on the Home tab to add borders of varying styles [more…]

How to Apply Fill Colors, Patterns, and Gradients to Cells in Excel 2010

You can add emphasis to selected cells in an Excel 2010 worksheet by changing the fill color or applying a pattern or gradient effect to the cells. If you're using a black-and-white printer, restrict your [more…]

Using Excel 2010's Cell Comment Feature

You can add a cell comment — an electronic version of a sticky note — to any cell in an Excel 2010 worksheet. Comments allow those reviewing a worksheet to provide instruction, for example, noting how [more…]

How to Add a Background Image to an Excel 2010 Worksheet

You can add a graphic image to the background of cells in an Excel 2010 worksheet. The background image (sometimes called a watermark) should be very light in color or use a greatly reduced opacity in [more…]

How to Apply a Design Theme to an Excel 2010 Worksheet

With themes, Excel 2010 provides a way to uniformly format all the text and graphics in a worksheet. You can do this by simply clicking the thumbnail of the new theme you want to use in the Themes drop-down [more…]

Previewing Excel 2010 Formatting with Live Preview

Excel 2010 includes the Live Preview feature, which enables you to see how a new font, font size, table style, cell style, or number format would look on your selected data before you actually apply it [more…]

How to Copy Excel 2010 Formatting with Format Painter

Use the Format Painter button on the Home tab of the Excel 2010 Ribbon to save time when copying formatting between cells in your worksheets. You also can use Format Painter to quickly copy the width of [more…]

How to Apply a Table Style to an Excel 2010 Table

In Excel 2010, you can apply a predefined table format to a cell range. The Format as Table feature displays an extensive Table gallery with formatting thumbnails divided into three sections — Light, Medium [more…]

How to Apply Conditional Formatting in Excel 2010

Excel 2010's conditional formatting lets you change the appearance of a cell based on its value or another cell's value. You specify certain conditions, and when those conditions are met, Excel applies [more…]

How to Add Data Visualizations in Excel 2010

In Excel 2010, you can instantly apply data visualizations to cells using data bars, color scales, and icon sets that help you understand data variations in your tables. Excel provides several options [more…]

How to Change Column Width and Row Height in Excel 2010

In Excel 2010, you can change any column widths or row heights in your worksheets to improve the readability and appearance of data. For example, if your worksheet contains many numbers, you can widen [more…]

How to Align Excel 2010 Data Horizontally and Vertically

In Excel 2010, you can change the horizontal and vertical alignment of cell data. By default, text is left-aligned, and values and dates are right-aligned. Use the buttons in the Alignment group of the [more…]

Learning anything is easy with For Dummies eLearning!

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.