我有以下 Excel 电子表格：
A B C D E F G H
1 # Size Age Color =B1 =C1 =D1
2 1 Big
3 2 Small 2983 Yellow
4 3 3459 Red
5 4 Big Yellow
6 5
7 6 Big 2345
我想用数字 (#) 填充 FH 列，这些数字的行在相应的 BD 列中包含一些值。即，我希望最终表格如下所示：
当然，随着表中添加或删除条目，FH 行应该会自动更新。如何在 Excel 中执行此操作？
在我的 Windows 10 电脑上，我尝试打开命令提示符，但无论我如何尝试都没有任何反应。尝试从开始菜单、从实际的 .exe C:\Windows、Win+X 菜单等尝试，但没有任何效果。我也无法运行任何 .bat 文件。Powershell 工作正常，但如果我尝试在 Powershell 中运行 .bat 文件，则不会再发生任何情况。
此外，cmd从 Powershell 打印运行
Microsoft Windows [版本 10.0.19045.3324] (c) Microsoft Corporation。版权所有。
但不会打开命令提示符实例，只是立即终止命令（不会将错误消息打印到 Powershell）。同样，如果我cmd /C echo hi在 Powershell 中运行，则不会打印任何内容，也不会创建命令提示符实例。
我已经尝试了各种磁盘检查解决方案等，例如sfc和chkdsk类似的解决方案，并且我目前正在运行完整的病毒扫描，但是这些解决方案都没有成功。
除了重新安装 Windows 之外，我还能尝试什么来恢复 cmd 功能？
我正在尝试拉到远程服务器上的 git repo（使用 SSH 远程 url）。在我的家用 PC 上，我运行了一个 SSH 代理：
PS user@PC> ssh-add -L
ssh-ed25519 AAAAC3NzaC1lZDIASDE5AAAAIP69b6DHAqQgKVZWNnhbSbhBXG1OH3yePiAHfdyTU+f1 user@PC
当我 ssh 到服务器（ForwardAgent yes在 ssh 配置中使用）时，我仍然看到相同的密钥：
PS user@PC> ssh server
user@server> ssh-add -L
ssh-ed25519 AAAAC3NzaC1lZDIASDE5AAAAIP69b6DHAqQgKVZWNnhbSbhBXG1OH3yePiAHfdyTU+f1 user@PC
但是，连接到 bitbucket 不起作用，即使我已将此公钥上传到我的 bitbucket 配置文件：
user@server> ssh -vvv [email protected]
OpenSSH_8.9p1 Ubuntu-3, OpenSSL 3.0.2 15 Mar 2022
debug1: Reading configuration data /home/mvitek/.ssh/config
debug1: /home/mvitek/.ssh/config line 71: Applying options for *
debug1: Reading configuration data /etc/ssh/ssh_config
debug1: /etc/ssh/ssh_config line 19: include /etc/ssh/ssh_config.d/*.conf matched no files
debug1: /etc/ssh/ssh_config line 21: Applying options for *
debug3: expanded UserKnownHostsFile '~/.ssh/known_hosts' -> '/home/mvitek/.ssh/known_hosts'
debug3: expanded UserKnownHostsFile '~/.ssh/known_hosts2' -> '/home/mvitek/.ssh/known_hosts2'
debug2: resolving "bitbucket.org" port 22
debug3: resolve_host: lookup bitbucket.org:22
debug3: ssh_connect_direct: entering
debug1: Connecting to bitbucket.org [104.192.141.1] port 22.
debug3: set_sock_tos: set socket 3 IP_TOS 0x10
debug1: Connection established.
debug1: identity file /home/mvitek/.ssh/id_rsa type -1
debug1: identity file /home/mvitek/.ssh/id_rsa-cert type -1
debug1: identity file /home/mvitek/.ssh/id_ecdsa type -1
debug1: identity file /home/mvitek/.ssh/id_ecdsa-cert type -1
debug1: identity file /home/mvitek/.ssh/id_ecdsa_sk type -1
debug1: identity file /home/mvitek/.ssh/id_ecdsa_sk-cert type -1
debug1: identity file /home/mvitek/.ssh/id_ed25519 type -1
debug1: identity file /home/mvitek/.ssh/id_ed25519-cert type -1
debug1: identity file /home/mvitek/.ssh/id_ed25519_sk type -1
debug1: identity file /home/mvitek/.ssh/id_ed25519_sk-cert type -1
debug1: identity file /home/mvitek/.ssh/id_xmss type -1
debug1: identity file /home/mvitek/.ssh/id_xmss-cert type -1
debug1: identity file /home/mvitek/.ssh/id_dsa type -1
debug1: identity file /home/mvitek/.ssh/id_dsa-cert type -1
debug1: Local version string SSH-2.0-OpenSSH_8.9p1 Ubuntu-3
debug1: Remote protocol version 2.0, remote software version conker_d2658e6678 d899d51eb8fc
debug1: compat_banner: no match: conker_d2658e6678 d899d51eb8fc
debug2: fd 3 setting O_NONBLOCK
debug1: Authenticating to bitbucket.org:22 as 'git'
debug3: record_hostkey: found key type RSA in file /home/mvitek/.ssh/known_hosts:1
debug3: load_hostkeys_file: loaded 1 keys from bitbucket.org
debug1: load_hostkeys: fopen /home/mvitek/.ssh/known_hosts2: No such file or directory
debug1: load_hostkeys: fopen /etc/ssh/ssh_known_hosts: No such file or directory
debug1: load_hostkeys: fopen /etc/ssh/ssh_known_hosts2: No such file or directory
debug3: order_hostkeyalgs: prefer hostkeyalgs: [email protected],[email protected],rsa-sha2-512,rsa-sha2-256
debug3: send packet: type 20
debug1: SSH2_MSG_KEXINIT sent
debug3: receive packet: type 20
debug1: SSH2_MSG_KEXINIT received
debug2: local client KEXINIT proposal
debug2: KEX algorithms: curve25519-sha256,[email protected],ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,[email protected],diffie-hellman-group-exchange-sha256,diffie-hellman-group16-sha512,diffie-hellman-group18-sha512,diffie-hellman-group14-sha256,ext-info-c
debug2: host key algorithms: [email protected],[email protected],rsa-sha2-512,rsa-sha2-256,[email protected],[email protected],[email protected],[email protected],[email protected],[email protected],ssh-ed25519,ecdsa-sha2-nistp256,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521,[email protected],[email protected]
debug2: ciphers ctos: [email protected],aes128-ctr,aes192-ctr,aes256-ctr,[email protected],[email protected]
debug2: ciphers stoc: [email protected],aes128-ctr,aes192-ctr,aes256-ctr,[email protected],[email protected]
debug2: MACs ctos: [email protected],[email protected],[email protected],[email protected],[email protected],[email protected],[email protected],hmac-sha2-256,hmac-sha2-512,hmac-sha1
debug2: MACs stoc: [email protected],[email protected],[email protected],[email protected],[email protected],[email protected],[email protected],hmac-sha2-256,hmac-sha2-512,hmac-sha1
debug2: compression ctos: none,[email protected],zlib
debug2: compression stoc: none,[email protected],zlib
debug2: languages ctos:
debug2: languages stoc:
debug2: first_kex_follows 0
debug2: reserved 0
debug2: peer server KEXINIT proposal
debug2: KEX algorithms: [email protected],ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group14-sha1,diffie-hellman-group1-sha1,ext-info-s
debug2: host key algorithms: ssh-rsa,rsa-sha2-256,rsa-sha2-512,ssh-dss
debug2: ciphers ctos: aes128-ctr,aes192-ctr,aes256-ctr,[email protected],[email protected]
debug2: ciphers stoc: aes128-ctr,aes192-ctr,aes256-ctr,[email protected],[email protected]
debug2: MACs ctos: [email protected],hmac-sha2-256,hmac-sha1,hmac-sha1-96
debug2: MACs stoc: [email protected],hmac-sha2-256,hmac-sha1,hmac-sha1-96
debug2: compression ctos: none
debug2: compression stoc: none
debug2: languages ctos:
debug2: languages stoc:
debug2: first_kex_follows 0
debug2: reserved 0
debug1: kex: algorithm: [email protected]
debug1: kex: host key algorithm: rsa-sha2-512
debug1: kex: server->client cipher: [email protected] MAC: <implicit> compression: none
debug1: kex: client->server cipher: [email protected] MAC: <implicit> compression: none
debug3: send packet: type 30
debug1: expecting SSH2_MSG_KEX_ECDH_REPLY
debug3: receive packet: type 31
debug1: SSH2_MSG_KEX_ECDH_REPLY received
debug1: Server host key: ssh-rsa SHA256:zzXQOXSRBEiUtuE8AikJYKwbHaxvSc0ojez9YXaGp1A
debug3: record_hostkey: found key type RSA in file /home/mvitek/.ssh/known_hosts:1
debug3: load_hostkeys_file: loaded 1 keys from bitbucket.org
debug1: load_hostkeys: fopen /home/mvitek/.ssh/known_hosts2: No such file or directory
debug1: load_hostkeys: fopen /etc/ssh/ssh_known_hosts: No such file or directory
debug1: load_hostkeys: fopen /etc/ssh/ssh_known_hosts2: No such file or directory
debug1: Host 'bitbucket.org' is known and matches the RSA host key.
debug1: Found key in /home/mvitek/.ssh/known_hosts:1
debug3: send packet: type 21
debug2: ssh_set_newkeys: mode 1
debug1: rekey out after 134217728 blocks
debug1: SSH2_MSG_NEWKEYS sent
debug1: expecting SSH2_MSG_NEWKEYS
debug3: receive packet: type 21
debug1: SSH2_MSG_NEWKEYS received
debug2: ssh_set_newkeys: mode 0
debug1: rekey in after 134217728 blocks
debug2: get_agent_identities: ssh_agent_bind_hostkey: communication with agent failed
debug1: get_agent_identities: ssh_fetch_identitylist: communication with agent failed
debug1: Will attempt key: /home/mvitek/.ssh/id_rsa
debug1: Will attempt key: /home/mvitek/.ssh/id_ecdsa
debug1: Will attempt key: /home/mvitek/.ssh/id_ecdsa_sk
debug1: Will attempt key: /home/mvitek/.ssh/id_ed25519
debug1: Will attempt key: /home/mvitek/.ssh/id_ed25519_sk
debug1: Will attempt key: /home/mvitek/.ssh/id_xmss
debug1: Will attempt key: /home/mvitek/.ssh/id_dsa
debug2: pubkey_prepare: done
debug3: send packet: type 5
debug3: receive packet: type 7
debug1: SSH2_MSG_EXT_INFO received
debug1: kex_input_ext_info: server-sig-algs=<[email protected],[email protected],ssh-rsa,ssh-dss,ecdsa-sha2-nistp256,ecdsa-sha2-nistp384,[email protected],rsa-sha2-256,rsa-sha2-512,ecdsa-sha2-nistp521,[email protected],[email protected]>
debug3: receive packet: type 6
debug2: service_accept: ssh-userauth
debug1: SSH2_MSG_SERVICE_ACCEPT received
debug3: send packet: type 50
debug3: receive packet: type 51
debug1: Authentications that can continue: publickey
debug3: start over, passed a different list publickey
debug3: preferred gssapi-with-mic,publickey,keyboard-interactive,password
debug3: authmethod_lookup publickey
debug3: remaining preferred: keyboard-interactive,password
debug3: authmethod_is_enabled publickey
debug1: Next authentication method: publickey
debug1: Trying private key: /home/mvitek/.ssh/id_rsa
debug3: no such identity: /home/mvitek/.ssh/id_rsa: No such file or directory
debug1: Trying private key: /home/mvitek/.ssh/id_ecdsa
debug3: no such identity: /home/mvitek/.ssh/id_ecdsa: No such file or directory
debug1: Trying private key: /home/mvitek/.ssh/id_ecdsa_sk
debug3: no such identity: /home/mvitek/.ssh/id_ecdsa_sk: No such file or directory
debug1: Trying private key: /home/mvitek/.ssh/id_ed25519
debug3: no such identity: /home/mvitek/.ssh/id_ed25519: No such file or directory
debug1: Trying private key: /home/mvitek/.ssh/id_ed25519_sk
debug3: no such identity: /home/mvitek/.ssh/id_ed25519_sk: No such file or directory
debug1: Trying private key: /home/mvitek/.ssh/id_xmss
debug3: no such identity: /home/mvitek/.ssh/id_xmss: No such file or directory
debug1: Trying private key: /home/mvitek/.ssh/id_dsa
debug3: no such identity: /home/mvitek/.ssh/id_dsa: No such file or directory
debug2: we did not send a packet, disable method
debug1: No more authentication methods to try.
[email protected]: Permission denied (publickey).
是什么导致了与代理的通信错误？
在我的 Linux 计算机上，我有以下.tmux.conf文件：
# Enable mouse mode (tmux 2.1 and above)
set -g mouse on
这允许我在 tmux 会话中使用鼠标滚轮上下滚动。
如果我在我的 Linux 计算机上使用 Ubuntu on Windows (WSL) ssh，这仍然可以正常工作。我可以tmux attach进入会话并使用鼠标上下滚动就可以了。我还可以看到 tmux 会话的整个历史记录（直到最大回滚限制），但我看不到ssh命令或tmux attach：
请注意，我可以一直回滚到会话的开始，但是并没有出现sshand命令。tmux attach
但是，如果我使用 MobaXterm WSL-Ubuntu 会话，这将失败。我启动了一个 WSL-Ubuntu 会话并使用相同的命令，但现在滚轮只填充最后一个命令，而不是向上滚动：
此外，如果我使用右侧的 MobaXterm 滚动条向上滚动，我仍然可以看到外部历史记录，而不是会话历史记录：
Ctrl+BPgUp即使在 MobaXterm 中，常规的 tmux也可以滚动浏览会话历史记录。
如何在 MobaXterm WSL-Ubuntu 会话中从 Linux/WSL 终端获取行为？
我有一台 LG 27UK850-W 显示器，它配有 DisplayPort、HDMI 和 USB-C 电缆。USB-C 电缆被记录为用于显示和数据传输（显示器还有一个用于快速加密狗访问的 USB 插座）我已将 DisplayPort 和 USB-C 电缆连接到我的计算机，但现在 Windows 保留给我一个错误，说显示连接可能受到限制（将我链接到此站点）。显示器在其他方面工作正常，其上的 USB 端口也可以工作。
如果我断开 USB-C 电缆，错误就会消失，显示器仍然可以工作（因为它是通过 DisplayPort 连接的），但显示器上的 USB 端口也停止工作，所以我宁愿保持 USB-C 电缆连接.
那么如何告诉 Windows 我只想使用 USB-C 连接进行数据传输，而不是用于显示？