answersLogoWhite

0


Best Answer

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

12y ago

Formatting numbers allows you to display them in different ways, such as in currency or in percentages, which are relevant to what you are doing. Formatting can also make numbers more meaningful or simpler to understand. You can also do things like have negative numbers appear in red to make them stand out.

This answer is:
User Avatar

User Avatar

Wiki User

12y ago

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Why do you use formatting in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What command would you use to erase only the formatting in a cell in excel?

Backspace?


What Excel property help to design date in style?

Formatting. There are many ways of formatting dates in Excel.


If you have finished formatting a chart and now need to create a new chart that uses the same formatting for inclusion in a presentation How can you use this efficiently in Excel 2007?

Use format painter


What are formatting features of Excel?

There are lots of formatting features in Excel. You have the standard ones on fonts, like size, colour, bold, italics, underline etc. Then you have ones for values, such as formatting for numbers, currency, date, percentage, scientific etc. You have built in styles that you can use. You have Autoformat, for formatting whiole tables. You also have conditional formatting, where you can formatting things based on the value in the cells. For example you could display marks in red where it is a fail in an exam and green for marks that have passed. There is formatting for other things you can create, like formatting on charts. So there are many types of formatting that Excel has available.


In Excel can you highlight columns with a date that is over a year old automatically?

use conditional formatting


If the condition is true does Excel apply the formatting?

It will if you are asking about conditional formatting.


Where are PivotTable formatting tools located in Excel?

When a pivot table is active, you can show its toolbar in older version of Excel and in the new versions the Pivot Table tools will be on the ribbon. Standard formatting, such as fonts, can be applied with the normal formatting options available in Excel.


How do I retain Excel cell formatting during mail merge into a table in Word?

Merge brings one to several individual cells from Excel into Word. The formatting in the merged Word document depends on Word, not Excel. If you would like to retain the same formatting as you had in Excel, then format the target location in Word to match the cell from Excel.


Is formatting as important to a spreadsheet as it is to a word processing document?

Yes. There are different types of formatting available in Excel and they are very important. General text formatting, as found in Word, is not as important as number formatting when it comes to Excel. They are important though. The most important thing is that all your calculations are correct. It is no use having a fancy looking spreadsheet that has its calculations wrong.


Are there borders and shading in Excel?

Yes. They are part of the formatting options. You can use the Border options and the Fill options for this purpose. Press Ctrl - 1 to access the Formatting options.


How do you undo conditional formatting in Excel?

There is a delete option when you open the Conditional Formatting option. You could also use the Format Painter to paste formatting from a cell with no conditional formatting onto the cell that has.


When using Excel 2010 making a change to the look of data is called what?

It is called formatting. A wide range of formatting options are available within Excel 2010.