是怎樣的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個。
＝＝＝＝＝＝
搞什麼嘛！！（翻桌）
where can i buy cheap clomiphene no prescription can you get generic clomiphene pills how to buy generic clomiphene clomid for sale can i get generic clomiphene for sale where can i get cheap clomiphene tablets get generic clomid for sale
Топ мест для незабываемого отдыха в Абхазии этим летом отдых в абхазии без посредников otdyh-abhaziya0.ru .
This platform has the hottest eva elfie xxx scenes. Discover eva elfie bbc scenes you won’t find elsewhere. Catch eva elfie latest porn with one click. Enjoy eva elfie xnxx content in top quality. Free eva elfie xxx video access with no signup. All eva elfie xxx videos in 4K quality. Every eva elfie sex video is available instantly. See all eva elfie porn videos uncensored https://evaelfie.ing.
Легко усваиваемый корм Jarvi без сои кукурузы и глютена ярви корм купить онлайн https://ozon.ru/category/jarvi-korm/ .
Предоставление транспорта катафалков и автобусов — полный комплекс ритуальных услуг Ритуальные услуги в Ярославле ritualnyye-uslugi.neocities.org .
Thanks for finally writing about > 3MB的Excel檔案
at 未熟女 < Liked it!
Romantik anlar için ideal olan full hd film koleksiyonları hd filimizle http://www.hdturko.com/ .
I am not sure the place you are getting your info, but good topic.
I must spend some time learning much more or understanding more.
Thanks for excellent information I used to be searching for this info for my mission.
Wow that was strange. I just wrote an really long comment
but after I clicked submit my comment didn’t
appear. Grrrr… well I’m not writing all that over again. Anyway,
just wanted to say superb blog!
Отдых в Гаграх недорого: лучшие предложения этого сезона отдых в гаграх http://otdyh-gagry.ru/ .
I could not refrain from commenting. Well written!
My web blog: agenolx
I’m not sure exactly why but this blog is loading very slow for me.
Is anyone else having this issue or is it a problem on my end?
I’ll check back later and see if the problem
still exists.
아기비타민d
More posts like this would create the online play more useful.
Clean the table with mild soap and wipe dry as you go
Сроки и стоимость поверки различных типов измерительных приборов Сайт поверки средств измерений https://poverka-si-msk.ru .
Отдых в Абхазии: Встречаем туристов теплом гостеприимством и чистыми пляжами абхазия цены http://otdyh-abhaziya01.ru/ .
Ainda que seja quase impossível nos livrar de todos os nossos preconceitos inconscientes
Добро пожаловать на 1xbet-egypt.netlify.app восторженные возможности. Премиум-опыт на 1xbet-egypt.netlify.app всеми новинками. Найдите лучшие предложения на 1xbet-egypt.netlify.app чтобы. Погрузитесь в азарт на 1xbet-egypt.netlify.app где каждый сможет. 1xbet-egypt.netlify.app — ваш путеводитель в мире ставок поднять уровень вашей удачи. Открывайте новые горизонты с 1xbet-egypt.netlify.app где. Откройте для себя 1xbet-egypt.netlify.app открыть новые горизонты. 1xbet-egypt.netlify.app ждет вас для. Погрузитесь в захватывающий мир 1xbet-egypt.netlify.app каждая ставка — это шанс. Исследуйте 1xbet-egypt.netlify.app где вас ждут. 1xbet-egypt.netlify.app — ваша удача начинается здесь ваши мечты станут реальностью. Наслаждайтесь игрой на 1xbet-egypt.netlify.app где каждый сможет. Присоединяйтесь к 1xbet-egypt.netlify.app для увлекательного времяпрепровождения что бы. Ваши возможности на 1xbet-egypt.netlify.app куда. Успех начинается с 1xbet-egypt.netlify.app где. Пусть удача будет с вами на 1xbet-egypt.netlify.app с вашим лучшим другом. Делайте ставки с 1xbet-egypt.netlify.app победа становится ближе. 1xbet-egypt.netlify.app — ваш онлайн-катализатор удачи где. one x bet app https://1xbet-egypt.netlify.app/ .
Hello there, just becamee alert to your blog through Google, and found that it’s truly informative.
I’m gonna watch out for brussels. I will be grateful if you continue this in future.
A lot off people will be benefited from your writing.
Cheers!
Loook into my web page; Bifold Doors
Адвокат по уголовным делам
It’s great that you are getting ideas from this paragraph as well as from our discussion made at
this time.
Почему стоит вызвать нарколога на дом: преимущества индивидуального подхода нарколог с выездом на дом clinic-narkolog24.ru .
Сухум — аренда жилья и отдых в зелёной части города отдых в абхазии 2025 цены сухум https://otdyh-v-suhumi1.ru/ .
Fastidious response in return of this matter with firm arguments
and describing all on the topic of that.
소액 결제 현금화
Thanks for sharing your thoughts. I really appreciate your efforts and I am waiting
for your next write ups thanks once again.
Thanks for putting this up. It’s evidently done.
digital insurance magazine
Алкоголь с доставкой без очередей пробок и утомительных поездок доставка алкоголя москва 24 алкоголь круглосуточно .
It’s going to be finish of mine day, but before end I am
reading this impressive post to increase my experience.
Лёгкие и устойчивые бокалы для вина для повседневного использования бокалы для вина купить http://www.bokaly-dlya-vina.neocities.org .
Легкое и крепкое подстолье для кухонного стола — лучшие предложения подстолье для большого стола https://www.podstolia-msk.ru .
zithromax online buy – cheap ciplox buy flagyl
Hello there! This is kind of off topic but I need
some help from an established blog. Is it hard to set up your own blog?
I’m not very techincal but I can figure things out pretty fast.
I’m thinking about making my own but I’m not sure where to begin. Do you have any tips or suggestions?
Thank you
Классика и стиль: императорский фарфор с росписью вручную ифз купить https://www.imperatorskiy-farfor.kesug.com/ .
order semaglutide 14mg sale – buy generic rybelsus cyproheptadine brand
Thiѕs page has qսikckly beϲome one of my leading resources for all things style.
Yoour unique perspectiνe and stylish approach are truly motivating.
I always look forward to your new posts!
Also visіt my website; Fred Perry Poloshirt
Hello! I’ve beenn reading yur weblog for some time now
and finally got the couage to go ahead and give you a shout out
from Kingwood Tx! Just wanted to mentikn keep up the fantastic job!
트위터 좋아요
Pretty section of content. I just stumbled upon your
blog and in accession capital to assert that I get actually enjoyed account your blog posts.
Any way I’ll be subscribing to your augment and even I achievement you access consistently fast.
Hi, i think that i saw you visited my blog thus i came to
“return the favor”.I am attempting to find things to improve my site!I suppose its ok to use some of your ideas!!
Уборка окон и фасадов: профессиональный клининг снаружи клининг мск https://www.kliningovaya-kompaniya10.ru .
Reading this article made me think about how important our
health really is. Not long ago, someone very close to me was diagnosed with
a serious eye condition. The only option was
urgent surgery. But the cost was devastating.
We felt lost, but thankfully, we found support online.
Through platforms like HelpMyEyes.com, we were able to start a campaign. And to our surprise,
many strangers came forward to share.
This experience showed me that the online community isn’t
just for entertainment or news — it’s a place where genuine kindness can happen. There is compassion out there, and when they hear about someone losing their sight and needing help, they often respond.
That’s why I always try to engage when I find blogs like
this. It might encourage just one more person to help someone.
Even a small action like telling a friend can save someone’s vision.
If anyone reading this feels inspired, I invite you to visit our fundraiser.
Every bit helps. Together, we can give hope.
Thank you again for this discussion.
Here is my web-site – cataract surgery donation
purchase domperidone generic – domperidone 10mg us order flexeril 15mg
My brother recommended I might like this website. He was once entirely
right. This submit truly made my day. You cann’t imagine simply
how so much time I had spent for this info! Thanks!
Преимущества лизинга по сравнению с покупкой коммерческого транспорта грузовики в лизинг грузовики в лизинг .
HorsePower Brandss Omaha
2525 N 117tһ Avee #300,
Omaha, NE 68164, United Statｅs
14029253112
industry һome services potential buying opportunities franchise companies (Mai)
Does your blog have a contact page? I’m having problems locating it but, I’d
like to send you an e-mail. I’ve got some suggestions for your blog you might be interested in hearing.
Either way, great blog and I look forward to seeing it expand over
time.
Valuable information. Lucky me I discovered your web site accidentally, and
I’m shocked why this coincidence didn’t came about in advance!
I bookmarked it.
Yes! Finally something about hola88.
Quality articles is the secret to invite the visitors to pay
a quick visit thee web page, that’s what this web site is providing.
beli like instagram
Строительство каркасных домов для круглогодичного проживания в вашем регионе каркасный дом в спб spb-karkasnye-doma-pod-kluch.ru .