excel里怎样从9-15,16-22excel按照时间排序这个规律填充呢

来源：蜘蛛抓取(WebSpider) 时间：2018-03-16 00:01 标签： excel按照字母排序
Oracle Java Archive | Oracle Technology Network | Oracle
Oracle Java Archive
The Oracle Java Archive offers self-service download access to some of our historical Java releases.
WARNING: These older versions of the JRE and JDK are provided to help developers debug issues in older systems. They are not updated with the latest security patches and are not recommended for use in production.
For production use Oracle recommends downloading the latest JDK and JRE versions and allowing auto-update.
Only developers and Enterprise administrators should download these releases.
Downloading these releases requires an oracle.com account. If you don't have an oracle.com account you can use the links on the top of this page to learn more about it and register for one for free.
For current Java releases, please consult the .
Current update releases for JDK 6 and JDK 7 are available for support customers.& If you already have a support contract see & For more details, please visit the
For more information on the transition of products from the legacy Sun download system to the Oracle Technology Network, visit the
announcement.
Java 3D, Java Access Bridge, Java Accessibility, Java Advanced Imaging, Java Internationalization and Localization Toolkit, Java Look and Feel, Java Media Framework (JMF), Java Web Start (JAWS), JIMI SDK
Java Authentication and Authorization Service (JAAS), JavaBeans, Java Management Extension (JMX), Java Naming and Directory Interface, RMI over IIOP, Java Cryptography Extension (JCE), Java Secure Socket Extension
Java DB Connectivity (JDBC), Java Data Objects (JDO)
Sample Code for GSSAPI/Kerberos, Java Communications API &&&
Java Application Platform SDK, Java EE SDK, Samples
GlassFish, Sun Java System Application Server, IDE Toolkit, Java Application Verification Kit (AVK) for Enterprise, Project Metro Web Services &
First Cup, Javadocs, Tutorials, Demos, Blueprints
J2EE Application Deployment, J2EE Client Provisioning, J2EE Connector Architecture, J2EE Deployment, J2EE Management, Java API for XML, Java Messaging Service (JMS), Java Servlet, Java Transaction Service (JTS), JavaMail, JavaServer Faces, Struts and Core J2EE
DVB, J2ME Connected Limited Device Configuration (CLDC), J2ME Mobile Information Device Profile (MIDP), Java Card, Mobile Media API Emulator (MMAPI), Java ME SDK, Java TV, OCAP Sun Specification, Project Lightweight UI Toolkit, Security and Trust Services API for J2ME (SATSA), Wireless Toolkit, Documentation and Exclusion List Installer
Java Resources
About Oracle
Top Actions
Key Topics
Integrated Cloud Applications & Platform ServicesOffice 2016 for mac V16.10中文版(官方地址未激活)如何设置excel自动填充的间距_百度知道
如何设置excel自动填充的间距
210，一列以间隔50，请问诸位有什么办法能实现呢,180..,120..一列以间隔30排列，就是30..，我必须采用自动下拉填充,60,90.因为数字有些多,150，就是50,100,150,200,250.我有两列数字
我有更好的答案
方法一：1、先在前两个单元格中输入50、100；2、选中这两个单元格，将鼠标指针放在其右下角的黑色标记处，当鼠标指针变为黑色十字形后，拖动鼠标进入自动填充；3、填充后的效果如图所示。方法二：1、先在第一个单元格中输入50；2、选中该单元格；3、单击经典菜单----编辑----填充----系列命令；4、弹出序列对话框，进行如图所示的设置，单击确定按钮即可。
采纳率：93%
来自团队：
baidu.com/zhidao/wh%3D600%2C800/sign=f9679ece533db65cb9ec3/72f082025aafa40f1034f78f0197b.jpg" esrc="http://b.hiphotos.hiphotos.baidu.com/zhidao/pic/item/72f082025aafa40f1034f78f0197b在A1输入50 回车选中A1 编辑 填充 序列 按下图设置后 单击 确定30那列也可通过序列填充得到.baidu://b
本回答被提问者采纳
EXCEL2007可以按一定的间距自动填充，比如要间距10自动填充，例如A1输入10,
A2输入20，用鼠标选中A1，A2，把鼠标放在右下角，等待鼠标变成实心十字的时候，向下拖动，就可以实现自动填充间距了。
=ROW(A1)*50，其中50可以改成30之类的
第一行输入50，第二行输入100，选中那两个单元格，下拉
其他2条回答
为您推荐：
其他类似问题
您可能关注的内容
excel的相关知识
换一换
回答问题，赢新手礼包
个人、企业类
违法有害信息,请在下方选择后提交
色情、暴力
我们会通过消息、邮箱等方式尽快将举报结果通知您。扫二维码下载作业帮
拍照搜题，秒出答案，一键查看所有搜题记录
下载作业帮安装包
扫二维码下载作业帮
拍照搜题，秒出答案，一键查看所有搜题记录
在excel中如何把没规律的1到49的数字转换成三种文字红波,蓝波,绿波?红波的数 01,02,07,08,12,13,18,19,23,24,29,30,34,35,40,45,46 蓝波的数 03,04,09,10,14,15,20,25,26,31,36,37,41,42,47,48 绿波的数 05,06,11,16,17,21,22,27,28,32,33,38,39,43,44,49A列1-49的数字,如何在B列对应的位置自动生成红波或蓝波或绿波?
作业帮用户
扫二维码下载作业帮
拍照搜题，秒出答案，一键查看所有搜题记录
A1=IF(OR(A1={1,2,7,8,12,13,18,19,23,24,29,30,34,35,40,45,46}),"红",IF(OR(A1={3,4,9,10,14,15,20,25,26,31,36,37,41,42,47,48}),"蓝","绿"))下拉
为您推荐：
其他类似问题
扫描下载二维码

我要回帖

更多关于 excel按照字母排序 的文章

 

随机推荐