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/09/16 13:12
Great blog here! Also your web site loads up very
fast! What web host are you using? Can I get your affiliate link to your host?
I wish my website loaded up as quickly as yours lol
1398/09/14 10:28
We're a group of volunteers and starting a new scheme in our community.
Your web site provided us with valuable info to work
on. You've done an impressive job and our whole community will be thankful to you.
1398/09/7 12:44
I'm extremely impressed with your writing skills and also with the layout on your weblog.
Is this a paid theme or did you modify it yourself?
Either way keep up the excellent quality writing, it is rare to see
a nice blog like this one these days.
1398/08/27 11:13
Great blog! Do you have any suggestions for aspiring writers?
I'm planning to start my own blog soon but I'm a little lost on everything.

Would you advise starting with a free platform like Wordpress
or go for a paid option? There are so many options out there
that I'm totally overwhelmed .. Any ideas? Appreciate it!
1398/08/20 12:31
It's fantastic that you are getting ideas from this piece of writing
as well as from our discussion made here.
1398/08/18 19:35
I like the helpful info you provide in your articles.
I'll bookmark your blog and check again here regularly. I'm quite certain I will learn plenty of new stuff right
here! Good luck for the next!
1398/08/13 21:28
First of all I want to say wonderful blog! I had a
quick question in which I'd like to ask if you don't mind.
I was curious to find out how you center yourself and clear your head before
writing. I have had a tough time clearing my
mind in getting my thoughts out. I truly do enjoy writing but it just seems like the first
10 to 15 minutes tend to be lost simply just trying
to figure out how to begin. Any suggestions or hints?
1398/07/17 12:57
Great post however , I was wanting to know if you could write a litte more on this subject?
I'd be very grateful if you could elaborate a little bit more.

1398/07/16 16:38
Excellent goods from you, man. I have understand your stuff previous to and you are just extremely
magnificent. I actually like what you have acquired here, certainly like what you are stating and the way in which you say it.
You make it enjoyable and you still care for to keep it sensible.
I can't wait to read much more from you. This
is actually a tremendous site.
1398/07/3 12:36
CRM Software is a strategy that helps streamline your employers qualified prospects, opportunities, appointments, earnigns and Service by trying to keep buyer as centre of the process.
1398/06/27 22:15
You can certainly see your skills in the article you write.
The world hopes for more passionate writers like you who are not afraid to mention how they believe.
All the time go after your heart.
1398/06/25 20:26
You're so interesting! I do not suppose I've read a single thing like that before.
So nice to discover somebody with unique thoughts on this issue.
Really.. many thanks for starting this up.
This website is one thing that is needed on the internet, someone with some originality!
1398/06/17 00:44
I'll immediately seize your rss as I can't find your e-mail subscription link or e-newsletter service.
Do you have any? Kindly permit me recognise in order that I
could subscribe. Thanks.
1398/06/13 06:07
Hi to all, how is all, I think every one is getting more from this web page, and your views are good in favor
of new viewers.
1398/06/2 23:05
Hi I am so thrilled I found your site, I really found you by
error, while I was researching on Digg for something else, Regardless
I am here now and would just like to say cheers for a tremendous post and a all round thrilling blog
(I also love the theme/design), I don't have time to go through it all at
the moment but I have book-marked it and also added your RSS feeds, so when I have
time I will be back to read a great deal more, Please do keep up
the awesome work.
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.

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