answersLogoWhite

0


Best Answer

To toggle between the different views, press CTRL + ` (single left quotation mark, not the apostrophe). In other words, hold down the CTRL key while pressing the ACCENT Mark (the key under the tilda in the top left corner).

User Avatar

Wiki User

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

Wiki User

13y ago

On the Formula Ribbon (Excel 2007), in the Formula Auditing section, click on the Show Formulas button. You will see both labels and formulas, instead of values in the cells. To change back to normal view that shows cell values instead of formulas, click the Show Formulas button again to toggle back to the normal view (or whatever view you have set for the worksheet).

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

CTRL key while pressing the ACCENT MARK (`).

This answer is:
User Avatar

User Avatar

Wiki User

13y ago

in the bottom left, there are multiple tabs:

"sheet 1", "sheet 2", "sheet 3"

click on one of them, also you can right click then "rename" to change the name of them

This answer is:
User Avatar

User Avatar

Wiki User

12y ago

If you have set up views on your spreadsheet you can access them through the view menu, or have the toolbar on so that you can pick the view you want.

This answer is:
User Avatar

User Avatar

Wiki User

8y ago

To display all formulas at once using a shortcut, press and hold the Ctrl key and then press the ` key, which is in the top corner of your keyboard.

This answer is:
User Avatar

User Avatar

Wiki User

12y ago

i hold the e button then type it on the csm bbs ur ans so u can go it now with ur home

This answer is:
User Avatar

User Avatar

Wiki User

13y ago

Use the Ctrl and ` keys.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What button do you hold down to toggle between the values version and the formulas version of a worksheet?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Which button should you click if you want to print formulas in a worksheet?

office button


Which elements do you click to add a statistical to a worksheet?

More Functions Button on the Formulas Tab.


Which element do you click to add a statistical function to a worksheet?

More Functions Button on the Formulas Tab.


How can you make a worksheet show the actual formulas rather than the resulting values?

It's the same standard worksheet but just displayed differently. A quick way to toggle between the formulae displayed and the results (normal) view is to hold Ctrl and press the button with three symbols on it just below the Esc button.


What button is used to hide an entire worksheet?

minimize


How do you create a shape in your Excel worksheet using the Shapes button?

Click on the shape you want and then click and drag over the worksheet to draw it onto the worksheet.


How do you turn off automatic calculation on a spreadsheet in Excel?

Go to Options. Under the Formulas section you will see where you can turn it on and off. You can also do it in Calculation Options in the Formulas tab on the ribbon. When it is off, pressing the F9 key will cause the worksheet to recalculate, or you can press the Calculate Now button on the Formulas tab.


What is the on the button math worksheet answer?

The answer is, "I'm falling in love with fractions."


What is the button on the External data toolbar used to refresh the data in a worksheet called?

Refresh all button


What do the Clear All option in the Clear button removes from the active cell?

The clear all option in the clear button removes all data and formulas, including number formats, conditional formats, and borders, from the cell. The cleared cells remain as blank or unformatted cells on the worksheet.


You can magnify or shrink the appearance of a worksheet or chart by using the button on the View tab on the Ribbon?

Zoom button on the View Tab


You can magnify or reduce the view of a worksheet with?

Go to view Tab and click the Zoom button