answersLogoWhite

0


Best Answer

Press and hold the Ctrl key and then press the `key. Make sure it is the `key and not the ' key. It is on the key in the top left corner of the main part of your keyboard.

User Avatar

Wiki User

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

Wiki User

12y ago

Press and hold the Ctrl key and the ' (single quote) key.

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

Crtl+`

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What keyboard shortcut is used to show formulas in a worksheet?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the shortcut keyboard stroke for layers to show palette?

F7 to show/hide LAYERS palette.


Can you off guidelines with image in Photoshop?

You can show-hide guides using keyboard shortcut Ctrl + ;or from from View > Show > Guides (click to uncheck this option)


Does the formulas version in the worksheet show the actual formula you have entered rather than the resulting values?

Yes.


What keyboard command do you use to reveal your rulers on adobe photo shop?

Default keyboard shortcut to show/hide rulers is Ctrl + R on Windows and Cmd + R on Mac computers.


How can you access the Show Formulas button in Excel?

It is on the Formulas tab, in the Auditing section. To hide or show formulas you can also just press Ctrl and the `key, which is the key beside the 1 key on your keyboard.


What is one of the guidelines for good workbook and worksheet design?

Test all of your formulas to ensure they are accurate and reflect what you what to show.


What keys are used to show the cell formula version of the worksheet?

Ctrl and the ` key will show or hide formulas. The `is the apostrophe key, not the single quote key.


Where does a formula appear on a worksheet?

It will appear in the cell as you type it in. When it has been put in, you will see it in the formula bar. If you set the spreadsheet to show formulas, you can see all the formulas in their cells.


How do you find excel formulas?

If you mean to find which cells have formulas and not values, you do it using the Goto option. Press the F5 key and then click on Special, which opens another set of options. From there, select Formulas and all formulas in the worksheet will be selected. Pressing Ctrl and the ' key will show the formulas that are in cells.


What is a context menu in Excel?

It is a menu with items that are relevant to what you are doing at that time. Shortcut menus from a right click on your mouse or the shortcut menu key on your keyboard normally show items that are relevant to what you are working in. In other words they are giving you options based on the context of your work.


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.


How do you get your SMART notebook to show fullscreen?

From the SMART Notebook menu select View > Full Screen. The keyboard shortcut you may use next time is also displayed in the menu next to Full Screen.