#INA XCE 2010 HOW TO#
Is there a lot of unusual formatting in your spreadsheet, but you are unsure of how to remove it? This article will show you how to clear formatting from selected cells. You can then continue with Steps 4 – 6 above. Then clicking the Format button in the Cells section of the navigational ribbon and selecting the Format Cells option. If you are unable to right-click in Step 3 above, then you can also access the Format Cells window by clicking the Home tab at the top of the window Step 6: Click the OK button at the bottom of the window to apply your changes. Step 5: Click your preferred formatting option under Negative numbers. Step 4: Click the Number or Currency option at the left side of the window, depending upon the type of data you are working with. Step 3: Right-click on one of the selected cells, then click the Format Cells option. You can click a column letter or row number to select that entire column or row, or you can read this article to learn how to select all of the cells in the spreadsheet. Step 2: Use your mouse to select the cells to which you wish to apply this formatting. You can select whichever option you prefer. You will actually have two options to achieve the desired behavior one option is for black numbers with parentheses, and the other option is for red numbers with parentheses. The steps below will show you how to adjust the formatting of a group of cells that you have selected. Our short tutorial below will show you how to select cells and format them to automatically add parentheses around any negative number.Īutomatically Add Parentheses Around Negative Numbers in Excel 2010 Excel 20's Data Analysis command supports us a group tools of financial and scientific data analysis, including the Moving Average tool which can help you to calculate the average of a specific range and create a moving average chart easily.
Fortunately Excel 2010 has a formatting option that will automatically place parentheses around negative numbers, which can make them easier to locate.īut this formatting is typically not applied by default, so you will need to add it yourself.
If, for example, you have a spreadsheet that tracks balances of accounts, then you may be most interested in the accounts that have a negative balance. When you are working with a lot of data in Microsoft Excel 2010, it is often beneficial to format certain types of data so that they stand out.
0 kommentar(er)
