excel 只貼上小計列
只想複製小計列不要資料列,在googl查找,原來excel 有一個 [選取可見儲存格] 的指令可用,只要從自訂中將其拉出來就好了
檢視功能表→工具→自訂→指令(索引標籤)→
左邊的類別選「編輯」,右邊的「指令」視窗移動捲軸至最下面,
選取倒數第二個「選取可見儲存格」的圖示(就是4個實心的長方形)
滑鼠左鍵按住這個具按鈕的圖示不放拖曳至一般或格式工具列中的工具按鈕中
參照: http://www.wretch.cc/blog/Yettie/6975906
迴響
excel 只貼上小計列 | 豬窩
Good post. I learn something new and challenging on websites I stumbleupon everyday.
It will always be exciting to read through content from
other authors and use something from their websites.
excel 只貼上小計列 | 豬窩
Thanks in favor of sharing such a good opinion, article is good, thats why i have read it completely
excel 只貼上小計列 | 豬窩
Paragraph writing is also a excitement, if you be familiar with after that you
can write if not it is difficult to write. adreamoftrains web hosting service
excel 只貼上小計列 | 豬窩
Because the admin of this site is working, no question very shortly it will be renowned, due to its feature contents.
excel 只貼上小計列 | 豬窩
Hello it's me, I am also visiting this web
page daily, this web page is genuinely nice and the
people are in fact sharing good thoughts.