Ms7 Search
Google 搜尋 翻譯
calendar
« 四月 2025 »
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30        
近期文章
文章分類
網站連結
Syndicate

« | »

excel 只貼上小計列

2011-08-29 @ 08:32 in Windows

只想複製小計列不要資料列,在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.

作者 best web hosting 2020 @ 16:59, 2020-07-16

excel 只貼上小計列 | 豬窩

There is definately a lot to learn about this topic.
I really like all of the points you've made.

作者 website hosting companies @ 07:53, 2020-07-18

excel 只貼上小計列 | 豬窩

At this time I am ready to do my breakfast, later
than having my breakfast coming yet again to
read more news.

作者 web hosting services @ 10:46, 2020-07-18

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.

作者 best web hosting company @ 04:39, 2020-07-22

excel 只貼上小計列 | 豬窩

Hi there friends, its wonderful piece of writing about teachingand completely defined, keep it up all the time.

作者 web hosting companies @ 10:58, 2020-07-23
發表迴響
 authimage