How do 2010 Excel tables hide row and column cells?

Excel spreadsheets are very common office software, how Excel2010 hides row and column cell methods. Excel has 1048576 rows and 16384 columns. Sometimes we only need a little bit of it to do the table. Other empty parts, although they will not be printed, but feel a lot more. Can you delete or hide it? The following small series will tell you how to hide the row and column cell methods.

method: When you select the table you do not show when selecting the line, with the SHIFT + CTRL + down arrow key, then right-click you select a row, click on the & ldquo; hide & rdquo; that was it.

Method 2: Enter ""X:1048576" directly in the input line; here "X” is the number of lines you need to display.

The above is the Excel2010 hidden row and column cell method brought to you by Xiaobian. It is very simple, but it is very easy to use. Related reading: 1, iOS10 Beta 5 update 8 new changes in the content of the introduction 2, how to use the mobile phone version?