Auto fit Column Command in Excel Skip to main content

Auto fit Column Command in Excel

 

    In Microsoft Excel, some commands are very useful for data formatting. With the help of these commands, our work should be interesting and more smartly effective. If you have an Excel workbook with different column sizes like the below picture.  Such kind of Excel worksheet is not impressive for your presentations.  Here is the solution for fixing the column size as per the content size. 



If you want to fit the column size as the column content size, do it manually or do it smartly just single command. So let's do it smartly.

Right-click on the sheet1 button and select the view code. As below picture.


A popup window appears. Click on General and select the Worksheet and type the command  “Cells.EntireColumn.Autofit” between Private Sub and End Sub. As below picture.



Minimize the window and your sheet is auto-fit according to column content size. As in the below picture.



Now your Excel worksheet is very impressive and effective.

Labels:

Comments

Post a Comment

Popular posts from this blog

How to file a Appeal under the section 41 of Consumer Protection Act 2019 through Edaakhil "https://edaakhil.nic.in" web portal ?

       Consumers can file their Appeal against the impugned order passed by the lower Consumer Commission under section 41 of the Consumer Protection Act 2019, only through E-filing  " https://edaakhil.nic.in "  in their respective State Consumer Disputes Redressal Commission in short “SCDRC” or in National Consumer Disputes Redressal Commission in short “NCDRC”.            Appeal filing process is very simple as I explained in my previous post Consumer Complaint through E-daakhil . You can click on this link for more details. In this post, I explain the process of filing of Appeal through the Edaakhil web portal.           There are bullet points for filling the Appeal through the Edaakhil web portal, which is as below. Login to the Edaakhil portal under the Consumer/Advocate Section tab, If you visiting Edaakhil web portal for the first time, then register them self as I explain in my p...
2 comments
Read more

How to file a Consumer Complaints through Edaakhil web portal "https://edaakhil.nic.in"?

     Department of Consumer Affairs, Government of India, provides the facility to file a Consumer Complaint through online mode with the help of the web portal https://edaakhil.nic.in . Web portal developed under the Consumer Protection Act 2019 with the help National Informatics Centre (NIC), New Delhi. The main purpose of the web portal is to increase the timely and effective redressal of consumer complaints.        In this post, we learn how to file a Consumer Complaint with the help of the edaakhil web portal. Consumers registered themselves and activated the account before filing their complaints. Once your registration is done, then login to the web portal with your login credential. A welcome page will appear.      Click on filing a new case under the Filling menu. Then click on the Consumer Case (CC) button and enter the disputed amount. (Up to Rs. 5 Lacs court fee is nill) .      Click on  the Consumer Case ...
2 comments
Read more