codecamp

EXCEL 快速筛选

中国教程网zhangditony翻译,转载请保留此信息 .
 

To quickly filter a List, add the AutoFilter and Show All icons to the Standard toolbar
为实现快速筛选,增添“自动筛选”和“全部显示”按钮到常用工具栏。
1. Place the mouse arrow on one of the toolbars, right-click, and select Customize from the shortcut menu.
2. In the Customize dialog box, select the Commands tab.
3. From Categories, select Data, and from the Commands box, drag the AutoFilter and Show All icons to the Standard toolbar.
4. Click Close

  

20070717_e8c6b22b3ca58a3c614dock6ylvwfmgu[1].gif

EXCEL --√、× 等常用符号的输入
EXCEL 巧妙替换单元格
温馨提示
下载编程狮App,免费阅读超1000+编程语言教程
取消
确定
目录

关闭

MIP.setData({ 'pageTheme' : getCookie('pageTheme') || {'day':true, 'night':false}, 'pageFontSize' : getCookie('pageFontSize') || 20 }); MIP.watch('pageTheme', function(newValue){ setCookie('pageTheme', JSON.stringify(newValue)) }); MIP.watch('pageFontSize', function(newValue){ setCookie('pageFontSize', newValue) }); function setCookie(name, value){ var days = 1; var exp = new Date(); exp.setTime(exp.getTime() + days*24*60*60*1000); document.cookie = name + '=' + value + ';expires=' + exp.toUTCString(); } function getCookie(name){ var reg = new RegExp('(^| )' + name + '=([^;]*)(;|$)'); return document.cookie.match(reg) ? JSON.parse(document.cookie.match(reg)[2]) : null; }