Home » 文章 » 电脑技术 » Excel » Excel问题解答(2011-11)

Excel问题解答(2011-11)

1.Excel如何实现双击后该单元格的数值自动加1.

解答。ActiveCell.Value = ActiveCell.Value + 1
代码加到doubleclick事件下。

p13

                                                                                                                                                         

 

 

2.Excel中,如何在1700,1750,1800,1850,1900,随机取出一个。即在指定几个数值中随机抽取一个。

=LOOKUP(ROUND(RAND()*4,0),{0,1,2,3,4},{1700,1750,1800,1850,1900})

 

                                                                                                                                                        

 

 

3.修改代码。

用 For Each C In Range(“A1:A400”)
If Len(C) = 15 Then
MsgBox C.address
我得到了A组400个数中的为15位的数字的地址。但是我想在这些15位的地址的右列输入固定的值。
我怎样把这个15位的地址 C.address  变成右列的值?
比如
123456789012345     10
123
5455
111232323123213     9
怎样得到10和9的地址
根据C.address  怎么得到  希望得到解答

解答:

Sub aa()
For Each c In Range(“a1:a12”)
If Len(c) = 15 Then
MsgBox Cells(c.Row, c.Column + 1).Address
End If
Next
End Sub

 

                                                                                                                                                         

 

 

4.在EXCEL表格中怎样打出平方米啊。

解答:alt+0178,按完后就会插入平方了。

 

                                                                                                                                                         

 

 

5.EXCEL在给出的劳动合同时间基础上,通过公式作出劳动合同年限?如:A1=2011.09.01-2013.01.31(劳动合同起止时间),B1=?(劳动合同年限精确到月),B1=1.5年。请问这样怎么让公式显示1.5年啊,公式该怎么编写。

解答:B1=ROUNDUP(((TEXT(MID(A1,12,4)&”-“&MID(A1,17,2)&”-“&MID(A1,20,2),”yyyy-mm-dd”))-(TEXT(LEFT(A1,4)&”-“&MID(A1,6,2)&”-“&MID(A1,9,2),”yyyy-mm-dd”)))/365,1)

p14

6.在EXCEL特别是Excel 2007中,在不同工作表间复制粘贴,内容变成空白。选择性粘贴,变成选择方式列表。

解答:

1、卸载原来的Office程序,特别是绿色版或多个版本。下载原版的安装版进行安装。问题基本能解决。

2、不能解决的话,通常是Excel文件中毒了,把隐藏的工作表显示出来,找到不是自己使用的工作表,删除掉。在VBA里删除不使用的代码。

01

                                                                                                                                                         

 

微信 OR 支付宝 扫描二维码
为博主 打个赏
pay_weixinpay_zhifubao
金额随意 快来“打”我呀~

4 comments

  1. It is not my first time to pay a visit this web site, i am visiting this site dailly and take fastidious facts from
    here everyday.

  2. Hey! Someone in my Facebook group shared this website with us so I came
    to check it out. I’m definitely loving the information. I’m
    book-marking and will be tweeting this to my followers!

    Superb blog and wonderful style and design.

  3. I am in fact pleased to read this web site posts which
    consists of plenty of useful information, thanks for providing these statistics.

  4. Nice post. I used to be checking constantly this blog and I’m inspired!
    Extremely helpful info specially the closing part 🙂 I deal with
    such info a lot. I used to be looking for this particular information for a very long time.
    Thanks and best of luck.

Leave a Reply

Your email address will not be published. Required fields are marked *

*