excel表格百分比怎么锁定

1.excel如何设置固定比率函数

给你一段代码，你在Sheet1下面的页签上，右键，查看代码，贴上就能干活了。

Private Sub Worksheet_Change(ByVal Target As Range)

Application.EnableEvents = False

If Target.Row = 1 And Target.Column = 1 Then Range("a2") = Range("a1") / Range("a3")

If Target.Row = 2 And Target.Column = 1 Then Range("a1") = Range("a2") * Range("a3")

Application.EnableEvents = True

End Sub

2.excel如何设置固定比率函数

给你一段代码，你在Sheet1下面的页签上，右键，查看代码，贴上就能干活了。

Private Sub Worksheet_Change(ByVal Target As Range)Application.EnableEvents = FalseIf Target.Row = 1 And Target.Column = 1 Then Range("a2") = Range("a1") / Range("a3")If Target.Row = 2 And Target.Column = 1 Then Range("a1") = Range("a2") * Range("a3")Application.EnableEvents = TrueEnd Sub。