Sepehr VaezAfshar's Personal Blog - با این تکنیکها به یک کاربر حرفه ای در اکسل مبدل شوید
Sepehr VaezAfshar's Personal Blog
Art + Tech
درباره وبلاگ

I always excited to
learn something new especially in architecture, urban design and
landscape architecture.
I have easy-going nature that makes me work well with others
also, strong communication skills that required in order to
communicate interactively with the client.
I'm working on ArTech Startup.
مدیر وبلاگ : Sepehr Vaez Afshar
این وب چقدر نظرتو جلب کرد؟

آمار وبلاگ
  • کل بازدید :
  • بازدید امروز :
  • بازدید دیروز :
  • بازدید این ماه :
  • بازدید ماه قبل :
  • تعداد نویسندگان :
  • تعداد کل پست ها :
  • آخرین بازدید :
  • آخرین بروز رسانی :

در این پست شما تکنیک های بسیار جذابی را که شاید تاکنون نمیدانستید خواهید آموخت. این تکنیک ها شما را به یک کاربر حرفه ای در اکسل مبدل خواهد کرد.

۱- با دابل کلیک روی عنوان ریبان آن را پنهان و با تکرار این کار آن را ظاهر نمایید.

[Image] Double click Ribbon to show/hide

۲- تکنیک چرخاندن غلطک (اسکرول)

[Image] Use mouse scroll wheel in Ribbon

۳- راست کلیک روی مکان نشان داده شده و رفتن به شیت دلخواه 

[Image] Right click to show worksheets list


۴٫ انتخاب چند شیت با نگهداشتن کلید Ctrl و جابجا کردن آن

[Image] 5. CTRL + Click to select non-adjacent worksheets

۵٫ انتخاب سریع چندین شیت با نگهداشتن کلید Shift[Image] Shift + Click to select adjacent worksheets  ۶- کپی قالب بندی مورد نظر و اعمال آن روی سایر سلول ها با دابل کلیک روی گزینه Format Painter

[Image] Lock the Excel Format Painter

۷- بزرگ و کوچک کردن ناحیه فرمولا بار با موس 

[Image] Vertically Expand the Excel Formula Bar

۸- دابل کلیک روی یک کلمه برای انتخاب کامل کلمه


۹- استفاده از ابزار پرکردن (Fill handle) با استفاده از کلیک راست

[Image] Right click then drag Fill Handle

با کمک ابزار فیل هندل یا بسط دادن اما با کلیک راست موس میتوانید گزینه های زیر را مشاهده و از این تکنیک لذت ببرید

  • Copy Cells
  • Fill Series
  • Fill Formatting Only
  • Fill Without Formatting
  • Fill Days
  • Fill Weekdays
  • Fill Months
  • Fill Years
  • Linear Trend
  • Growth Trend
  • Series…

  ۱۰٫ پر کردن خودکار با دابل کلیک[Image] Double click Fill Handle  ۱۱٫ ویرایش محدوده فرمول

[Image] Edit Cell Ranges in Formulas

با استفاده از موس پس از آنکه سلول حاوی فرمول را انتخاب کردید و با دابل کلیک یا زدن F2 به حالت ویرایش فرمول رفتید میتوانید به صورتی که نمایش داده شده محدوده حاوی فرمول را تغییر دهید.

۱۲٫ پرش به اولین و آخرین سلول حاوی داده

[Image] Jump to furthest row or column

این تکنیک از تکنیک های محبوب من می باشد. و ارزش آن را زمانی درک خواهید کرد که بین یک محدوده چندهزار سطری بخواهید سریعا به ابتدا یا انتهای آن منتقل شوید.

۱۳٫ انتخاب سریع یک محدوده به کمک کلید Shift

[Image] Fast cell range selection with Shift + Click

اولین سلول را انتخاب کرده و با نگهداشتن کلید Shift و کلیک روی سلول انتهایی آن محدوده را انتخاب نمایید.

۱۴٫ انتخاب محدوده چندگانه با نگهداشتن کلید Ctrl

[Image] Non-contiguous cell range selection with CTRL + Click

۱۵٫ جابجا کردن محدوده انتخاب شده به وسیله موس

[Image] Move selected range by dragging range border

۱۶٫ جابجا کردن یک ستون یا محدوده انتخابی با نگهداشتن کلید Shift

[Image] Swap selected cell ranges fast with Shift + Drag

یکی دیگر از تکنیک های مورد علاقه من که بسیار کاربردی هم هست جابجا کردن محدوده انتخابی با استفاده از  SHIFT + Drag   ۱۷٫ کپی کردن محدوده انتخابی با نگهداشتن کلید Ctrl  [Image] Copy selected cell ranges fast with CTRL + Drag

و اما آخرین مورد کپی سریع محدوده انتخابی با نگه داشتن کلید Ctrl و درگ به محل مورد نظر می باشد.
با توجه به اینکه زمان کافی برای تایپ این آموزش نداشتم و اینکه در تصاویر به صورت واضح عمل انجام شده مشخص می باشد توضیحات تکمیلی و ساده تر ندادم. اما در هرکدام از موارد که مشکلی داشتید آماده توضیح هستم یا اینکه اگر تکنیک دیگری هست که شما از آن استفاده می کنید میتوانید از قسمت نظرات به اشتراک بگذارید.

نوع مطلب : Microsoft، مقاله آموزشی، 
برچسب ها : excell، اکسل،
لینک های مرتبط :

1398/05/26 17:18
Thanks for sharing.
1398/05/24 00:34
Pretty nice post. I just stumbled upon your weblog and wished to say that I have really enjoyed surfing
around your blog posts. In any case I will be subscribing to your rss feed and I hope you write again soon!
1398/05/23 08:13
Attractive component of content. I simply stumbled upon your web site and in accession capital to assert that I get
actually enjoyed account your weblog posts. Any way I will be subscribing to
your feeds or even I achievement you get entry to persistently quickly.
1398/05/22 23:31
Having read this I thought it was really enlightening.
I appreciate you taking the time and energy to put this informative article together.
I once again find myself personally spending a significant amount of time
both reading and commenting. But so what,
it was still worth it!
1398/05/18 14:19
Great post.
1398/05/10 13:55
Please visit our official website.
1398/05/10 13:55
Please visit our official website.
1398/05/9 20:04
Great site you have here but I was curious if you knew of any message boards that
cover the same topics talked about in this article?

I'd really love to be a part of community where I can get suggestions from other knowledgeable individuals that share the same interest.
If you have any recommendations, please let
me know. Kudos!
1398/05/9 11:40
Hurrah! Finally I got a weblog from where I can actually obtain valuable data regarding my study and knowledge.
1398/05/4 10:22
If you wish for to get much from this article then you have to apply these methods to
your won website. pof natalielise
1398/05/4 05:27
Great article, totally what I was looking for. natalielise pof
1398/05/3 17:23
I have been surfing on-line greater than three
hours nowadays, but I by no means found any interesting article like yours.
It is pretty price enough for me. In my opinion, if
all webmasters and bloggers made just right content as
you probably did, the net might be a lot more helpful than ever before.
1398/05/1 20:04
I'd like to find out more? I'd care to find out more
1398/04/31 15:45
Thanks for the best article.
1398/04/29 19:45
Its like you read my mind! You appear to know so much about
this, like you wrote the book in it or something.
I think that you could do with some pics to drive the message home a little bit,
but instead of that, this is wonderful blog. A fantastic read.
I'll certainly be back.
1398/04/10 14:20
Great post.
1398/03/22 06:45
We stumbled over here coming from a different page and thought I
might check things out. I like what I see so now i am following
you. Look forward to exploring your web page repeatedly.
1398/03/21 11:35
Norton.com/setup to install setup product key, learn how to download, install, and active Norton setup on your window and Mac device still facing problem call now. safe on social media
1398/03/20 17:22
This is very interesting, You're a very skilled blogger.
I have joined your rss feed and look forward to seeking more of your wonderful post.
Also, I have shared your site in my social networks!
1398/03/19 11:28

When I initially commented I clicked the "Notify me when new comments are added" checkbox and now each time a comment is added I get four e-mails with the same comment. Is there any way you can remove me from that service? Bless you!
1398/03/18 16:21

Wonderful beat ! I would like to apprentice at the same time as you amend your web site, how could i subscribe for a weblog web site? The account aided me a acceptable deal. I have been a little bit acquainted of this your broadcast provided vibrant clear concept
1398/03/18 08:31
It is really a nice and useful piece of info.
I'm satisfied that you shared this helpful info with us.
Please keep us up to date like this. Thank you for sharing.
1398/03/17 16:54
...Thanx For Sharing this post
1398/03/12 14:42
I blog frequently and I seriously appreciate your information. This great article has truly
peaked my interest. I am going to book mark your website and
keep checking for new details about once per week.
I opted in for your RSS feed as well.
1398/03/9 18:22
This is very interesting, You're a very skilled blogger.
I've joined your rss feed and look forward to seeking more of your excellent post.
Also, I've shared your site in my social networks!
1398/03/1 17:30
nice information on your blog
1398/03/1 17:28
visit to know more In your blog unique concept to write a nice blog
1398/02/27 14:19
aolhelp if you are facing any issue in your aol email then call 1800-684-5649. for all type of help. feel free to call.
1398/02/25 15:47
Every weekend i used to pay a quick visit this web site, as i wish for enjoyment, as this this website conations really good funny stuff too.
1398/02/20 22:48
I'm extremely impressed with your writing talents as well as
with the structure on your weblog. Is this a paid topic or did you customize it your
self? Either way keep up the nice quality writing, it's rare to peer
a nice blog like this one these days..

نمایش نظرات 1 تا 30