Boosturtech

       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.

     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 ...

We can convert a PDF file, Picture (JPEG) to an editable Word Document. Insert your picture through the insert button in MS Word. 2.  Click on the format button in MS Word and select the in front of text option under the Wrap Text button. 3. After that click on the Correction button under the Format menu & select the Picture Correction Option.  Then a pop up sidebar of picture correction appears, & edit your picture brightness and sharpness according to the source file. 4. Save the Edited picture as a PDF format on the desktop and close the word file. 5. Open a fresh MS Word file Click on View menu then select the Outline option. 6. After that click on show document and select the Insert option. 7. Select the recently save pdf file  and open it. 8. Press the Ok button on Word notification. 9. Close the Outline view, Your file is converted as editable text.   

Microsoft Word software provides so many features for the users. One of those features spelling and grammar checks is the best features. But some users didn't know how to enable the spelling and grammar check feature. In this post, I'll show you how to enable and use it. Sometimes, when we are typing a letter/application in MS Word, We notice that MS Word didn't show the spelling mistake of your typed work. That means the spelling checker function is disabled in  MS Word. In this situation, We need to enable the spelling checker function in your MS Word to show and correct spelling mistakes.   But the question is, how to fix the issue?? Here is the solution, and follow the following steps. First click on the FILE button which is placed on the left-hand side top corner.   File menu appears. Then click on the Options button. Word Options pop-up window appears, which shows the General, Display, Save, Language, Advanced, etc. Then click on the Proofing button, which...

Toady's topic is very important for all tech users in their daily life. Writing an effective email is very important in this technological era.  Here are some tips and tricks for writing an effective & impressive email. Clear Subject Line Your subject line should give a brief overview of the email's content. Avoid obscure subjects and give enough information to encourage the recipient to read the email. Start with Greeting Start your email with a polite and appropriate greeting. Address the recipient by their name ( if possible) or  "Dear Sir/Madam"/ "Dear [Name] ". Introduction In the opening paragraph, briefly introduce yourself and state the purpose of the email.   Clear and Well- Structure Body Break your email into paragraphs. Avoid long- winded explanations and focus the mail point you want to convey. Be Polite and Positive   Use polite language and a positive tone throughout the email. Clearly state what action you want from the recipient to take ...

        Quick Response Keys. (Short Cut Keys)   Shortcut keys are very useful in our daily computer related work.  With the help of these keys, our work efficiency will be increased.   General Shortcuts:- Windows Key: Open or close the Start Menu. Windows Key + D: Show or hide the desktop. Windows Key + E: Open File Explorer (Windows Explorer). Windows Key + L: Lock the computer and switch to the lock screen. Windows Key + R: Open the Run dialog box. Windows Key + I: Open the Windows Settings. Windows Key + Tab: Activate Task View to see all open windows and virtual desktops. Windows Key + A: Open the Action Center to view notifications and quick actions. Windows Key + S: Open the Search bar. Screenshot Shortcut Key:- PrtScn: Takes a screenshot and saves it to the clipboard. You can paste it in an image editor (e.g., Paint) to save it.  Win + PrtScn: Takes a screenshot and saves it to the "Screenshots" folder in the "Pi...