Welcome to excel world of Knowledge, Subscribe my channel for latest videos.
Hi Welcome Back to My channel
Excel World Of knowledge
So friends today i will teach you a macro Coding
Where in we just need to apply Code
and our all the cells will be autofit
when ever you type any think, you need to autofit the same manually.
you can see few same case
i will teach you a small macro coding, you just need to apply that coding and your entire cell will be autofit
Lets see few examples
i have few headers in the cell
i have already applied a coding hear
i will write a big name
you can see guys as soon as i have entered the complete name it get autofited.
i will write a big amount hear
so today's topic is all about a macro coding
which will teach you to auto fit the cells
and it will impress your boss as well
so we have data set hear
now i want this cells get autofit when ever i apply a word or value in it
how can we go on coding page, right client on the sheet name and click on view coding
else you can press ALT+F11
as soon as you press ALT + F11 it will bring you to macro page.
now we need to apply a small coding and before that you need to select worksheet from this dropdown
this will change automatically
now need to write a coding
Cells.Entirecolumn.autofit
your task is over
now ill go to my worksheet
i can click any were and it will get auto-fit
i will show you one example hear
auto-fit set according to the largest value
i will type a big name now
i will press enter now
now you can see
i will put amount as well
need to give big amount
So this is the macro for autofit
you can impress your BOSS as well
this was todays video
hope you like my video
please subscribe my channel and press like button and need your comments as well
Không có nhận xét nào:
Đăng nhận xét