Excel进阶操作——只显示目标区域
我们的目的就是在普通视图里面（看上去像页面视图），不显示非编辑区域的单元格，只显示我们需要区域的单元格。
效果见下图
步骤：
1、Ctrl+A 两次（应该是两次。两次选择所有区域，一次只选择编辑区域，仅内容时一次也可以）
2、Ctrl+9、Ctrl+0（前者隐藏行，后者隐藏列）
3、Ctrl+G（定位需要显示的目标单元格区域）
4、输入目标区域（如："a1:b5"不含引号，则定位到a1到b5这两列五行）
5、Ctrl+Shift+9、Ctrl+Shift+0（前者显示行，后者显示列）
说明：效果图中，除了本操作外，还使用了隐藏行号列标和工作表标签等操作。以上内容为本站原创，资源共享，欢迎转发。
94 responses to "Excel进阶操作——只显示目标区域"
11:13 on 九月 12th, 2011
Hello, I found your blog in a new listing of blogs. I dont know how your weblog came up, will want to been a typo, Your weblog seems to be good. Have a nice day.
16:03 on 九月 12th, 2011
To get started incomes cash with your weblog, initially use Google Adsense but via as your site visitors increases, maintain including an expanding money making packages to your site.
20:21 on 九月 14th, 2011
nice post. I additionally advocate conducting polls-is helping alot whilst it comes the best way discovering out what your record desires, needs and desires.
21:48 on 九月 14th, 2011
I am glad I was capable of finding your put up! I actually appreciate the data! Could you mind extraordinarily if I place a back-link from my site ?
22:10 on 九月 21st, 2011
wonderful stuff thanx
4:04 on 九月 22nd, 2011
What is captcha code?, pls provide me captcha code codes or plugin, Thank you in advance.
22:47 on 九月 22nd, 2011
I wish I might find the time put in writing consistantly at my weblog, on a everyday basis, like you do. Nicely carried out! I look in advance your additional article.
3:18 on 九月 23rd, 2011
Your blog is so informative … sustain the nice work!!!!
17:20 on 九月 26th, 2011
Seems like a good idea. You will have to tons of subscriber should you do that.
20:39 on 九月 26th, 2011
Thanks for writing a few very relevant topic. So much tenderfoot entrepreneurs nowadays advertise and offer and sell no matter they’ll with out even having a concrete thought of what issues to prioritize. Preserve them coming!
3:58 on 九月 27th, 2011
I usually don’t submit in Blogs but your blog forced me to, wonderful work.. beautiful …
4:17 on 九月 27th, 2011
nice post. I also recommend undertaking polls-is helping alot whilst it comes down to finding out what your record desires, wants and desires.
3:41 on 九月 28th, 2011
A SUPPORTED BY THE DEVELOPER TOOLS? It was once interesting. You appear very educated in ypour field.
8:24 on 九月 29th, 2011
the global disaster has affected the internet worl in the constructive manner, on the grounds that persons are turning online to make money. but what you just shared is very actual, by giving high quality content can assist increase quickly as enterprise either in the downtimes or vice versa.
20:39 on 九月 29th, 2011
Hello Guru, what entice you to publish an article. This text was once extraordinarily interesting, especially on the grounds that I used to be searching for thoughts in this subject final Thursday.
7:23 on 九月 30th, 2011
Do you do all your own writing? Or do you outsource a few of it? I’m search of a few related content material for my weblog! Those are great posts!
0:15 on 十月 3rd, 2011
Whats up very nice blog!! Guy .. Lovely .. Superb .. I’ll bookmark your weblog and take the feeds also…
12:23 on 十月 3rd, 2011
Hi, I will be able to’t understand find out how to add your site in my rss reader. ready to Help me, please
7:57 on 十月 4th, 2011
affiliate marketing is tough enterprise; no wonder numerous associates wrestle to make mere pennies. will also be a great put up with excellent ideas for amateur as smartly based affiliates.
8:33 on 十月 5th, 2011
Nice ideas you have in your site. I am a new blogger and learning to write efficient contents. I had began to write down notes so the idea no longer going to slip out once I sit in entrance of the com.
1:21 on 十月 6th, 2011
Thank you for the learners steps. That is helpful. I’ve a question, as a beginners, how do you build credibility within the niche? I assume we want construct credibility to construct the checklist?
11:03 on 十月 6th, 2011
may also be nice article. I’ve now left the rat race, by no means to look back. You’re right that the one technique to make any first rate cash is via operating your personal business!
6:04 on 十月 7th, 2011
superb stuff thanx
23:10 on 十月 9th, 2011
Of course, what an awesome website and informative posts, I’ll upload backlink – bookmark this website? Regards, Reader.
13:47 on 十月 11th, 2011
I so agree with this comment. you’ve limited assets and limited price range an academic on method pass approximately it would be great. I’m a newbie Web Marketer with my first blog.
13:26 on 十月 12th, 2011
I am sure everyone love loose review. I ponder if I am for your evaluate ?
1:53 on 十月 13th, 2011
Hello there, I found your blog method Google whereas trying to find first assist for a heart assault and your post looks very attention-grabbing for me.
15:55 on 十月 13th, 2011
haha … the only who’s posting the comments
1:44 on 十月 14th, 2011
Good day, I discovered your blog in a new listing of blogs. I dont know how your blog got here up, will want to been a typo, Your blog seems to be good. Have a nice day.
12:25 on 十月 17th, 2011
Nice tips! Thank you for posting this:-)
16:48 on 十月 17th, 2011
Good tips. You didn’t write sponsoring contest. This provides you backlinks.
16:06 on 十月 19th, 2011
Do you do all your individual writing? Or do you outsource a few of it? I’m looking for a few comparable content for my weblog! Those are nice posts!
23:12 on 十月 20th, 2011
Do you do all your individual writing? Or do you outsource some of it? I’m on the lookout for a few comparable content material for my blog! Those are great posts!
13:27 on 十月 21st, 2011
the perfect concept is 100% content. Use content material once you do your promotions. You’ve probably noticed on this weblog every time I do a blog submit that pretty much just recommends a product or service, at all times a number individuals don’t like that.
2:55 on 十月 24th, 2011
I’ll be following your blog. =)
7:01 on 十月 24th, 2011
Even a professional blogger, they nonetheless using these suggestions =D
11:41 on 十月 25th, 2011
I want I could discover the time to write consistantly at my blog, on a day after day basis, such as you do. Properly performed! I sit up for your additional article.
4:44 on 十月 26th, 2011
Your blog is so informative … keep up the nice paintings!!!!
7:00 on 十月 27th, 2011
thank you !! very helpful publish!
11:18 on 十月 27th, 2011
To begin incomes cash with your weblog, initially use Google Adsense however via as your visitors will increase, keep adding more and more money making programs for your site.
15:48 on 十月 30th, 2011
It’s about time smooene wrote about this.
1:20 on 十月 31st, 2011
I agree with that 100%! Action makes things happen. Nobody ever realized to walk without taking the primary step.
5:57 on 十月 31st, 2011
Please, can you PM me and inform me few extra thinks about this, I am actually fan of your blog…gets solved correctly asap.