北京快3

当前位置:主页 > Excel教程 > Excel2003教程 >

Excel2003在表格中如何固定表头

  有时候我们在Excel中统计数据时希望将表头一些固定名称不动,然后滚动下面的数据来光看数据。比如下图所示的成绩单,我们希望将上面的成绩单和姓名、语文、数学等各科目数据固定起来,然后滚动查看下面的姓名和分数情况。具体操作如下:

固定成绩单表头

  ①首先,我们将鼠标定位到需要固定表格的下面。如,这里我选中第一行的姓名中,如下图:

选中需要固定的行

  ②单击“窗口”菜单栏中的“冻结窗格”即可;

冻结窗格

  此时,我们就可以固定上面的表头自由滚动查看下面的数据了。

固定表头滚动数据

  • 关注微信关注微信

猜你喜欢

最新评论:27条

  • 匿名 2016-12-07 20:30:10

    HAOYONG ZAN

  • 匿名 2016-08-12 12:41:12

    XIEXIE。HENHAOYONG

  • 匿名 2015-10-19 17:15:45

    YOUYONG,XIEXIE

  • 匿名 2015-05-28 09:25:14

    JIANDANYIXUE。XIEXIELE

  • 匿名 2015-05-19 16:21:59

    北京快3HENSHIYONG,XIEXIE,JIANDANMINGLE,YIXUE。

  • 匿名 2015-05-19 11:35:42

    XIEXIE!

  • 匿名 2015-03-25 09:38:12

    XIEXIE

  • 匿名 2015-01-28 15:01:52

    HENSHIYONG,XIEXIELE

  • 匿名 2014-12-12 13:02:37

    XIEXIE,

  • 匿名 2014-12-02 19:14:10

    XIEXIE

  • 匿名 2014-07-20 09:00:01

    XIEXIE

  • 匿名 2014-06-09 14:29:43

    HAO~

  • 匿名 2014-04-24 08:40:50

    XIEXIE

  • 匿名 2014-02-09 11:38:26

    XIEXIELE

  • 匿名 2013-12-03 15:07:19

    北京快3HENHAO,YOUXUEDAOLEXINDEDONGXI,DANSHIGUDINGBIAOGESHIHUIYOUDUOYUDEXIANTOU,ZENMENONG?

  • 匿名 2013-11-27 17:43:07

    XIEXIE,SHIYONG。

  • 游客 2012-11-08 23:52:56

    {quote}{content}QINGWENKEYIGUDINGZUOBIANDELIEMA?BIRUWOXIANGBAZUOBIANNEILIEDEXINGMINGDOUGUDING ZENMEZUONI?WOANZHAOGUDINGXINGDEFANGFACAOZUO BUXING HAIQINGDUOZHIJIAO XIEXIE{/content}{/quote}YI、ZAICAIDANXUANZECHUANGKOU——CHAIFENCHUANGKOU,ZHEIYANGNIHUIKANJIANCHUANGKOUBEICHAIFENWEISIKUAI。 ER、NIKEYIZIJIBAXUYAOGUDINGDEBUWEIGUDINGHAO,NIZIJITUODONGNEIJITIAOXIANJIUKEYILE,JIUSHIBABIAOTIHEZUOBIANDERENMINGDEDIFANGZIJIXIANGUDINGHAO。 SAN、XUANZECAIDANCHUANGKOU——DONGJIECHUANGGE,ZHEIYANGBIAOTIHAIYOUZUOBIANDERENMINGNEILIANGGEDIFANGJIUDONGJIEZHULE,NIZIJISHISHIKANJIUZHIDAOLE。 SI、RUGUONIXIANGQUXIAODONGJIEDECHUANGGE,KEYIZAIXUANZECHUANGKOU——QUXIAODONGJIEJIUKEYILE。 NIZIJISHISHIKANBA。

  • 游客 2012-09-16 23:50:45

    ERBU

  • 游客 2012-08-30 19:45:51

    北京快3QINGWENKEYIGUDINGZUOBIANDELIEMA?BIRUWOXIANGBAZUOBIANNEILIEDEXINGMINGDOUGUDING ZENMEZUONI?WOANZHAOGUDINGXINGDEFANGFACAOZUO BUXING HAIQINGDUOZHIJIAO XIEXIE

  • 游客 2012-05-24 11:19:05

    FEICHANGGANXIE,HENHAODEJIAOCHENG

  • 游客 2012-05-24 11:01:23

    TAIHAOLE。。XIEXIE!

  • 游客 2012-04-07 00:12:17

    北京快3TIANCAIA ,YUANXIANHAIYIWEIExcelMEIYOUGUDINGZHEIGEGONGNENG,HEHE,HAIHAOYUJIANGAOSHOULE,BURANYAOBEIBIERENXIAOSI,WOYEJIBENSHIGECAINIAO~ XIWANGYIHOUNENGXUEDAOGENGDUOZHISHIBA!

  • 游客 2012-04-07 00:11:23

    JINGPI,ZHAOLEBANTIANCAIZHAODAO,ZHENSHIHUANEIMEZHANGSHIJIANZAIWANGSHANGZHAO,JIUZHEILICAIZHAODAOGUDINGBIAOTOUFANGFA,FEICHANGBUCUO,ERQIEHENRONGYIXUEHUI,WOBIANKANTUPIAN BIANZIJICAOZUOJIUOKLA。WANMEIA!~

  • 游客 2012-03-31 07:12:16

    XIWANGRIHOUDUODUOTIBA!

  • 游客 2012-03-28 13:12:35

    YOUXUEDAOLE,TAIGANXIELE

  • 游客 2012-03-13 23:25:35

    HAOFANGFA,XIEXIEGONGXIANGA,RANGWOZAINIMENWANGZHANXUEXILEBUSHAOExcelBIAOGEDEZHISHI,DUILE,WOYONGDESHIExcel2007BANBENDEYINGGAIYEKEYISHIXIANGUDINGBIAOTOUBA?

  • 游客 2012-03-04 00:42:16

    北京快3YUANLAIZAIZHEILI,WOZHONGYUZHAODAOLE。LAOSHITAIGANXIELE,NIDEFANGFAHENHAO,ERQIETUPIANJIAWENZIHENSHIQINGXI,WOWANQUANMINGBAILE,HAIXIWANGLAOSHIRIHOUKEYIDUOCHUDIANJIQIAO,KEYIRANGWOXUEDEGENGDUO。WENXIA,XIALACAIDANZENMEZUOYA。NIMENZHEILIYOUMEIYOUJIAODEFANGFA

发表评论

看不清?点击更换

微信公众号

微信公众号
var _hmt = _hmt || []; (function() { var hm = document.createElement("script"); hm.src = "https://hm.baidu.com/hm.js?be055eb5acfdc25d3bd72279b8418725"; var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(hm, s); })();