Column Autofit in Excel using macro

 Hello dudes!

Did you ever feel irritated by resizing each column in Excel?👀

Don't worry this post is to solve your problem! Yess this post is about "How to enable column auto-resizing feature in excel using a single line macro (VBA)"

Language : VBA 

Before resizing


Size of column is not consistent with text


Whenever the above problem arises we will be manually adjusting the column right? . But hereafter it wont be the case!

Steps to enable column autofit feature:

Step 1:


- Right click on sheet name and select View Code

Step 2 :



- After getting this window click on the drop-down menu and select Worksheet (which means this code is applicable only for this specific sheet)


- First and last line of the code will be generated automatically , so our work is to type "Cells.EntireColumn.Autofit"


- Click on to excel icon on left corner (which brings you back to sheets)


- Haan Done!


- This code not only resize the columns as per existing data, but the resizing operation (in real time) will be carried out for newly entering data too! 


Step 3:

- Save this file in .xlsm format so that the macro (code which we have typed in) will also be saved.


Hope you all find this post useful . See you all in next post bubye see you . Enjoy Coding dudes!

Comments

Post a Comment

Popular posts from this blog

Coding in Mobile Phone!

Image
Hello dudes! Long time no see.. Hope you are all doing great!.  Today we are excited to share that "Practicing coding is possible in mobile phones too!". We have came to know about an app named Sololearn in play store and gave a try! It's actually a blissful app guys and gals. Let's dive into some of the features of the app. 1. As the name denotes Sololearn is a learning app which focuses on teaching programming languages. This app consists of handful of courses ranging from Introduction to intermediate of languages such as python, SQL, C, C++, C#, Java, JS etc.  On enrolling, a course  takes us through a series of text lessons followed by drag and drop choose questions and fill in the blanks (which wanted you to type in the answer ). You are provided with 5 hearts, for each mistake you ll lose one heart 😢. The lessons are followed by quiz too!  The create section in this app is very good wherein people have uploaded source codes...
Read more

BMI Calculator using python

Image
 Hello dudes! Long time no see.. Hope you are all doing great😃 After absconding for more than a month we came today to meet you all with a simple python program to calculate your own BMI (Body Mass Index) FYI what is mean by Body Mass Index? Body mass index (BMI) is a simple index of weight-for-height that is commonly used to classify overweight and obesity in adults . It is defined as a person's weight in kilograms divided by the square of his height in meters (kg/m 2 ) . [ If (You think == He might have stolen this definition of BMI from Wikipedia):         You are wrong ]  Hehe😁 actually i have stolen this definition from World Heath Organization So the program is : Explanation : - Height (in cm) and Weight (in kg ) asked from user as inputs in runtime. Here both the variables are declared as float datatype ,which allows decimal values in input. - Unit of height is converted from cm to m - BMI formula with respect to height and weight is defined -...
Read more

Qr Code Generator using python

Image
Hello dudes! Inaiku nama paka pora topic uh " How to generate qr code using python " Qr code uh dhna da.. Online leh panikalamae Idhuku yenn daaw Python program lam nu neenga kepeenga aanal.. Nama local system leh generator panradhu comparatively safe and secure la boss!! Language : Python IDE used : Pycharm Pre-requisites : Indha particular program kaga rendu module nama install pananum guys and gals that's. 1. pyqrcode : This is the module responsible for generating qr code. 2. pypng : This module is used to print output as png file Indha rendu modules  aiyum neenga install panradhuku.. Vunga IDE oda Terminal Tab la jus  pip install pyqrcode pip install pypng  Nu type pani enter pana matum podhum meedhi elam Python pathupan 😝 Code : Pyqrcode and pypng modules Ah install panitu indha code ah neenga run pani patheenga na.. Neenga work panra file directory laiye vunga qr code generator agirkum!  Engaluku vandha Output!  So ve...
Read more