[問題] 自動篩選
(若是和其他不同軟體互動之問題 請記得一併填寫)
軟體:EXCEL
版本:2010
想詢問一下excel裡的自動篩選 下拉之後不是會有一個「依色彩篩選」選項可以使用嗎
？
最近不知道是有人按到什麼 導致不能依色彩篩選了
全選複製到新的活頁簿就又有了
問題是舊有的檔案裡面的資料有套用一些公式
也有很多頁工作表 實在是不太方便搬移到新的活頁簿
請問有哪位大大知道如何解決嗎 orz
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 118.168.146.246
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1490370166.A.C34.html
→
03/25 08:41, , 1F
03/25 08:41, 1F
→
03/25 08:47, , 2F
03/25 08:47, 2F
→
03/25 12:54, , 3F
03/25 12:54, 3F
→
03/25 12:54, , 4F
03/25 12:54, 4F
→
03/25 15:08, , 5F
03/25 15:08, 5F
→
03/25 15:08, , 6F
03/25 15:08, 6F
→
03/25 16:41, , 7F
03/25 16:41, 7F
→
03/25 16:41, , 8F
03/25 16:41, 8F
→
03/25 17:39, , 9F
03/25 17:39, 9F
→
03/25 17:39, , 10F
03/25 17:39, 10F
→
03/25 17:39, , 11F
03/25 17:39, 11F
→
03/25 17:39, , 12F
03/25 17:39, 12F
→
03/25 17:39, , 13F
03/25 17:39, 13F
→
03/25 17:39, , 14F
03/25 17:39, 14F
→
03/25 21:41, , 15F
03/25 21:41, 15F
→
03/25 21:41, , 16F
03/25 21:41, 16F
→
03/25 21:42, , 17F
03/25 21:42, 17F
→
03/25 21:42, , 18F
03/25 21:42, 18F
→
03/26 17:26, , 19F
03/26 17:26, 19F
→
03/27 13:39, , 20F
03/27 13:39, 20F
→
03/27 13:39, , 21F
03/27 13:39, 21F
→
03/27 13:39, , 22F
03/27 13:39, 22F
→
03/27 13:39, , 23F
03/27 13:39, 23F
→
03/27 13:39, , 24F
03/27 13:39, 24F
→
03/27 15:07, , 25F
03/27 15:07, 25F
→
03/27 15:07, , 26F
03/27 15:07, 26F
→
03/27 15:44, , 27F
03/27 15:44, 27F
→
03/27 15:51, , 28F
03/27 15:51, 28F
→
03/27 18:34, , 29F
03/27 18:34, 29F
→
03/27 18:34, , 30F
03/27 18:34, 30F
→
03/27 18:34, , 31F
03/27 18:34, 31F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
