Things you can do to cells
Contents
    Things you can do to cells

Section:
    Things you can do to cells

Subsection(s)

  • Change the width of a column of cells
  • Change the appearance of the cell's value
  • Change the width of a column of cells

    Somewhere in your spreadsheet, probably hidden up in the Format: menu somewhere, is an option to change the width of the currently selected column(s). Sometimes columns are too narrow to show all the data in each cell. Other times, a cell is wider than it needs to be, wasting valuable screen space. By selecting a column (or multiple columns) and then changing the width, you can optimize your screen usage and still be able to see all of your data.

    Turns out, you can change the row height as well, although that's not used as often.

    Q. 3
    How am I supposed to know how wide to make a cell?


    Click here for the answer:

    Change the appearance of the cell's value

    Many cells have something "in" them -- they have a value. A spreadsheet gives you considerable control over what that value looks like.

    Of course, most spreadsheets give you access to the usual word-processing-like formatting options: boldface, italics, centering -- that sort of thing.

    More useful are tools given you to change how a value is viewed. Take the number 0.25. This can show up on the screen as:

    ...depending on what meaning you need to ascribe to it. The number is still the same to the computer no matter how you make it look on the screen; changing the formatting is strictly for the benefit of humans trying to make sense out of the data.

    It's incredibly important to always make your data look the way it should. If you're dealing with currency, make the cell look like currency! Same with percentages! It might not make any difference to the computer, but a human reader (including you, if you come back to a spreadsheet after a couple weeks) won't be able to make heads nor tails out of your data if you don't format it correctly.

    Q. 4
    Wait. I'm still not sure I get this whole formatting thing. How is it different than boldface?


    Click here for the answer:

    Q. 5
    So, you mentioned something about this and dates before?


    Click here for the answer:

    Q. 6
    Can I format lots of cells at once?


    Click here for the answer:


    Bill Dueber