是怎樣的Excel檔案，只有一個工作表，內容看起來只有三頁，但是檔案大小卻高達3MB！？
這絕對不是靈異事件！
也不是不是虛構或玩笑！！
因為，我快被那些文字方塊弄到抓狂了！！！
（冷靜時間）
事情一開始是這樣的，我從同事的手中得到了一份文件，要轉寄給建築師。
由於文件中有三頁表格，分別為不同項目，為了區分開來，所以我動手分割檔案。
可是分割的過程，異常的慢……
等到我在email時試圖夾帶該文件，才發現該文件的檔案大小高達3MB之多。
更詭異的是，當我按下預覽列印時，居然要印54頁，其中除了前三頁以外，其餘的51頁都是空白的。但最恐怖的事情不只如此，無論我用列刪除，或者是欄刪除，都無法完全的將空白頁消除掉。
這表示什麼？
表示有看不見的東西占住了那些空白頁，所以Excel才一直堅持要列印那些空白頁。
而且那看不見的東西還無法以範圍選取刪除……
終於仔細找尋之下找到那個隱形的兇手～…
這已經是清過一陣子之後才拍的，原本「文字方塊」後面那串數字是15xxx，表示這個Excel工作表中至少有15xxx無框線、無背景、無內容的文字方塊。
無法用群組選取的方式將excel內的所有文字方塊刪除，而且也無法用刪欄、刪列…甚至是ctrl+A刪除，所有的內容都不見了，但文字方塊仍然會在，而且還不會通通都跑到A1那格…
Google找不到解，Yahoo知識家找不到解，當然…Excel內建的說明也找不到解。
有新增文字方塊的說明，可是我不需要啊啊啊！！！我已經太多了！！！！
我想找的是「一次清除所有空文字方塊」的方法！！！！＞＿＜
想清掉空的文字方塊，只能慢慢地…「點選→刪除、點選→刪除、點選→刪除、點選→刪除、點選→刪除…」重覆這樣的動作直到所有的文字方塊都刪掉，動作的頻率不能太快否則會開啟文字方塊的設定視窗。
而且由於該文字方塊是「無框線、無背景、無內容」，所以還要用遊標搜尋是不是還有餘黨。
是有另外一個方法可以迴避掉那一萬五千多的空文字方塊，可是感覺就好像輸給文字方塊的感覺…（哇尚討呀輸ㄟ甘嘎！）
不過也沒辦法…就迴避吧～orz
這是嘗試許久，又經同事的點醒才找到的方法。
第一步，建立新工作表。
第二步，在原工作表按ctrl+A全部選取後複製。
第三步，在新工作表中，在A1格上按右鍵選擇性貼上，選全部→確定。
第四步，最後再調整一下列印設定…。
這下終於擺脫掉那些討人厭的空文字方塊了～orz
＝＝＝＝＝＝
後記：
為什麼會有這種情況的發生呢？
第一點
因為文字方塊無框線、無背景、無內容，所以除了發覺檔案大小有異，或者莫名其妙要印空白頁以外，根本不會想到是有虛設的文字方塊存在。
第二點
文字方塊可以被以欄選取（或列選取）複製，但無法被欄選取（或列選取）刪除。
第三點
公司同事製作文件的習慣，是重覆使用同一個工作表，然後以欄選取（或列選取）複製及刪除。
由第二點我們可以知道，文字方塊可以由範圍選取而複製，但不能因範圍選取而被刪除，所以在搭配上公司同事的習慣……
一開始假設只有一個空文字方塊，經過一次的範圍複製及刪除之後累積為兩個。
第二次的範圍複製及刪除之後，變成四個。
第三次的範圍複製及刪除之後，變成八個。
第四次…（以下中略）…，變成16個。
第五次，變成32個。
第六次，變成64個。
第七次，變成128個。
第八次，變成256個。
第九次，變成512個。
第十次，變成1024個。
相信有學過計算機概論的人，一定會對上面的數列很熟悉。
而且上面所舉的例只是一開始沒被查覺的空文字方塊只有一個，若是二、三個，那成長速度更加驚人，所需的次數越少。
依敝人選找到的文字方塊來看，有三～五種不同長寬的文字方塊。
再依敝人之前看到的數字…一萬五千來看，比較有可能的情況是：四個空文字方塊，經過十三次的範圍複製及刪除，可累積至16224個空文字方塊。
五個的話在十三次之後會變成20480個。
＝＝＝＝＝＝
搞什麼嘛！！（翻桌）
I believe that effective executive coaching can transform leadership styles. Check out Executive coaching san francisco for more information!
Just moved to Arizona and am eager to find a local podcast studio—any recommendations? affordable podcast studio near me
The before-and-after transformation thanks to carpet cleaning arleta is just stunning—my home feels so fresh!
This article is super helpful! I’ll definitely be calling Roof maintenance Cork next time I have an issue.
I like data-driven services. Any rodent control company in Los Angeles that tracks activity with monitoring stations? rodent control company in Los Angeles
For metal doors that stick, car lockout service adjusted hinges and the latch—no more slamming.
After a desk task damaged my posture, I finally searched for a chiropractic practitioner near me. Going to chiropractic clinic made a substantial difference.
This is such an informative article! Board up services really do help in emergencies. I’ll keep your tips in mind. board up service near me
Your article is a lifesaver for people like me who are dealing with pesky mice. Rodent Control Service
Curious whether mindfulness practices apply during sessions run by Executive coaching
Drug rehab Port St. Lucie with culturally sensitive care is important. drug rehab helped me filter programs.
1. Look, I’ve had my fair share of horror stories with tradies around Brisbane. One guy quoted me a price for a kitchen reno and then slapped on all these hidden fees after the job started https://www.cheaperseeker.com/u/naydiezkgh
Hopefully others observe value at the back of prevention in preference to just dealing aftermath later–widespread big difference made usual!!..# # anyKeywo rd ## septic tank sunland
Condo insurance nuances can be tricky. Alex Wakefield clarified the master policy vs. personal.
“Is there a community of podcasters who meet regularly near Phoenix?” professional podcast recording studio
Great article about rekeying vs replacing locks. For those considering a trusted provider, check out lock smith for expert guidance.
Kijk, ik zit zelf ook in CRUKS en ja, het is best pittig zonder gokken https://www.inkitt.com/kevonaaudo
It’s exciting to see tangible results from local SEO efforts showcased by Webjuice—truly inspiring! Learn more at SEO audit Ireland .
Furnace filter gets dirty too fast? Central Plumbing Heating & Air Conditioning checked duct leakage and MERV rating—see water heater service .
Pro tip: add a sediment filter to protect your new unit in South Florida. The installer from water heater installation near me added one and set me up with an annual maintenance plan. best water heater installation services
Love the built-in look for appliances. I coordinated panel-ready cabinets in Vancouver via kitchen cabinets .
Excited about our upcoming project! Working hand-in-hand with skilled **renovation builder** makes all the difference! builders and renovators
Such a helpful resource! I always start with Alex Wakefield when I need a quote.
The best tip I received was to keep food sealed and garbage secured—still, I called a rat control company just in case! https://www.google.com/search?q=Rodent+Control+Inc.
The synergy between content creation and AI optimization is intriguing! Looking forward to what insights %%link%% can provide on this topic. Ecommerce SEO Ireland
Thanks for the valuable article. More at patio door company .
1. Oh man, I totally get what you’re saying about dodgy tradies! A few years back, we hired a bloke to do some plumbing fixes around the house here in Brisbane https://pixabay.com/users/53339955/
Smart call on keeping firewood away from walls. A rodent control company in Los Angeles recommended 20 feet clearance. google.com
Pretty nice post. I just stumbled upon your weblog
and wanted to say that I have truly enjoyed surfing around your blog posts.
In any case I will be subscribing to your rss feed and I hope you write again very soon!
The ongoing discussions about architecture and sustainability in the U.S. are crucial, yet it’s important to balance innovation with practical implementation https://www.demilked.com/author/edhelmjajj/
Media lifespan depends on gallons processed. I used the water usage estimator at emergency plumber near me to plan replacements.
Annual furnace maintenance saved me from a breakdown—Central Plumbing Heating & Air Conditioning at water heater service can help you too.
”Thankful indeed whenever quality craftsmanship shines through showcasing talents exhibited skillfully displayed via endeavors orchestrated collectively via efforts exhibited proudly derived whilst engaging partnerships fostered within realms associated local bathroom remodel contractors
Impressed by your expertise in handling personal injury cases in Seattle! Your firm’s dedication to justice shines through every success story shared on Medical malpractice lawyer .
Wow, this is an eye-opener! I didn’t know rodent infestations could escalate so quickly. Your service sounds perfect. Mice Control
Thanks for the thorough analysis. Find more at west columbia auto glass .
Kijk, ik zit zelf ook in CRUKS en moet zeggen, het valt best tegen om helemaal niet te kunnen gokken. Soms vraag ik me af of zo’n MGA-licentie echt genoeg is om veilig te spelen. Eerlijk is eerlijk, je hoort soms toch verhalen over shady sites Skrill-gokken voordelen
Comprehending the underlying causes of addiction is crucial for reliable treatment. I learned a lot from the posts on outpatient addiction treatment services .
1. Eindelijk een casino gevonden met een eerlijke bonus! Die no deposit deal was echt chill, kon meteen ff proberen zonder eigen geld te riskeren. Top tip voor iedereen die eerst ff wil testen voordat ‘ie stort.
2 lees meer
¡Acabo de volver de unas vacaciones a caballo y todavía estoy en las nubes! La verdad es que nunca imaginé lo cerca que te sientes de la naturaleza Haga clic aquí para obtener más
The coastal vibe in this kitchen is beautiful. Similar cabinets are available in Vancouver BC at kitchen cabinets .
Addiction treatment with family therapy can be powerful. Port St. Lucie FL programs on addiction treatment center Port St. Lucie FL include it.
Cost factors were explained well—size, venting, and permits really add up in Broward. I compared quotes via water heater installation near me and found a fair price with warranty. water heater repair
Pair SoftPro with a refrigerator line carbon filter for polished taste. Add-on ideas on emergency plumber near me .
1. Mein Sohn hat seit ein paar Wochen immer wieder rote Flecken auf der Haut, besonders nach dem Spielen draußen. Könnte das eine Allergie sein? Mal ehrlich, ich mache mir echt Sorgen und weiß nicht, ob ich zum Arzt gehen sollte oder erstmal abwarten compliance with health insurance participation standards
Anyone else dealing with migraines? I’m seeking a chiropractic specialist near me and saw great feedback on chiropractic care .
Thanks for the insightful write-up. More like this at Teléfono taxi Arzúa .