How does Excel hide areas that don't need to be displayed?

Due to work needs, often used in Excel, today learned to hide in Excel do not need to show the area, to share with you, hope to everyone help Oh!

1, first select the need to hide areas that do not need to be displayed, as shown in the figure:

2, then, press the shortcut key "Ctrl+1", will pop up cell format, as shown in the figure:

3, again in the cell format select "Custom", the type "g/General format" to ";;;", as shown in the figure:

4, finally, press "OK", want to hide the area has disappeared, is not very simple!

Note : More wonderful tutorials Please pay attention to the triple Office software tutorial section, triple Computer office group: 189034526 welcome you to join