close
Blogtrottr
批踢踢實業坊 ask 板
 
[請問] excel分頁問題
Jan 7th 2015, 11:55, by StockGod

作者StockGod (詹姆斯·西蒙斯)

站內ask

標題[請問] excel分頁問題

時間Wed Jan 7 11:55:51 2015

STEET1 STEET2 A A 1 20 1 =Sheet1!A1 2 50 2 =Sheet1!A2 3 32 3 =Sheet1!A3 問題 請問,我想在1~2之間插入一列,但STEET2的A2會變成=Sheet1!A3 A3會變成=Sheet1!A4 我希望STEET2一直維持新的STEET2的A2還是=Sheet1!A2...... 請問有解決的方式嗎 謝謝 -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 111.243.98.236 ※ 文章網址: http://www.ptt.cc/bbs/ask/M.1420602953.A.D85.html

wxtab019: 把你的STEET2的A2改成=Sheet1!A2 再往下拉一次 01/07 11:58

StockGod: 因為有一堆分頁,希望可以省掉這個動作 01/07 12:00

This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions
arrow
arrow
    全站熱搜

    inswdemwp1 發表在 痞客邦 留言(0) 人氣()