Online Test Banks
Score higher
See Online Test Banks
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 in Excel 2013

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 Set Regional Dates in Excel 2013

Excel 2013 isn’t set up to automatically recognize European date formats in which the number of the day precedes the number of the month and year. For example, you may want 6/11/2014 to represent November [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…]

Insert and Delete Rows and Columns in Excel 2013

Excel 2013 makes it easy to insert and delete rows and columns to deal with many kinds of changes. Even if you’re a careful planner, you’ll likely decide that you want to change your worksheet’s structure [more…]

How to Insert and Delete Cells and Ranges

In Excel 2013, you can insert and delete individual cells or even ranges that don’t neatly correspond to entire rows or columns. When you do so, the surrounding cells shift. In the case of an insertion [more…]

Row Height and Column Width in Excel 2013

Each column in a worksheet starts with the same width, which is 8.43 characters (based on the default font and font size) unless you’ve changed the default setting. That’s approximately seven digits and [more…]

How to Change a Row’s Height in Excel

You can resize rows and columns Excel 2013 in several ways. You can auto-fit the cells’ sizes to their content, manually drag the widths and heights, or enter a precise value for the widths and heights [more…]

How to Change a Column’s Width in Excel

In Excel 2013, when content overruns a cell’s width, different results occur depending on the type of data and whether the cell’s column width has been adjusted manually. [more…]

How to Use Theme Formatting in Excel 2013

Themes and table styles are two ways in Excel 2013 of applying formatting to an entire worksheet or data range at once. (Themes are formatting presets that you can apply to entire worksheets.) Each one [more…]


Sign Up for RSS Feeds

Computers & Software
Win an iPad Mini! Enter to win now.

Inside Sweepstakes

Win an iPad Mini. Enter to win now!