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…]

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…]

Improve Your Excel Reports with Effective Number Formatting

How a table is designed has a direct effect on how well an audience absorbs and interprets the data in that table. In Excel reporting, every piece of information in your table should have a reason for [more…]

Improve Your Excel Reports with Subdued Labels and Headers

You can improve the readability of your Excel reports by using subdued labels and headers. No one would argue that the labels and headers of a table aren’t important. On the contrary, they provide your [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…]


Sign Up for RSS Feeds

Computers & Software