Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Formatting Excel 2013 Cells & Worksheets

View:  
Sorted by:  

How to Add Comments to Excel 2013 Worksheet Cells

You can add text comments to particular cells in an Excel 2013 worksheet. Comments act kind of like electronic pop-up versions of sticky notes. For example, you can add a comment to yourself to verify [more…]

How to Select Cells in Excel 2013

Excel 2013 makes it easy for you to select cell ranges with a physical or Touch keyboard by using a technique known as extending a selection. To use this technique, you move the cell cursor to the active [more…]

Format Tables from the Ribbon in Excel 2013

Excel 2013’s Format as Table feature enables you to both define an entire range of data as a table and format all its data all in one operation. After you define a cell range as a table, you can completely [more…]

Format Tables with the Quick Analysis Tool in Excel 2013

You can use Excel’s new Quick Analysis tool to format your data as a new table. Simply select all the cells in the table, including the cells in the first row with the column headings. As soon as you do [more…]

Format Cells from the Ribbon in Excel 2013

The formatting buttons that appear in the Font, Alignment, and Number groups on the Home tab in Excel 2013 enable you to accomplish targeted cell formatting. Some spreadsheet tables require a lighter touch [more…]

Format Cell Ranges with the Mini-Toolbar in Excel 2013

Excel 2013 makes it easy to apply common formatting changes to a cell selection right within the Worksheet area thanks to its mini-toolbar feature — nicknamed the [more…]

How to Select Cells in Excel 2013 with Go To

Although you usually use the Go To feature in Excel 2013 to move the cell cursor to a new cell in the worksheet, you can also use this feature to select a range of cells. When you choose the Go To option [more…]

How to Use the Excel 2013 Format Painter

The Format Painter button (with paintbrush icon) in the Clipboard group of the Home tab of Excel 2013 takes formatting from the current cell and applies it to cells that you “paint” by dragging its special [more…]

How to Create a Custom Cell Style in Excel 2013

You can create a custom cell style from scratch in Excel 2013 by defining each of its formatting characteristics in the Style dialog box as follows: [more…]

How to Merge Custom Styles into Other Excel 2013 Workbooks

If you’ve created custom styles in another workbook in Excel 2013 that you want to use in a new workbook or in an existing one that you’ve opened for editing, you have to merge them into that workbook [more…]

How to Change the Locked and Hidden Cell Formatting

To change the status of cells in an Excel 2010 worksheet from locked to unlocked or from unhidden to hidden, you use the Locked and Hidden check boxes found on the Protection tab of the Format Cells dialog [more…]

Custom Number Formatting in Excel Reports: Zeroes and Colors

In your Microsoft Excel reports, the best way to apply number formatting to cells is to use the Format Cells dialog box, which gives you have the ability to create your own custom number formatting. [more…]

Improve Your Excel Reports by De-Emphasizing Borders

Table design is one of the most underestimated endeavors in Excel reporting. Believe it or not, borders get in the way of quickly reading the data in a table. Because borders help separate data in nicely [more…]

Excel Reports: Custom Number Formatting

You can improve the readability of your Excel reports with custom number formatting. You can apply number formatting to cells in several ways. Most people just use the convenient number commands found [more…]

Format Numbers in Thousands and Millions in Excel Reports

In Microsoft Excel, you can improve the readability of your dashboards and reports by formatting your revenue numbers to appear in thousands. This allows you to present cleaner numbers and avoid inundating [more…]

Format Dates and Times in Your Excel Reports

Custom number formatting isn’t just for numbers. You can improve the look of your Excel dashboards and reports by formatting dates and times as well. As you can see in this figure, you use the same dialog [more…]

Highlight Cells Rules in Excel Dashboards and Reports

You can use conditional formatting to enhance your reports and dashboards in Excel. The formatting scenarios under the Highlight Cells Rules category, shown in this figure, allow you to highlight those [more…]

Enhance Your Excel Reports with Conditional Formatting

Conditional formatting enables you to enhance your reports and dashboards in Excel by dynamically changing the formatting of a value, cell, or range of cells based on a set of conditions you define. Conditional [more…]

Use Symbols to Enhance Reporting in Excel

You can use symbols in Excel to enhance your reports and dashboards. Symbols are essentially tiny graphics, not unlike those you see when you use the Wingdings, Webdings, or other fancy fonts. However, [more…]

Apply Top/Bottom Rules in Excel Dashboards and Reports

Conditional formatting lets you enhance your reports and dashboards in Excel. The formatting scenarios under the Top/Bottom Rules category, shown in this figure, allow you to highlight those cells whose [more…]

Sign Up for RSS Feeds

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

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.