Named ranges can be used as a substitute for cell reference when used in functions, formulas, and charts. To correct the problem, widen column C using the method described in the preceding step of the tutorial.Ī named range is created when one or more cells are given a name to make the range easier to identify. Data that has been formatted as a specific type of number – such as currency, dates, or time, however, do not spill over to the next cell if they are wider than the cell where they are located. If a row of hashtag symbols appear in cell C2 instead of the date after adding the TODAY function to that cell, it is because the cell is not wide enough to display the formatted data.Īs mentioned previously, unformatted numbers or text data spill over to empty cells to the right if it is too wide for the cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |