excel 只貼上小計列
只想複製小計列不要資料列,在googl查找,原來excel 有一個 [選取可見儲存格] 的指令可用,只要從自訂中將其拉出來就好了
檢視功能表→工具→自訂→指令(索引標籤)→
左邊的類別選「編輯」,右邊的「指令」視窗移動捲軸至最下面,
選取倒數第二個「選取可見儲存格」的圖示(就是4個實心的長方形)
滑鼠左鍵按住這個具按鈕的圖示不放拖曳至一般或格式工具列中的工具按鈕中
參照: http://www.wretch.cc/blog/Yettie/6975906
迴響
excel 只貼上小計列 | 豬窩
First of all I would like to say excellent blog!
I had a quick question in which I'd like to ask if you do not mind.
I was curious to know how you center yourself and clear your mind prior to writing.
I've had a difficult time clearing my mind in getting
my thoughts out. I truly do take pleasure in writing however it just seems like the first 10 to 15 minutes tend to be lost just trying to figure out how to begin. Any suggestions or hints?
Many thanks!
excel 只貼上小計列 | 豬窩
of course like your web site however you need to test the spelling on quite a few of your posts.
A number of them are rife with spelling issues and I to find
it very bothersome to tell the truth on the other hand I'll certainly
come back again.
excel 只貼上小計列 | 豬窩
Hi, i think that i saw you visited my website thus i came to “return the favor”.I am attempting to find things to enhance my site!I suppose its ok to use some of your ideas!!
excel 只貼上小計列 | 豬窩
Excellent article! We are linking to this great post on our
website. Keep up the good writing.
excel 只貼上小計列 | 豬窩
Do you have a spam problem on this website; I
also am a blogger, and I was wanting to know your situation;
many of us have created some nice methods and we are looking
to exchange techniques with others, be sure to shoot me an email if interested.