answersLogoWhite

0


Best Answer

In Excel, the prefix view refers to the display of formulas with a single quotation mark ('), which indicates that the cell contains a text string. This is useful for troubleshooting and determining if the cell is being treated as text instead of a formula.

User Avatar

AnswerBot

1h ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is prefix view in excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

what is the prefix for the word view?

'pre'


What is Design View used for in Excel?

Design View is something you will find in Access, not Excel. See the related question below.


Do you need Excel to view in 3-D?

Excel provides 3D charts, if that is what you are referring to, but so do many other spreadsheet applications. So you do not have to have Excel to view 3D charts.


How do you invoke Excel formula in vba?

prefix the excel function with application. eg. a=application.evaluate("1+2+3")


Which workbook view is used most often in Excel?

Normal View.


Does preview have a suffix and a prefix?

It only has a prefix. "View" is the root of the word.


What would you use the Excel Viewer for?

Microsoft Excel Viewer is a program that lets one view and print spreadsheets that were created in Microsoft Excel. The beauty of this program is that one can view the spreadsheets without having to have Microsoft Excel installed on one's computer.


Can Excel be web based?

You can export a spreadsheet to HTML to view on the Web, but you can not operate Excel from a web browser.


What is the root word in preview?

The root word is view, and the prefix is -pre.


How do you keep the header column in Excel visible through out the document?

Use Page Layout view. In Excel 2007, it is located on the View tab of the ribbon, in the Workbook Views section.


What is the Access view that displays data in columns and rows like an Excel worksheet?

Datasheet view


The default view of an excel worksheet is a magnification of what percent?

100%