1、以excel2010版本为例，如图要冻结B2单元格上面一排和左边一排的窗口；/iknow-pic.cdn.bcebos.com/b3119313b07eca80f113ca799c2397dda144831e"target="_blank">/iknow-pic.cdn.bcebos.com/b3119313b07eca80f113ca799c2397dda144831e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"wqktp="https://iknow-pic.cdn.bcebos.com/b3119313b07eca80f113ca799c2397dda144831e"/>2、首先选中B2单元格，然后点击页面上方的“视图”选项；/iknow-pic.cdn.bcebos.com/dc54564e9258d10961de5a2cdc58ccbf6c814d6b"target="_blank">/iknow-pic.cdn.bcebos.com/dc54564e9258d10961de5a2cdc58ccbf6c814d6b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"wqktp="https://iknow-pic.cdn.bcebos.com/dc54564e9258d10961de5a2cdc58ccbf6c814d6b"/>3、在视图菜单栏下找到“冻结窗格”，点击“冻结拆分窗格”选项；/iknow-pic.cdn.bcebos.com/838ba61ea8d3fd1fa13451a43d4e251f95ca5f6b"target="_blank">/iknow-pic.cdn.bcebos.com/宏饥838ba61ea8d3fd1fa13451a43d4e251f95ca5f6b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"wqktp="https://iknow-pic.cdn.bcebos.com/838ba61ea8d3fd1fa13451a43d4e251f95ca5f6b"/>4、则可成功的把B2单元格上面一排和左边一排的窗含搜口同时冻结了，鼠标往下移动时上面一排是不动的，鼠标往右移动时，左边一排是不动的。/iknow-pic.cdn.bcebos.com/c75c10385343fbf2223a55bdbd7eca8065388f1e"target="_blank">/iknow-pic.cdn.bcebos.com/c75c10385343fbf2223a55bdbd7eca8065388f1e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"wqktp="蔽老返https://iknow-pic.cdn.bcebos.com/c75c10385343fbf2223a55bdbd7eca8065388f1e"/>
