答案1
您需要做的就是通过手动输入写下标记的红色单元格地址。当您标记一个单元格时,即使合并,您也会看到它们的地址。
答案2
只需在另一张表中创建一个新表。
A | B | C | D
=Sheet1!A2 | =Sheet1!B2 | =Sheet1!C4 | =Sheet1!D4
=Sheet1!A5 | =Sheet1!B5 | =Sheet1!C7 | =Sheet1!D7
=Sheet1!A8 | =Sheet1!B8 | =Sheet1!C10 | =Sheet1!D10
假设第一行是标题,数据从第二行开始。