answersLogoWhite

0


Best Answer

Text is used to give information to the user, like titles over columns or beside rows or beside totals.

You can also use text formatting and apply it to numbers. You can display a phone number by preceding it with a ' if it starts with zero like this:

'0123456

Without the ' the zero would disappear when the number is typed in. There are also lots of text functions used for formatting text.

User Avatar

Wiki User

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

Wiki User

12y ago

So you can tell what is in what column/row.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Why use text in a excel worksheet?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is content text?

If this question is in reference to Excel, it is the text contained in the content of the worksheet.


What does a WordArt text is called in Excel?

WordArt is text in a graphical form. There are many styles you can choose from including different colours, 3 dimensional text, text at different angles or curved or in wave shapes and so on. These are all styles.


With a good understanding of the requirements document an understandind of the necessary deceions a d a sketch of the worksheet the next step is to?

use Excel to create the worksheet...good luck on your test:)


How can you change numbers to text in an Microsoft Excel worksheet?

Select cell formatting and change to text. After than, Excel will treat the numbers in a cell the same as any other text characters. Also, you will not be able to use that cell in a formula, because the formula will not recognize the characters as numbers.


How do you split multi-worksheet Excel files into single-worksheet ones?

Excel worksheet Separator is a powerful, friendly and easy-to-use Excel tool to split multi-sheet excel files into single sheet excel files with high speed. This excel tool can easy to find you excel files and change the complicated ,duplicate and boring excel works into easy ones.


Is use to place titles on a worksheet?

text


What does spelling button mean in Excel?

It runs a spell-checker to allow you to check for spelling mistakes in text in the worksheet.


How do you add a text note in Excel?

To add what is called a comment in a cell in Excel, press Shift-F2. You can also draw a text box on the worksheet and type text into that. A comment will only be seen when you put the cursor over the cell. The text box can be seen at all times.


How do you get a text box in Excel?

You can find it on the drawing toolbar or on the Insert tab. Then click on it and drag out over the worksheet wherever you want it.


What cell does formulas and functions in Excel make use of?

Cells are the fundamental element of a worksheet. All formulas are put into them. Most functions and formulas will reference cells on the worksheet. So cells are extremely important in Excel. Without them, you do not have a worksheet.


Can you use absolute and relative reference in the same worksheet in excel?

Yes, you can use as many combinations of absolute and relative references as you like on the same worksheet.


What allows data easy to summarize and charted in excel?

An Excel worksheet or spreadsheet allows data to be easily summed and charted.