本教程适用版本：WPS 365 点击免费使用
我们在使用Excel表格办公时，如果遇到需要批量填充日期的时，大多数人都会通过拖动填充，但是其中会存在一个问题，这种方法就包括非工作日（周六、周日），非工作日基本是不进行调整的，该如何操作呢？今天小编就来教大家如何在演示文稿当中怎样添加幻灯片编号，一起来学习一下吧。
首先，在某个单元格在输入日期：例如：2020/1/10进行向下拖动填充，但是我们会发现所有的日期都被填充，非工作日也包含在里面，如图所示：
>>免费升级到企业版，赠超大存储空间
对于这种情况我们采用表格右下角的【自动填充选项】进行填充，那就只保留住工作日（周一——周五） 如图所示：
>>免费升级到企业版，赠超大存储空间
点击【自动填充选项】，弹出选项卡如何选择【以工作日填充】，如图所示：
>>免费升级到企业版，赠超大存储空间
点击以后在进行观察，现在表格中只有工作日
>>免费升级到企业版，赠超大存储空间
那么，在使用Excel表格办公时，自动填充工作日的方法是不是非常简单呢，你学会了吗？
Keyword: wps官网
SPOTLIGHTED PODCAST ALERT (YOUR ARTICLE BEGINS A FEW INCHES DOWN)… Becky Lynch vs. Bianca Belair vs. Sasha Banks for the WWE Smackdown Women’s Championship has been announced for WWE’s Crown Jewel event in Saudi Arabia. BREAKING: @BeckyLynchWWE will defend her #SmackDown #WomensTitle against @BiancaBelairWWE & @SashaBanksWWE at #WWECrownJewel! https://t.co/6EA4gqwb0k — WWE (@WWE) October 1, 2021…
SPOTLIGHTED PODCAST ALERT (YOUR ARTICLE BEGINS A FEW INCHES DOWN)… AEW started the new year with a bang on Wednesday night at New Year’s Smash. After connecting with a One Winged Angel and pinning Rey Fenix to retain the AEW World Championship in the main event of the show, Kenny Omega reunited with his old…
SARASOTA, FL — The Sarasota Children’s Museum, a nonprofit organization founded last year, has received funding from the Charles & Margery Barancik Foundation that allows it to purchase a trailer to launch a mobile museum on wheels. The 24-foot, fully solar-powered trailer will allow the museum to more easily attend community events as it ramps…
SPOTLIGHTED PODCAST ALERT (YOUR ARTICLE BEGINS A FEW INCHES DOWN)… The Sept. 3 WWE Smackdown drew a 1.54 rating, up from last week’s 1.50, and right in line with the ten-week rolling average of 1.50. Total viewership was 2.130 million, below ESPN’s U.S. Open Tennis and two programs on Fox News, but it topped all…
Once again, VAC paired four of its amplifiers with Von Schweikert loudspeakers in a huge room sponsored by The Audio Company. Distinguished by sophisticated lighting design and fabulous sound, this system, which can fill rooms far larger than the Dutch & Dutch 8cs that so impressed me at PAF, vied with them for my personal…
Click:Peptide API Powder The Greenland ice sheet, one of the coldest and most remote regions of the world that serves a pivotal role in the Earth’s climate, is now clearly feeling significant effects of climate change. Researchers found that central and northern areas of the sheet have recently seen the hottest temperatures in a millennium. …