</noscript> <script> function stop(){ return false; } document.oncontextmenu=stop; </script><link href="http://www.zhiqimba.com/thread-1902-1-1.html" rel="canonical" /> <meta name="keywords" content="职起网,书工厂,课程,资料,中级经济师,一级建造师,cpa" /> <meta name="description" content="拒绝碎片化，系统性学习，让考证更容易！ " /> <meta name="generator" content="Discuz! X3.5" /> <meta name="author" content="Discuz! Team and Comsenz UI Team" /> <meta name="copyright" content="2001-2020 Tencent Cloud." /> <meta name="MSSmartTagsPreventParsing" content="True" /> <meta http-equiv="MSThemeCompatible" content="Yes" /> <base href="http://www.zhiqimba.com/" /><link rel="stylesheet" type="text/css" href="data/cache/style_2_common.css?yZi" /><link rel="stylesheet" type="text/css" href="data/cache/style_2_forum_viewthread.css?yZi" /><!--[if IE]><link rel="stylesheet" type="text/css" href="data/cache/style_2_iefix.css?yZi" /><![endif]--><script type="text/javascript">var STYLEIMGDIR='template/xmyc_doc/static/',STYLEID = '2', STATICURL = 'static/', IMGDIR = 'static/image/common', VERHASH = 'yZi', charset = 'utf-8', discuz_uid = '0', cookiepre = 'K8iT_2132_', cookiedomain = '', cookiepath = '/', showusercard = '1', attackevasive = '0', disallowfloat = 'login|newthread', creditnotice = '1|威望|,2|金钱|,3|贡献|,4|职币|', defaultstyle = '', REPORTURL = 'aHR0cDovL3d3dy56aGlxaW1iYS5jb20vZm9ydW0ucGhwP21vZD12aWV3dGhyZWFkJnRpZD0xOTAy', SITEURL = 'http://www.zhiqimba.com/', JSPATH = 'data/cache/', CSSPATH = 'data/cache/style_', DYNAMICURL = '';</script> <script src="template/xmyc_doc/static/js/jquery-3.4.1.js" type="text/javascript"></script> <script src="data/cache/common.js?yZi" type="text/javascript"></script> <link rel="stylesheet" href="template/xmyc_doc/static/js/font-awesome-4.7.0/css/font-awesome.min.css"> <link rel="stylesheet" href="template/xmyc_doc/static/css/iconfont.css"> <meta name="application-name" content="职起网" /> <meta name="msapplication-tooltip" content="职起网" /> <meta name="msapplication-task" content="name=门户;action-uri=http://www.zhiqimba.com/portal.php;icon-uri=http://www.zhiqimba.com/static/image/common/portal.ico" /><meta name="msapplication-task" content="name=首页;action-uri=http://www.zhiqimba.com/forum.php;icon-uri=http://www.zhiqimba.com/static/image/common/bbs.ico" /> <meta name="msapplication-task" content="name=群组;action-uri=http://www.zhiqimba.com/group.php;icon-uri=http://www.zhiqimba.com/static/image/common/group.ico" /><meta name="msapplication-task" content="name=动态;action-uri=http://www.zhiqimba.com/home.php;icon-uri=http://www.zhiqimba.com/static/image/common/home.ico" /><link rel="archives" title="职起网" href="http://www.zhiqimba.com/archiver/" /> <script src="data/cache/forum.js?yZi" type="text/javascript"></script> </head> <body id="nv_forum" class="pg_viewthread" onkeydown="if(event.keyCode==27) return false;"> <div id="append_parent"></div><div id="ajaxwaitid"></div> <!--这是头部菜单栏--> <style type="text/css"> #nv{height: 0 !important;} </style> <div class="row-inner" id="nv" style="height: 0;"> </div> <div class="header " > <div class="xm-container cl" > <h2 class="logo"><a href="./" title="职起网" ><img src="template/xmyc_doc/static//logo.png" alt="职起网" class="boardlogo" id="boardlogo" border="0" /></a> </h2> <div class="site-menu"> <ul class="xs-15"><li class="a "id="mn_forum" ><a href="forum.php" hidefocus="true" title="BBS" >首页<span>BBS</span></a></li> </ul> </div> <div class="header-right cl"> <div class="header-tougao z" style="display: none;"> <span class="ht-item"> <a href="#" target="_blank" class="ht-a "> <img src="template/xmyc_doc/static/image/publish.png" width="28" height="28"/> <i class="sub-txt">发表</i> </a> </span> <div class="tougao-ul" id="tougao_ul" style="display: none;"> <ul class="p_pop xm_p_pop h_pop xm_h_pop"> <li><a href="member.php?mod=logging&action=login"><i class="fa fa-pencil-square-o" aria-hidden="true"></i> 发布文章</a></li> <li><a href="forum.php?mod=misc&action=nav" onclick="showWindow('nav', this.href, 'get', 0)"><i class="fa fa-pencil-square-o" aria-hidden="true"></i> 提问答疑</a></li> </ul> </div> </div> <!-- <div class="header-search z"> <a href="https://www.uisdc.com?s="> <i class="iconfont icon-xiaoxi1"></i> </a> </div> --> <div class="header-search z"> <a href="search.php"> <i class="fa fa-search" aria-hidden="true"></i> 搜索 </a> </div> <div class="login-panel y"> <ul> <li id="login"> <a href="member.php?mod=logging&action=login" class="avatar_a avatar_down" > <img class="" width="36" height="36" src="template/xmyc_doc/static/image/avatar-default.png" /> </a> <div class="login-down" id="avatar_down" style="display: none;"> <div class="login-div notlogin"> <div class="info"> <div class="info-thumb"> <i class="thumb" style="background-image:url(template/xmyc_doc/static/image/avatar-default.png);"></i> </div> <h2 class="user-name">您还未登录</h2> <h4 class="user-info">登录后即可体验更多功能</h4> <a href="member.php?mod=logging&action=login" class="modal-open btn btn-orange info-btn" > 立即登录 </a> </div> <div class="main" style="display: none;"> <div class="main-menu"> <div class="item"> <div class="item-content"><span class="item_a"><i class="iconfont icon-shoucang"></i>我的收藏</span></div> </div> <div class="item"> <div class="item-content"><a class="item_a" href="forum.php?mod=misc&action=nav" onclick="showWindow('nav', this.href, 'get', 0)"><i class="iconfont icon-zixun"></i>提问答疑</a></div> </div> <div class="item"> <div class="item-content"><a class="item_a" href="member.php?mod=logging&action=login" target="_blank"><i class="iconfont icon-fasongxinxi"></i>我要投稿</a></div> </div> </div> </div> </div> </div> </li> </ul> </div> </div> </div> </div> <!--二级菜单--> <div class="xm-ejmenu"></div> <div id="mu" class="cl"> </div><!--提醒--> <script src="template/xmyc_doc/static/js/jquery.mousewheel.min.js?yZi" type="text/javascript"></script> <script type="text/javascript"> jQuery(function(){ jQuery("#mu li a").each(function(){ var _title=jQuery(this).attr("title") || ""; jQuery(this).prepend('<p class="icon"><i class="iconfont icon-zixun"></i></p>'); jQuery(this).append('<p class="desc">'+_title+'</p>'); }) {} // jQuery(window).on("mousewheel",function(event){ // if(event.originalEvent.deltaY >0){//向下滚动 // jQuery("#hd").slideUp('fast'); // jQuery("#fix_forum").hide(); // }else{ // jQuery("#hd").slideDown('fast'); // } // }); jQuery(window).scroll(function(){ var scrollPos=jQuery(window).scrollTop(); if(scrollPos >1){ jQuery(".header").css("position","fixed"); }else{ jQuery(".header").css("position","relative"); } }); //个人更多操作 jQuery(".login-panel").hover(function(){ jQuery("#avatar_down").show(); },function(){ jQuery("#avatar_down").hide(); }); jQuery(".header-tougao").hover(function(){ jQuery("#tougao_ul").show(); },function(){ jQuery("#tougao_ul").hide(); }); }); function showSearch(){ jQuery("#main-search").show(); } function openLogin(){ layer.open({ type: 2, title: '', shadeClose: true, //点击遮罩关闭层 area : ['380px' , '520px'], content: 'login.html' }); } </script> <div id="wp" class="wp"><script type="text/javascript">var fid = parseInt('68'), tid = parseInt('1902');</script> <script src="data/cache/forum_viewthread.js?yZi" type="text/javascript"></script> <script type="text/javascript">zoomstatus = parseInt(1);var imagemaxwidth = '900';var aimgcount = new Array();</script><style id="diy_style" type="text/css"></style> <!--[diy=diynavtop]--><div id="diynavtop" class="area"></div><!--[/diy]--> <style type="text/css"> #wp {width: 100%;} </style> <style id="diy_style" type="text/css"></style> <div class="wp"> <!--[diy=diy1]--><div id="diy1" class="area"></div><!--[/diy]--> </div> <div id="content" class="content cl"> <div id="left" > <div> <div class="help_site"> <span class="x-panel-header-text"> <a href="forum-68-1.html" class="help_name lf" >excel</a> </span> </div> <div class="htmleaf-content bgcolor-3"> <!-- This is mtree list --> <ul class="mtree"> <li id="key_1" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=1">前言</a> </li> <li id="key_2" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2">第一章 基础入门</a> <ul><li id="key_2-1" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.1">第一节 软件</a> <ul><li id="key_2-1-1" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.1.1">1.1 软件介绍</a> <ul><li id="key_2-1-1-t1855" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.1.1">Excel2016版本介绍</a></li> <li id="key_2-1-1-t1856" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.1.1">版本兼容性</a></li> <li id="key_2-1-1-t1857" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.1.1">更新|好用的软件下载集合站</a></li> </ul> </li> <li id="key_2-1-2" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.1.2">1.2 安装与启动</a> <ul><li id="key_2-1-2-t1854" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.1.2">安装Excel2016</a></li> </ul> </li> <li id="key_2-1-3" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.1.3">1.3 工作界面</a> <ul><li id="key_2-1-3-t1858" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.1.3">Excel2016的操作界面</a></li> </ul> </li> </ul> </li> <li id="key_2-2" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.2">第二节 基础操作</a> <ul><li id="key_2-2-1" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.2.1">2.1 新建</a> <ul><li id="key_2-2-1-t1861" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.2.1">工作簿的类型</a></li> <li id="key_2-2-1-t1862" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.2.1">新建工作簿</a></li> <li id="key_2-2-1-t1866" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.2.1">打开和关闭工作簿</a></li> </ul> </li> <li id="key_2-2-2" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.2.2">2.2 保存</a> <ul><li id="key_2-2-2-t1860" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.2.2">设置自动保存</a></li> <li id="key_2-2-2-t1863" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.2.2">保存工作簿</a></li> <li id="key_2-2-2-t1864" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.2.2">另存为兼容格式</a></li> </ul> </li> <li id="key_2-2-3" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.2.3">2.3 撤销与恢复</a> <ul><li id="key_2-2-3-t1865" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.2.3">恢复未保存的工作簿</a></li> </ul> </li> </ul> </li> <li id="key_2-3" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.3">第三节 文件功能区</a> <ul><li id="key_2-3-1" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.3.1">3.1 工作表的设置</a> <ul><li id="key_2-3-1-t1859" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.3.1">自定义操作界面</a></li> <li id="key_2-3-1-t1869" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.3.1">1.1 新建工作表</a></li> <li id="key_2-3-1-t1870" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.3.1">1.2 删除工作表</a></li> <li id="key_2-3-1-t1871" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.3.1">1.3 重命名工作表</a></li> <li id="key_2-3-1-t1872" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.3.1">1.4 移动和复制工作表</a></li> <li id="key_2-3-1-t1873" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.3.1">1.5 隐藏工作表</a></li> <li id="key_2-3-1-t1874" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.3.1">1.6 设置工作表标签颜色</a></li> <li id="key_2-3-1-t1875" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.3.1">1.7 保护工作表</a></li> </ul> </li> <li id="key_2-3-2" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.3.2">3.2 设置</a> </li> <li id="key_2-3-3" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.3.3">3.3 保护</a> <ul><li id="key_2-3-3-t1867" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.3.3">设置工作簿权限密码</a></li> <li id="key_2-3-3-t1868" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=2.3.3">如何撤销工作簿权限密码</a></li> </ul> </li> </ul> </li> </ul> </li> <li id="key_3" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=3">第二章 功能区</a> <ul><li id="key_3-1" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=3.1">1.开始</a> </li> <li id="key_3-2" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=3.2">2.插入</a> </li> <li id="key_3-3" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=3.3">3.页面布局</a> </li> <li id="key_3-4" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=3.4">4.公式</a> </li> <li id="key_3-5" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=3.5">5.数据</a> <ul><li id="key_3-5-t1851" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=3.5">排序</a> </li> <li id="key_3-5-t1852" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=3.5">筛选</a> </li> <li id="key_3-5-t1853" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=3.5">条件格式</a> </li> </ul> </li> <li id="key_3-6" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=3.6">6.审阅</a> </li> <li id="key_3-7" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=3.7">7.视图</a> </li> <li id="key_3-8" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=3.8">8.开发工具/设计</a> </li> </ul> </li> <li id="key_4" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4">第三章 工作区</a> <ul><li id="key_4-1" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">单元格</a> <ul><li id="key_4-1-t1876" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">行、列和单元格的概念</a> </li> <li id="key_4-1-t1877" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">选择行与列</a> </li> <li id="key_4-1-t1878" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">插入行与列</a> </li> <li id="key_4-1-t1879" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">删除行与列</a> </li> <li id="key_4-1-t1880" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">移动行与列</a> </li> <li id="key_4-1-t1881" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">复制行与列</a> </li> <li id="key_4-1-t1882" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">设置行高和列宽</a> </li> <li id="key_4-1-t1883" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">选择单元格</a> </li> <li id="key_4-1-t1884" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">合并与拆分单元格</a> </li> <li id="key_4-1-t1885" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">选择单元格区域</a> </li> <li id="key_4-1-t1886" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">数值</a> </li> <li id="key_4-1-t1905" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">水平对齐与垂直对齐</a> </li> <li id="key_4-1-t1906" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">常规对齐</a> </li> <li id="key_4-1-t1907" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">水平两端对齐和垂直两端对齐</a> </li> <li id="key_4-1-t1908" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">跨列居中和单元格合并</a> </li> <li id="key_4-1-t1909" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">填充</a> </li> <li id="key_4-1-t1910" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">设置文本方向</a> </li> <li id="key_4-1-t1911" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">设置文字方向</a> </li> <li id="key_4-1-t1912" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">新建单元格样式</a> </li> <li id="key_4-1-t1913" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">合并样式</a> </li> <li id="key_4-1-t1914" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">套用内置表格样式</a> </li> <li id="key_4-1-t1915" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.1">新建表格样式</a> </li> </ul> </li> <li id="key_4-2" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">录入与编辑数据</a> <ul><li id="key_4-2-t1887" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">文本</a> </li> <li id="key_4-2-t1888" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">逻辑值</a> </li> <li id="key_4-2-t1889" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">在单元格中输入数据</a> </li> <li id="key_4-2-t1890" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">在多个单元格中批量输入相同数据</a> </li> <li id="key_4-2-t1891" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">输入上标和下标</a> </li> <li id="key_4-2-t1892" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">启用记忆式键入</a> </li> <li id="key_4-2-t1893" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">从下拉列表中选择</a> </li> <li id="key_4-2-t1894" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">修改单元格内容</a> </li> <li id="key_4-2-t1895" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">删除单元格内容</a> </li> <li id="key_4-2-t1896" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">自动换行和强制换行</a> </li> <li id="key_4-2-t1897" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">撤销和恢复</a> </li> <li id="key_4-2-t1898" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">自动填充</a> </li> <li id="key_4-2-t1899" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">自定义填充序列</a> </li> <li id="key_4-2-t1900" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">常规格式</a> </li> <li id="key_4-2-t1901" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">数值格式</a> </li> <li id="key_4-2-t1902" class="mtree-active"><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">文本格式</a> </li> <li id="key_4-2-t1903" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">创建自定义格式</a> </li> <li id="key_4-2-t1904" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=4.2">输入以0开头的数字的方法</a> </li> </ul> </li> </ul> </li> <li id="key_5" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5">第四章 函数运用</a> <ul><li id="key_5-1" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.1">第一节 基本了解</a> <ul><li id="key_5-1-t1916" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.1">1.Excel函数 教程</a> </li> <li id="key_5-1-t1917" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.1">2.函数 简介</a> </li> <li id="key_5-1-t1918" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.1">3.函数 语法</a> </li> </ul> </li> <li id="key_5-2" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.2">第二节 公式运用</a> <ul><li id="key_5-2-1" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.2.1">1.时间和日期</a> </li> <li id="key_5-2-2" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.2.2">2.逻辑函数</a> <ul><li id="key_5-2-2-t1919" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.2.2">2.1 If函数（条件判断）</a></li> <li id="key_5-2-2-t1920" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.2.2">2.2 IfError函数 （错误处理）</a></li> <li id="key_5-2-2-t1921" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.2.2">2.3 And函数 （并且）</a></li> <li id="key_5-2-2-t1922" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.2.2">2.4 Or函数 （或者）</a></li> <li id="key_5-2-2-t1923" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.2.2">2.5 Not函数 (取反)</a></li> </ul> </li> <li id="key_5-2-3" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.2.3">3.文本函数</a> </li> <li id="key_5-2-4" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.2.4">4.查找引用</a> </li> <li id="key_5-2-5" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.2.5">5.数学和三角函数</a> </li> <li id="key_5-2-6" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.2.6">6.统计函数</a> </li> <li id="key_5-2-7" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.2.7">7.信息函数</a> </li> </ul> </li> <li id="key_5-3" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=5.3">第三节 公式汇总</a> </li> </ul> </li> <li id="key_6" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6">第五章 综合实用办公</a> <ul><li id="key_6-1" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">第一节 视图与打印</a> <ul><li id="key_6-1-t1829" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">其他打印参数的设置</a> </li> <li id="key_6-1-t1830" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">打印预览</a> </li> <li id="key_6-1-t1831" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">不连续的区域打印在一页纸上</a> </li> <li id="key_6-1-t1832" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">奇偶页打印不同的页眉页脚</a> </li> <li id="key_6-1-t1833" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">设置页眉页脚</a> </li> <li id="key_6-1-t1834" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">设置页边距</a> </li> <li id="key_6-1-t1835" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">设置起始页码</a> </li> <li id="key_6-1-t1836" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">设置缩放比例</a> </li> <li id="key_6-1-t1837" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">设置纸张方向</a> </li> <li id="key_6-1-t1838" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">设置纸张大小</a> </li> <li id="key_6-1-t1839" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">冻结窗格</a> </li> <li id="key_6-1-t1840" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">冻结窗格</a> </li> <li id="key_6-1-t1841" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">拆分窗口</a> </li> <li id="key_6-1-t1842" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">窗口并排查看与同步滚动</a> </li> <li id="key_6-1-t1843" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">切换窗口</a> </li> <li id="key_6-1-t1844" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">重排窗口</a> </li> <li id="key_6-1-t1845" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">新建窗口</a> </li> <li id="key_6-1-t1846" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">设置表格显示比例</a> </li> <li id="key_6-1-t1847" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">表格显示的4要素</a> </li> <li id="key_6-1-t1848" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">页面布局视图</a> </li> <li id="key_6-1-t1849" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">分页预览视图</a> </li> <li id="key_6-1-t1850" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.1">普通视图</a> </li> </ul> </li> <li id="key_6-2" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.2">第二节 表格制表</a> </li> <li id="key_6-3" ><a href="forum.php?mod=forumdisplay&fid=68&filter=sortid&sortid=17&searchsort=1&excel=6.3">透视图表</a> </li> </ul> </li> </ul> </div> </div> </div> <div id="middle" style="min-height: 100vh;"> <div class="group-contnt cl " style="overflow: hidden;padding: 40px 30px;position: inherit;"> <div id="ct" class=""> <!--发帖按钮的下拉选择发帖类别--> <!--批量选择帖子的操作弹框--> <!--删除主题|升降|置顶|直播|高亮|精华|图章|图标|关闭|移动|分类|复制|合并|分割|修复|标签|生成文章--> <div id="postlist" class="pl" ><div class="thread-t cl"> <div class="main-header mb40"> <p class="xmtitle" id="thread_subject">文本格式<span class="myedit lf"> </span> </p> <div class="desc-list xs-12 cl mt10"> <div class="desc-item"><span class="xc-gray">文档创建者：</span><span class="xc-gray1"><a href="space-uid-1.html" target="_blank">职起网</a></span></div> <div class="desc-item"><span class="xc-gray">浏览次数：</span><span class="xc-gray1">481</span></div> <div class="desc-item"><span class="xc-gray">最后更新：</span><span class="xc-gray1">2023-03-19</span></div> <div class="topico"> <a href="thread-1902-1-1.html" onclick="return copyThreadUrl(this, '职起网')" id="fuzhi" class="tooltipped tooltipped-s" title="复制链接"></a> <a href="home.php?mod=spacecp&ac=favorite&type=thread&id=1902&formhash=a8a6b7e7" onclick="showWindow(this.id, this.href, 'get', 0);" onmouseover="this.title = $('favoritenumber').innerHTML + ' 人收藏'" title="收藏本帖" id="doc_favorite" class="shoucang tooltipped tooltipped-s" title="收藏"> </a> <a id="" class="setting tooltipped tooltipped-s" href="javascript:jQuery('#modmenu').toggle();" ></a> </div> </div> </div> <span class="xg1"> <!-- <a href="thread-1902-1-1.html" onclick="return copyThreadUrl(this, '职起网')" >[复制链接]</a> --> </span> </div> <!--楼主帖子--> <div class="post_1" style="display: none;"> <div class="pst-t cl"> <p class="z"> <a class="tag tag-lg b-radius4" href="forum.php?mod=forumdisplay&fid=68" style="font-size:14px;height:28px;line-height: 28px;color: #007fff;width: inherit;"> <img src="static/image/common/forum.gif" alt="excel" /> excel</a> <span class="pipe"> </span> <span class="">481 人阅读</span> <span class="pipe">|</span> <span class="">0 人回复</span> </p> </div> <!--回帖奖励规则--> </div> <div id="post_411" class="post-item" ><table id="pid411" class="plhin" summary="pid411" style="margin-bottom:20px;border-radius:0 0 8px 8px;" cellspacing="0" cellpadding="0"> <tr> <a name="lastpost"></a><!--删除左侧用户信息区域--> <td class="pls" rowspan="2" style="display: none;"> <div id="favatar411" class="pls favatar"> <!--左侧用户信息：用户名、认证信息--> <div class="pi"> <div class="authi"><a href="space-uid-1.html" target="_blank" class="xw1">职起网</a> </div> </div> <!--鼠标移头像上去显示的个人信息详情--> <div class="p_pop blk bui card_gender_" id="userinfo411" style="display: none; margin-top: -11px;"> <div class="m z"> <div id="userinfo411_ma"></div> </div> <div class="i y"> <div> <strong><a href="space-uid-1.html" target="_blank" class="xi2">职起网</a></strong> <em>当前离线</em> </div><dl class="cl"> <dt>积分</dt><dd><a href="home.php?mod=space&uid=1&do=profile" target="_blank" class="xi2">4514</a></dd> </dl><div class="imicn"> <a href="home.php?mod=space&uid=1&do=profile" target="_blank" title="查看详细资料"><img src="static/image/common/userinfo.gif" alt="查看详细资料" /></a> </div> <div id="avatarfeed"><span id="threadsortswait"></span></div> </div> </div> <!--左侧用户信息：用户头像--> <div> </div> <!--左侧用户信息：收听、发消息--> <!--左侧用户信息：不能查看个人主页的情况--> <!--左侧用户信息：编辑、禁止、清理等操作--> </div> </td> <td class=""style="width:100%"> <div class="pct" ><style type="text/css">.pcb{margin-right:0}</style> <style type="text/css">.pcb u {position: relative;}.pcb u::before {content: '';position: absolute;bottom: 0;left: 0;width: 100%;height: 50%;background: #f30;opacity: .5;}</style> <!--回帖奖励--> <div class="pcb "> <div class="typeoption"> <table summary="分类信息" cellpadding="0" cellspacing="0" class="cgtl mbm"> <caption>excel</caption> <tbody><tr> <th>excel2016:</th> <td>第三章 工作区 » 录入与编辑数据 </td> </tr> </tbody> </table> </div> <div class="t_fsz content-body content-body-first" > <table cellspacing="0" cellpadding="0"><tr><td class="t_f" id="postmessage_411"> <p style="line-height:20px;text-indent:nullem;text-align:left">文本格式的数字单元格左上角会有一个绿色的三角形，同时默认靠左对其。</p><p style="line-height:20px;text-indent:nullem;text-align:left"><br /> 文本格式和前面两种格式最大的区别就是不管输入什么字符都会以文本的形式显示出来。</p><p style="line-height:20px;text-indent:nullem;text-align:left"><br /> </p><p style="line-height:20px;text-indent:nullem;text-align:left"> <ignore_js_op> <img src="data/attachment/forum/202303/19/174343naktazivilwzppwq.jpg" alt="4.17.1.jpg" title="4.17.1.jpg" /> </ignore_js_op> <br /> </p><br /> </td></tr></table> <div class="entry-tags"> <span class="xc-333 xs-14">标签：</span> <a title="职起网" href="misc.php?mod=tag&id=10" target="_blank"> <!-- <img src="template/xmyc_doc/static/image/topic.png" width="18" height="18"/> --> <i class="iconfont icon-huati"></i> <span>职起网</span></a><a title="excel" href="misc.php?mod=tag&id=5" target="_blank"> <!-- <img src="template/xmyc_doc/static/image/topic.png" width="18" height="18"/> --> <i class="iconfont icon-huati"></i> <span>excel</span></a></div> <!--版权信息--> </div> <div id="comment_411" class="cm"> </div> <div id="post_rate_div_411"></div> </div></div> <!--淘专辑推荐列表--> </td></tr> <!--楼主帖子的相关操作--> <tr> <td class=" plm"> </td> </tr> <tr id="_postposition411"></tr> <!--帖子底部操作、管理--> <tr> <td class="" style="padding:15px 0;overflow:visible;"> <div class="po1 "> <div class="xshare"> </div> <div class="pob cl" style="margin-left:0;border-bottom:0;display:flex;align-items:center;"> <!-- <span id="authorposton411" class="z" style="color: #8a93a0;">发表于 2023-3-19 17:43</span> --> <em> <a href="forum.php?mod=post&action=reply&fid=68&tid=1902&reppost=411&extra=&page=1" onclick="showWindow('reply', this.href)"> 回复</a> </em> <p class="mb0"> <a href="javascript:;" id="mgc_post_411" onmouseover="showMenu(this.id)" class="showmenu">使用道具</a> <a href="javascript:;" onclick="showWindow('miscreport411', 'misc.php?mod=report&rtype=post&rid=411&tid=1902&fid=68', 'get', -1);return false;">举报</a> </p> <ul id="mgc_post_411_menu" class="p_pop mgcmn" style="display: none;"> </ul> <script type="text/javascript" reload="1">checkmgcmn('post_411')</script> </div> </div> </td> </tr> <tr class="ad" style="display: none;"> <td class="pls"> </td> <td class="plc"> </td> </tr> </table> <!-- <div class="bk-rukou"> <a href="forum-68-1.html"> <div class="flex justify-content-between align-items-center"> <div class="left-info"> <i>#</i> <span class="main-title xc-333 xs-14">excel</span> <span class="xc-999 xs-12">进入板块查看更多</span> </div> <img src="template/xmyc_doc/static/image/path-14-copy-15.png"/> </div> </a> </div> --> <div class="entry-navigation" > <nav class="article-nav cl"> <span class="article-nav-prev"><a href="forum.php?mod=redirect&goto=nextoldset&tid=1902" rel="prev"><img src="template/xmyc_doc/static/image/back.png" width="12" height="12"> 上一个主题</a></span> <span class="article-nav-next"><a href="forum.php?mod=redirect&goto=nextnewset&tid=1902" rel="next">下一个主题 <img src="template/xmyc_doc/static/image/forward.png" width="12" height="12"></a></span> </nav> </div> <script type="text/javascript" reload="1"> aimgcount[411] = ['425']; attachimggroup(411); var aimgfid = 0; </script> <!--[diy=diymidad]--><div id="diymidad" class="area"></div><!--[/diy]--> </div><div id="postlistreply" class="pl"><div id="post_new" class="viewthread_table" style="display: none"></div></div> </div> <form method="post" autocomplete="off" name="modactions" id="modactions"> <input type="hidden" name="formhash" value="a8a6b7e7" /> <input type="hidden" name="optgroup" /> <input type="hidden" name="operation" /> <input type="hidden" name="listextra" value="" /> <input type="hidden" name="page" value="1" /> </form> <div class="mt20"></div> <div class="pgs mtm mbm cl" style="display: none;"> <!-- <span class="pgb y"><a href="forum-68-1.html">返回列表</a></span> --> <!-- <a id="newspecialtmp" onmouseover="$('newspecial').id = 'newspecialtmp';this.id = 'newspecial';showMenu({'ctrlid':this.id})" onclick="location.href='forum.php?mod=post&action=newthread&fid=68';return false;" href="javascript:;" title="发新帖"><img src="static/image/common/pn_post.png" alt="发新帖" /></a> --> </div> <!--[diy=diyfastposttop]--><div id="diyfastposttop" class="area"></div><!--[/diy]--> <div class="mtw mbw" style="display: none;"> <h3 class="pbm mbm bbda">相关帖子</h3> <ul class="xl xl2 cl"><li>• <a href="thread-2494-1-1.html" title="篇3：妖股该怎么参与" target="_blank">篇3：妖股该怎么参与</a></li> <li>• <a href="thread-2495-1-1.html" title="篇4：妖股龙回头" target="_blank">篇4：妖股龙回头</a></li> <li>• <a href="thread-2496-1-1.html" title="篇5：妖股炒作的心得" target="_blank">篇5：妖股炒作的心得</a></li> <li>• <a href="thread-2497-1-1.html" title="篇6：缺口理论" target="_blank">篇6：缺口理论</a></li> <li>• <a href="thread-2498-1-1.html" title="篇7：如何提高炒股水平" target="_blank">篇7：如何提高炒股水平</a></li> <li>• <a href="thread-2499-1-1.html" title="篇8：怎么系统性复盘" target="_blank">篇8：怎么系统性复盘</a></li> <li>• <a href="thread-2500-1-1.html" title="篇9：怎么看龙虎榜" target="_blank">篇9：怎么看龙虎榜</a></li> <li>• <a href="thread-2502-1-1.html" title="篇1：A股题材炒作的本质" target="_blank">篇1：A股题材炒作的本质</a></li> <li>• <a href="thread-2503-1-1.html" title="篇2：操盘手法" target="_blank">篇2：操盘手法</a></li> <li>• <a href="thread-2504-1-1.html" title="篇3：连板战法" target="_blank">篇3：连板战法</a></li> </ul> </div> </div> <div class="contnt-right y"> </div> </div> </div> <div id="right"> <div id="tool" style="z-index: 0; position: fixed; top:100px; right: 18px; width: 200px;"> <div class="catalog" > <div class="full-list" > <ul> </ul> </div> <i class="dot-dot"></i> </div> <a href="javascript:void(0)" id="toTop"></a> </div> </div> </div> <!--[diy=diyhotessay]--><div id="diyhotessay" class="area"></div><!--[/diy]--> <div class="wp mtn "> <!--[diy=diy3]--><div id="diy3" class="area"></div><!--[/diy]--> </div> <script type="text/javascript"> function succeedhandle_followmod(url, msg, values) { var fObj = $('followmod_'+values['fuid']); if(values['type'] == 'add') { fObj.innerHTML = '不收听'; fObj.href = 'home.php?mod=spacecp&ac=follow&op=del&fuid='+values['fuid']; } else if(values['type'] == 'del') { fObj.innerHTML = '收听TA'; fObj.href = 'home.php?mod=spacecp&ac=follow&op=add&hash=a8a6b7e7&fuid='+values['fuid']; } } fixed_avatar([411], 1); </script> <link rel="stylesheet" href="template/xmyc_doc/static/js/jquery-ui.min.css" /> <script src="template/xmyc_doc/static/js/jquery-ui.min.js" type="text/javascript" type="text/javascript"></script> <script src="template/xmyc_doc/static/js/stopExecutionOnTimeout.js?t=1" type="text/javascript"></script> <script src="template/xmyc_doc/static/js/jquery.velocity.min.js?t=1" type="text/javascript"></script> <script src="template/xmyc_doc/static/js/tree.js?t=1" type="text/javascript"></script> <script type="text/javascript"> jQuery(function(){ jQuery("#left").resizable({ handles:'e', maxWidth:500, minWidth:230, resize:function(event,ui){ jQuery('#middle').width(jQuery('#content').width()-ui.size.width-jQuery('#right').width()-1); jQuery('#middle').css("margin-left",ui.size.width); } }); // jQuery('#middle').resizable({ // handles:'e', // maxWidth:(jQuery('#content').width()-jQuery('#left').width())*0.7, // minWidth:(jQuery('#content').width()-jQuery('#left').width())*0.3, // resize:function(event,ui){ // jQuery('#right').width(jQuery('#content').width()-ui.size.width-jQuery('#left').width()); // } // }) //当窗口大小改变时，也要等比例缩放各个div的宽度 jQuery(window).resize(function(){ //计算缩放比例，bill=新的容器的宽度 除以 旧的容器的宽度 //let bili=(jQuery('#content').width()-260)/(jQuery('#left').width()+jQuery('#middle').width()); // jQuery('#left').width(jQuery('#left').width()*bili); // jQuery('#middle').width(jQuery('#middle').width()*bili); //jQuery('#right').width(jQuery('#right').width()*bili); jQuery('#middle').width(jQuery('#content').width()-jQuery('#left').width()-jQuery('#right').width()-1); jQuery('#middle').css("margin-left",jQuery('#left').width()); }) jQuery('body').bind('resize',function(){return false;}) }); </script> <script src="template/xmyc_doc/static/js/jquery-ias.min.js" type="text/javascript" type="text/javascript"></script> <script type="text/javascript"> jQuery(document).ready(function () { //initTypeTree(); initTree(); // var titleNumber=0; // jQuery(".content-body-first").children().each(function(index,element){ // var tagName=jQuery(this).tagName; // var size=jQuery(this).attr("size"); // console.log(size); // if(size!=""){console.log(jQuery(this));} // // if(tagName.substr(0,1).toUpperCase()=="H"){ // // if(tagName=='H2'){ // // var contentH=jQuery(this).text(); // // var markid="mark-"+tagName+"-"+titleNumber; // // console.log(markid); // // jQuery(".menu").append("<a class='style' href='#"+markid+"'>"+contentH+"</a>"); // // }else if(tagName=="H3"){ // // }else if(tagName=="H4"){ // // } // // titleNumber++; // // } // }) var _index=0; var _maxlevel=0; jQuery('.content-body-first').find("font").each(function(){ var _size=jQuery(this).attr("size"); if(_size>2 && jQuery(this).text().trim()!=""){//console.log(jQuery(this).text().trim()); jQuery(this).attr("id","size_"+_index); if(_size>_maxlevel) _maxlevel=_size; jQuery(".full-list ul").append("<li class='dot' data-index='"+_index+"' data-level='"+_size+"'><a>"+jQuery(this).text()+"</a></li>"); _index++; // console.log(jQuery(this).html().indexOf("size")); // console.log(jQuery(this).html()); } }); jQuery(".full-list li").each(function(){ var _level=jQuery(this).attr("data-level"); jQuery(this).addClass("dot"+(_maxlevel-_level)); }) jQuery('.full-list li').eq(0).addClass("current"); jQuery('.full-list li').click(function() { jQuery(this).addClass("current").siblings().removeClass("current"); sessionStorage.setItem('scroll', 'scroll'); jQuery('html,body').animate({scrollTop: jQuery("#size_"+jQuery(this).attr("data-index")).offset().top -80}, 300); setTimeout(function(){ sessionStorage.removeItem('scroll'); },800); }); jQuery(window).scroll(function(){ var len=jQuery('.full-list li').length; for(var i=0;i<len;i++){ var idname=jQuery('.full-list li').eq(i).attr("data-index"); if(jQuery(window).scrollTop()+90>=jQuery('#size_'+idname).offset().top){ jQuery('li[data-index="'+idname+'"]').addClass("current").siblings().removeClass("current"); } } }) }); function initTree(){ var _curkey='4-2-t1902'; if(_curkey!=""){ var arr = _curkey.split("-"); var _key="key_"+arr[0]; for(var i=0;i<arr.length-1;i++){ jQuery("#"+_key).addClass("mtree-open").removeClass("mtree-closed"); jQuery("#"+_key).find("ul").eq(0).show().css("height","auto"); _key=_key+"-"+arr[i+1]; } jQuery('.htmleaf-content').animate({scrollTop: jQuery("#key_"+_curkey).offset().top},300); } } function initTypeTree(){ var _curkey=''; if(_curkey == 0 || _curkey == '') return false; jQuery("#key_threadtypes").addClass("mtree-open").removeClass("mtree-closed"); jQuery("#key_threadtypes").find("ul").eq(0).show().css("height","auto"); jQuery('.layui-layer-content').animate({scrollTop: jQuery("#key_threadtypes"+_curkey).offset().top},300); } </script></div> <script type="text/javascript"> var mw_brush = eval({"applescript":["AppleScript","true"],"actionscript3":["Actionscript3","true"],"bash":["Bash shell","true"],"coldfusion":["ColdFusion","true"],"cpp":["C++","true"],"csharp":["C#","true"],"delphi":["Delphi","true"],"diff":["Diff","true"],"erlang":["Erlang","true"],"groovy":["Groovy","true"],"javafx":["JavaFX","true"],"javascript":["JavaScript","true"],"pascal":["Pascal","true"],"patch":["Patch","true"],"perl":["Perl","true"],"powershell":["PowerShell","true"],"python":["Python","true"],"ruby":["Ruby","true"],"rails":["Ruby on Rails","true"],"sass":["Sass","true"],"scala":["Scala","true"],"scss":["Scss","true"],"shell":["Shell","true"],"vbnet":["Visual Basic .NET","true"],"xhtml":["XHTML","true"],"xml":["XML","true"],"xslt":["XSLT","true"],"objc":["Objective-C","true"],"asm":["Asm","true"],"aauto":["AAuto","true"],"golang":["Golang","true"],"lua":["Lua","true"],"typescript":["TypeScript","true"],"haxe":["Haxe","true"],"il":["IL","true"],"vb":["Visual Basic","true"],"sql":["SQL","true"],"java":["Java","true"],"css":["CSS","true"],"c":["C","true"],"php":["PHP","true"],"html":["HTML","true"],"text":["Plain Text","true"]}); var mw_gutter = 0; var mw_lang_codebox = { 'select_lang': 'ҪĴ<br>ѡԣ', 'show_gutter': 'ʾкţ', 'your_code': 'Ĵ룺', 'close': 'ر', 'submit': 'ύ', 'cancle': 'ȡ' }; </script> <script type="text/javascript" src="http://www.zhiqimba.com/source/plugin/mw_syntaxhighlighter/static/js/mw_syntaxhighlighter.js?yZi"></script><script type="text/javascript" reload="1">mw_syntaxhighlighter("fastpost");</script><script type="text/x-mathjax-config"> MathJax.Hub.Config({ tex2jax: {inlineMath: [["$","$"], ['\\(','\\)']]}, skipTags: ['script', 'noscript', 'style', 'textarea', 'pre','code','a'], showProcessingMessages: false, messageStyle: "none", TeX: { equationNumbers: {autoNumber: "AMS"} }, }); </script><script type="text/javascript" src="//cdn.bootcss.com/mathjax/2.7.0/MathJax.js?config=TeX-AMS-MML_HTMLorMML&noContrib"></script> <div id="ft"> <!--这是底部内容--> <div class="footer" > <div class="footer-b"> <div class="inner"> <div class="copyright"> <p><a href="/forum.php?mod=viewthread&tid=1789&extra=page%3D1" >一起创作</a><span class="pipe">|</span> <a href="#" >站长QQ:2674615</a><span class="pipe">|</span> <script> var _hmt = _hmt || []; (function() { var hm = document.createElement("script"); hm.src = "https://hm.baidu.com/hm.js?fe20a7cd150e593a05a74b380cf8e7cc"; var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(hm, s); })(); </script> <br> <!-- <a style="vertical-align: middle;" href="//wpa.qq.com/msgrd?v=3&uin=26639903&site=职起网&menu=yes&from=discuz" target="_blank" title="QQ"><img src="static/image/common/site_qq.jpg" alt="QQ" /></a><span class="pipe">|</span> --> Powered by <strong><a href="https://www.discuz.vip" target="_blank">Discuz! X3.4</a></strong> Copyright © 2001-2020, Tencent Cloud. ( <a href="http://beian.miit.gov.cn/" target="_blank">闽ICP备17031337号-15</a> ) 商业源码建议获取授权，如侵犯您的权益，请联系客服处理 </i> </p> </div> </div> </div> </div> <!-- <div class="waveHorizontals mobile-hide"> <div id="waveHorizontal1" class="waveHorizontal"></div> <div id="waveHorizontal2" class="waveHorizontal"></div> <div id="waveHorizontal3" class="waveHorizontal"></div> </div> --></div> <script src="home.php?mod=misc&ac=sendmail&rand=1765993408" type="text/javascript"></script> <!-- common/rightfix_common --><div id="tophovertree" title="返回顶部"><i class="fa fa-chevron-up"></i></div> <!-- <div id="tophovertree" title="返回顶部"></div> --> <script src="template/xmyc_doc/static/js/topHovertree.js" type="text/javascript"></script> <script> jQuery(function () { initTopHoverTree("tophovertree",100,30,15); jQuery("#tophovertree").bind("click",function(){ jQuery("#hd").slideDown('fast'); }); }) </script> </body> </html>