How do you reverse Ctrl 9 in excel?
The keyboard key combination for hiding rows is Ctrl+9:
- Click on a cell in the row you want to hide to make it the active cell.
- Press and hold down the Ctrl key on the keyboard.
- Press and release the 9 key without releasing the Ctrl key. The row containing the active cell should be hidden from view.
What is F9 used for in excel?
Once highlighted, pressing the F9 key calculates the highlighted portion and simply displays its value or result. This can be helpful for understanding how complex formulas are working, debugging why complex formulas are not working as expected, or for determining the source positioning of any error value.
What is the key of Ctrl F9?
Ctrl+F9: Insert new Empty Field {} braces. Ctrl+Shift+F9: Unlink a field. Alt+F9: Toggle the display of a field’s code.
What does Ctrl Shift F9 do?
To do so, select the entire field or expression and press Ctrl + Shift + F9. Word will remove the field code, leaving only the text. If you want to retain the field code, but prevent automatic updates, lock the field by selecting it and pressing Ctrl + F11.
How do I unhide hidden rows in Excel?
On the Home tab, in the Cells group, click Format. Do one of the following: Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns.
How do I enable F9 in Excel?
Re-enabling F9 in Excel Print
- Go to the File tab.
- Select Options.
- Select Add-Ins.
- At the bottom in the Manage box, select Disabled Items and click Go. If F9 is listed there, re-enable.
Why is F9 not working in Excel?
Resolving The Problem Inside Excel, click the add-in “Controller”. Then click “Log on”. Type in your username/password (to authenticate to Controller). – Now the F9 key will work OK.
What does Ctrl +9 do?
Press Ctrl + 9 to hide selected rows, Ctrl + Shift + 9 to unhide any hidden rows, Ctrl + 0 (zero) to hide selected columns, and Ctrl + Shift + 0 to unhide any hidden columns.
Why is Shift F9 not working in Excel?
Most likely, you have your funtion lock enabled by accident. Try pressing Fn + Esc and try F9 again. It should resolve your problem.
What does F9 and F10 do?
Using the F9 and Fn key at the same time opens Mission Control on an Apple computer running macOS X. In Microsoft Windows, it activates the menu bar of an open application. Shift+F10 is the same as the right-clicking on the highlighted icon, Internet link or file.