excel 只貼上小計列
只想複製小計列不要資料列,在googl查找,原來excel 有一個 [選取可見儲存格] 的指令可用,只要從自訂中將其拉出來就好了
檢視功能表→工具→自訂→指令(索引標籤)→
左邊的類別選「編輯」,右邊的「指令」視窗移動捲軸至最下面,
選取倒數第二個「選取可見儲存格」的圖示(就是4個實心的長方形)
滑鼠左鍵按住這個具按鈕的圖示不放拖曳至一般或格式工具列中的工具按鈕中
參照: http://www.wretch.cc/blog/Yettie/6975906
迴響
excel 只貼上小計列 | 豬窩
Excellent, what a web site it is! This web site presents valuable facts to us, keep it up.
excel 只貼上小計列 | 豬窩
There is definately a lot to learn about this topic.
I really like all of the points you've made.
excel 只貼上小計列 | 豬窩
At this time I am ready to do my breakfast, later
than having my breakfast coming yet again to
read more news.
excel 只貼上小計列 | 豬窩
If some one wishes expert view regarding blogging after
that i suggest him/her to pay a visit this website, Keep up the nice job.
excel 只貼上小計列 | 豬窩
Hi there friends, its wonderful piece of writing about teachingand completely defined, keep it up all the time.