Two Excel Questions

Factual Questions
1

I have two (what I hope are) simple Excel questions:

  1. How do I change the name of a cell? I’m under the impression that I can rename, for example, cell B6 “Average Monthly Sales” so that a formula referring to that cell would be =Average Monthly Sales*12.
  2. How do I add a suffix to the quantity of a cell? I’d like to enter a raw number into a cell but have it displayed with a custom suffix so inputing 30 would be shown as 30lbs.
2
  1. How do I change the name of a cell? I’m under the impression that I can rename, for example, cell B6 “Average Monthly Sales” so that a formula referring to that cell would be =Average Monthly Sales*12.

Insert>Name>Define will allow you to name a cell or range of cells

  1. How do I add a suffix to the quantity of a cell? I’d like to enter a raw number into a cell but have it displayed with a custom suffix so inputing 30 would be shown as 30lbs.

You could add a units column and concatenate. So if the weights are in column D, you could have units in column E and in column F use the formula =D1&E1



D          E          F
30         lbs.      =D1&E1

gives you

D          E          F
30         lbs.      30lbs.
3

A way I find even easier is to navigate to the cell you want to rename. Near the upper left corner pf the spreadsheet just above the leftmost column label you see, you should see the cell’s current name in a small box. Click on the box and change the name to what you want.

After you’ve changed the name any time you use it in a formula, the new name will appear. However, previous uses of the old name in any formulas will not be changed. They will still be E23 or whatever. You can change your previous uses to the new name by clicking on Insert/Name/Apply, highlighting the new name in the list and clicking OK.

(BTW If you copy a formula with a name reference it will be an absolute rather than relative reference.)

4

Select the cell(s), select Format|Cells, choose the ‘Number’ tab, choose the ‘Custom’ category, and type:
0"lbs"