<acronym id="6eewe"><small id="6eewe"></small></acronym><rt id="6eewe"></rt>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<samp id="6eewe"><noscript id="6eewe"></noscript></samp>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<tr id="6eewe"></tr>
<menu id="6eewe"><wbr id="6eewe"></wbr></menu>
<menu id="6eewe"><wbr id="6eewe"></wbr></menu>
<acronym id="6eewe"><small id="6eewe"></small></acronym><samp id="6eewe"></samp>
<object id="6eewe"><center id="6eewe"></center></object>
<rt id="6eewe"><optgroup id="6eewe"></optgroup></rt>
<acronym id="6eewe"><optgroup id="6eewe"></optgroup></acronym>
<rt id="6eewe"><optgroup id="6eewe"></optgroup></rt>
<tr id="6eewe"></tr>
<acronym id="6eewe"><small id="6eewe"></small></acronym><acronym id="6eewe"><optgroup id="6eewe"></optgroup></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym><samp id="6eewe"><noscript id="6eewe"></noscript></samp>
<sup id="6eewe"><small id="6eewe"></small></sup>
<tr id="6eewe"></tr>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<samp id="6eewe"></samp>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<samp id="6eewe"><noscript id="6eewe"></noscript></samp>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<menu id="6eewe"><noscript id="6eewe"></noscript></menu>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<tr id="6eewe"></tr>
<acronym id="6eewe"><optgroup id="6eewe"></optgroup></acronym> <rt id="6eewe"></rt>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<rt id="6eewe"><optgroup id="6eewe"></optgroup></rt>
<acronym id="6eewe"><small id="6eewe"></small></acronym><tt id="6eewe"></tt>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<tt id="6eewe"></tt>
<tr id="6eewe"></tr>
<rt id="6eewe"><optgroup id="6eewe"></optgroup></rt>
<tt id="6eewe"></tt>
<acronym id="6eewe"><small id="6eewe"></small></acronym><acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
第一PPT - www.bhiw.top - PPT背景圖片,PPT模板免費下載!
第一PPT > Office教程 > Excel教程 > Excel技巧 > 如何在Excel中設置單元格只能輸入正值?

如何在Excel中設置單元格只能輸入正值?

時間:2016-06-22 17:25來源:未知 作者:admin 點擊:

Excel技巧:如何在Excel中設置單元格只能輸入正值?

今天培訓的客戶咨詢,如果能讓輸入的單元格只能輸入正值?正值就是大于0的數據嗎?是只能輸入數值?經過確認后,希望能限制單元格只能輸入數值,而且是正數。Excel果然是強大的,這種問題分分鐘搞定。與大家分享一下。

場景:適合公司人事、行政、財務、銷售等進行專業統計的辦公人士。

問題:如何設置單元格只能輸入正值?

解答:利用Excel的數據驗證(數據有效性)功能搞定。

具體操作如下:首先選中下圖中“數量”字段下面的區域,點擊“數據-數據驗證”按鈕。(下圖3處)

如何在Excel中設置單元格只能輸入正值?

在新彈的“數據驗證”窗口中,設置驗證條件,允許“小數”,數據“大于”,最小值為“0”(下圖4處)
如何在Excel中設置單元格只能輸入正值?

確定后,趕緊來測試一下效果。1.輸入漢字 2.不允許錄入,很好。
如何在Excel中設置單元格只能輸入正值?

2.輸入負數試試,不允許輸入,很好。
如何在Excel中設置單元格只能輸入正值?

總結:“Excel2013的數據驗證”在Excel2010中叫做“數據有效性”,數據有效性是Excel定制工作模板中非常重要一種技巧。大家有興趣可以深入研究,也會后續技巧中發布。

該技巧Excel007版本及以上有效。

轉載務必注明出處!本文地址:http://www.bhiw.top/article/492.html
更多

最新內容

平码二中二多少钱
<acronym id="6eewe"><small id="6eewe"></small></acronym><rt id="6eewe"></rt>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<samp id="6eewe"><noscript id="6eewe"></noscript></samp>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<tr id="6eewe"></tr>
<menu id="6eewe"><wbr id="6eewe"></wbr></menu>
<menu id="6eewe"><wbr id="6eewe"></wbr></menu>
<acronym id="6eewe"><small id="6eewe"></small></acronym><samp id="6eewe"></samp>
<object id="6eewe"><center id="6eewe"></center></object>
<rt id="6eewe"><optgroup id="6eewe"></optgroup></rt>
<acronym id="6eewe"><optgroup id="6eewe"></optgroup></acronym>
<rt id="6eewe"><optgroup id="6eewe"></optgroup></rt>
<tr id="6eewe"></tr>
<acronym id="6eewe"><small id="6eewe"></small></acronym><acronym id="6eewe"><optgroup id="6eewe"></optgroup></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym><samp id="6eewe"><noscript id="6eewe"></noscript></samp>
<sup id="6eewe"><small id="6eewe"></small></sup>
<tr id="6eewe"></tr>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<samp id="6eewe"></samp>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<samp id="6eewe"><noscript id="6eewe"></noscript></samp>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<menu id="6eewe"><noscript id="6eewe"></noscript></menu>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<tr id="6eewe"></tr>
<acronym id="6eewe"><optgroup id="6eewe"></optgroup></acronym> <rt id="6eewe"></rt>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<rt id="6eewe"><optgroup id="6eewe"></optgroup></rt>
<acronym id="6eewe"><small id="6eewe"></small></acronym><tt id="6eewe"></tt>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<tt id="6eewe"></tt>
<tr id="6eewe"></tr>
<rt id="6eewe"><optgroup id="6eewe"></optgroup></rt>
<tt id="6eewe"></tt>
<acronym id="6eewe"><small id="6eewe"></small></acronym><acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym><rt id="6eewe"></rt>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<samp id="6eewe"><noscript id="6eewe"></noscript></samp>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<tr id="6eewe"></tr>
<menu id="6eewe"><wbr id="6eewe"></wbr></menu>
<menu id="6eewe"><wbr id="6eewe"></wbr></menu>
<acronym id="6eewe"><small id="6eewe"></small></acronym><samp id="6eewe"></samp>
<object id="6eewe"><center id="6eewe"></center></object>
<rt id="6eewe"><optgroup id="6eewe"></optgroup></rt>
<acronym id="6eewe"><optgroup id="6eewe"></optgroup></acronym>
<rt id="6eewe"><optgroup id="6eewe"></optgroup></rt>
<tr id="6eewe"></tr>
<acronym id="6eewe"><small id="6eewe"></small></acronym><acronym id="6eewe"><optgroup id="6eewe"></optgroup></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym><samp id="6eewe"><noscript id="6eewe"></noscript></samp>
<sup id="6eewe"><small id="6eewe"></small></sup>
<tr id="6eewe"></tr>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<samp id="6eewe"></samp>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<samp id="6eewe"><noscript id="6eewe"></noscript></samp>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<menu id="6eewe"><noscript id="6eewe"></noscript></menu>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<tr id="6eewe"></tr>
<acronym id="6eewe"><optgroup id="6eewe"></optgroup></acronym> <rt id="6eewe"></rt>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<rt id="6eewe"><optgroup id="6eewe"></optgroup></rt>
<acronym id="6eewe"><small id="6eewe"></small></acronym><tt id="6eewe"></tt>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
<tt id="6eewe"></tt>
<tr id="6eewe"></tr>
<rt id="6eewe"><optgroup id="6eewe"></optgroup></rt>
<tt id="6eewe"></tt>
<acronym id="6eewe"><small id="6eewe"></small></acronym><acronym id="6eewe"><small id="6eewe"></small></acronym>
<acronym id="6eewe"><small id="6eewe"></small></acronym>
酷彩吧下载 幸运飞艇计划软件人工 今日大乐透随机选一注 3d藏机诗藏机图 江西时时组选技巧 北京赛车开奖网 北京福彩快3历史数据 下載曾道正版资料大全 重庆时时彩直播 黑龙江22选5开奖结果查询 江苏快三app软件 特马历史开奖结果记录 大乐透走势图新浪 广东快乐十分走势图和值 陕西欢乐十分开奖结果 赛车挂机倍投方案