Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

2. Visual Design: Spreadsheets as art > How to format your data

How to format your data

In order to format your cells the way you want, select those cells and then choose formatting options on the Home tab of the Ribbon.

image with no caption
There are no Dumb Questions

Q:

Q: So the formulas you write completely ignore the formatting choices you make?

A:

A: Not entirely. Excel does try to figure out how to format your formula’s cells by looking at the arguments in your function. If, for example, you wanted to use the SUM function to add a bunch of numbers that were already formatted as currency, Excel would automatically apply that formatting to the cell where you put your formula.

Q:

Q: What if I wanted to use SUM to add a number that was formatted as currency with a number that didn’t have any formatting?

A:

A: In that case, Excel would have no way of knowing what the calculation meant and would have the formula output display without any formatting.


  

You are currently reading a PREVIEW of this book.

                                                                                        

Get instant access to over
$1 million worth of books and videos.

  

Start a Free Trial