Get the Red Out of Negative Spreadsheet Numbers

BY STANLEY ZAROWIN

Key to Instructions

To help readers follow the instructions in this article, we use two different typefaces.

Boldface type is used to identify the names of icons, agendas and URLs.

Sans serif type indicates commands and instructions that users should type into the computer and the names of files.


Q. All of my spreadsheets display negative numbers in red rather than preceded by a negative sign. I don’t mind the red on the screen, but when I print a worksheet, those negative numbers come out a light gray because I use a black-and-white laser printer. I know I can format a cell to appear with the negative sign rather than in red or I can go to Page Setup (under the File menu) and change to black-and-white printing, but is there a way to change the default so I won’t have to make these changes every time?

A. There certainly is. Before showing you how, let’s take a moment to demonstrate how to format an individual cell or a group of selected cells to display a negative number in red or with a minus sign.

With the target cell(s) highlighted, click on Format, Cells (or right-click, Format Cells ). That produces the Format Cells screen (see right).

Notice your options: You can select the number with a minus sign, in red, in parentheses, or in parentheses in red.

If you want to extend the format change to default to the style of your choice, click on Format, Style . That brings up the Style screen (see below).

To change the appearance of a number, click on Modify , which brings up the same Format Cells screen as before—only now, any change you make will become a default style. Notice the Style name menu at the top of the screen. Clicking on the down-pointing arrow displays all your existing style categories. The first name in the list is Normal . If you want the change to be evoked in the Normal style (that’s Excel’s opening default style) make the changes there. Or you can create a unique style and give it a unique name—say, My Favorite.

Also, notice that you can combine several elements to a style by clicking on Add . Or, if you already have a named style, you can merge this style choice into it by clicking on Merge .

Now that you know how to format negative numbers, let’s hope you don’t have many of them in your future accounting reports.

SPONSORED REPORT

Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.

QUIZ

News quiz: IRS warning on cyberattacks and a change in pension rules

Once again, the IRS sounds the alarm about a threat from cyberthieves. See how much you know about this and other recent news with this short quiz.

CHECKLIST

Bolster your data defenses

As you weather the dog days of summer, it’s a good time to make sure your cybersecurity structure can stand up to the heat of external and internal threats. Here are six steps to help shore up your systems.