</noscript> <script> function stop(){ return false; } document.oncontextmenu=stop; </script><link href="http://www.zhiqimba.com/thread-1903-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 = 'aHR0cDovL3d3dy56aGlxaW1iYS5jb20vZm9ydW0ucGhwP21vZD12aWV3dGhyZWFkJnRpZD0xOTAz', 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('1903');</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" ><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" 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-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">398</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-1903-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=1903&formhash=cec05673" 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-1903-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="">398 人阅读</span> <span class="pipe">|</span> <span class="">0 人回复</span> </p> </div> <!--回帖奖励规则--> </div> <div id="post_412" class="post-item" ><table id="pid412" class="plhin" summary="pid412" 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="favatar412" 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="userinfo412" style="display: none; margin-top: -11px;"> <div class="m z"> <div id="userinfo412_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_412"> <p style="line-height:20px;text-indent:nullem;text-align:left">Excel里面的数字格式如果满足不了我们的需要，此时就可以创建新的自定义格式。</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"><img id="aimg_dB6I5" onclick="zoom(this, this.src, 0, 0, 0)" class="zoom" src="https://lanmaoapp-1251376109.cos.ap-nanjing.myqcloud.com/0000/zhiqiwang/gif/4.18.1.gif" onmouseover="img_onmouseoverfunc(this)" lazyloadthumb="1" border="0" alt="" /><br /> </p><p style="line-height:20px;text-indent:nullem;text-align:left">对数值进行自定义格式<br /> <br /> 单元格里数字添加完单位字符后会自动变为文本格式，这是无法进行算术计算的。此时需要自定义单元格的格式让依然是数值的形式。单元格对其方式就会默认人靠右对齐。<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"><img id="aimg_af1fk" onclick="zoom(this, this.src, 0, 0, 0)" class="zoom" src="https://lanmaoapp-1251376109.cos.ap-nanjing.myqcloud.com/0000/zhiqiwang/gif/4.18.2.gif" onmouseover="img_onmouseoverfunc(this)" lazyloadthumb="1" border="0" alt="" /><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_412" class="cm"> </div> <div id="post_rate_div_412"></div> </div></div> <!--淘专辑推荐列表--> </td></tr> <!--楼主帖子的相关操作--> <tr> <td class=" plm"> </td> </tr> <tr id="_postposition412"></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="authorposton412" class="z" style="color: #8a93a0;">发表于 2023-3-19 17:46</span> --> <em> <a href="forum.php?mod=post&action=reply&fid=68&tid=1903&reppost=412&extra=&page=1" onclick="showWindow('reply', this.href)"> 回复</a> </em> <p class="mb0"> <a href="javascript:;" id="mgc_post_412" onmouseover="showMenu(this.id)" class="showmenu">使用道具</a> <a href="javascript:;" onclick="showWindow('miscreport412', 'misc.php?mod=report&rtype=post&rid=412&tid=1903&fid=68', 'get', -1);return false;">举报</a> </p> <ul id="mgc_post_412_menu" class="p_pop mgcmn" style="display: none;"> </ul> <script type="text/javascript" reload="1">checkmgcmn('post_412')</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=1903" 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=1903" 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[412] = ['dB6I5','af1fk']; attachimggroup(412); 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="cec05673" /> <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=cec05673&fuid='+values['fuid']; } } fixed_avatar([412], 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-t1903'; 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=1765993308" 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>