excel 只貼上小計列
只想複製小計列不要資料列,在googl查找,原來excel 有一個 [選取可見儲存格] 的指令可用,只要從自訂中將其拉出來就好了
檢視功能表→工具→自訂→指令(索引標籤)→
左邊的類別選「編輯」,右邊的「指令」視窗移動捲軸至最下面,
選取倒數第二個「選取可見儲存格」的圖示(就是4個實心的長方形)
滑鼠左鍵按住這個具按鈕的圖示不放拖曳至一般或格式工具列中的工具按鈕中
參照: http://www.wretch.cc/blog/Yettie/6975906
迴響
excel 只貼上小計列 | 豬窩
Howdy, I think your site may be having internet browser compatibility issues.
When I take a look at your blog in Safari, it looks fine but when opening in I.E., it has some overlapping issues.
I merely wanted to give you a quick heads up! Besides that, excellent website!
excel 只貼上小計列 | 豬窩
Hello would you mind letting me know which web host you're utilizing?
I've loaded your blog in 3 completely different web browsers and I must say this blog
loads a lot quicker then most. Can you recommend a good web hosting provider
at a honest price? Cheers, I appreciate it!
excel 只貼上小計列 | 豬窩
Very good post! We will be linking to this great post on our site.
Keep up the great writing.
excel 只貼上小計列 | 豬窩
Hey there! I just wanted to ask if you ever have any
issues with hackers? My last blog (wordpress) was hacked and
I ended up losing months of hard work due to no backup.
Do you have any methods to stop hackers?