How to expand a hidden window in Excel

Symptom (s): A user's Excel table has a hidden row set, but not when two is selected to unhide

Reason: Automatic filter turned on

Workaround:

1. Remove the automatic screening and remove the hidden;

2. Directly select the location to cancel the hidden, point table to select the upper left corner of the entire table, or select the range containing hidden rows, put the mouse on the left line number, as shown in the position, Cheng Shi Senche Cross when double click, all hidden lines came out.

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/Office/excel/