Posts

How to Remove Active Email Links in Excel

Image
So there are times when we get an Excel file containing email data, the email link is active, the one marked with the email is blue. Actually it's good if the email link is active so we can easily connect with the email, but it will be annoying if we accidentally click on it. To remove active links in email writing, the method is very easy. Friends can immediately right-click on the mouse in an active email link, then friends select "Remove hyperlink". After that, the link contained in the email will automatically disappear and the email will become plain text.

How to Change Lowercase to Uppercase at the Beginning of a Sentence in Word

Image
Now there are times when we type an article in Word, we forget to capitalize the letters at the beginning of the sentence. Because it is a stipulation in writing that at the beginning of a sentence after it is closed with a period, the letter must be uppercase, so we have to edit it again one by one to make it uppercase. However, you don't need to edit one by one if you forget to change the letters at the beginning of the sentence to uppercase, because we can change them automatically. The method is very easy, select all text or type which will change the first letter of the sentence to uppercase. Then on the " Home " menu, click " Change Case " with the " Aa " icon. After that several options will appear, friends, select the top one, namely " Sentence Case ", automatically after friends click, the letters in each sentence in the selected writing will change to uppercase. More Tutorials: How to Make Big Curly Brackets in Word Ho...

How to Convert Excel to PDF Nicely

Image
Maybe friends are confused when converting an Excel file to a PDF file, the result is a mess where some of the contents are cut off so it's not very good to look at. Now to make an Excel file that is converted to a PDF file not messy anymore, the method is very easy. We only need to set it on the Page Layout Menu, the first thing we do is determine the paper size that we will use, try to make sure that all the data that we are going to convert into PDF files must all fit on one paper size. Friends can see whether there is data that is truncated or not in Print Preview. If there is missing data, friends can adjust the width of the column or row or you can also adjust the size of the writing to be reduced or enlarged. So, if the existing data can't fit if it's in a Portrait or elongated shape, you can change it to a Landscape or widened shape so that the data that we're going to convert to PDF isn't truncated anymore. If friends feel that the Excel data is ready to be...

How to Rotate Text In a Table in Microsoft Word

Image
Now, usually the table column headings that we make will be very long compared to usual and we can no longer shorten them. For this reason, the best step we can take is to rotate the text contained in the table. Rotating here is directing the writing to be vertical or perpendicular. Now to make writing in the Word table vertical, the method is very easy. Select or select the text that we will rotate, then enter the "Layout" menu, after that select "Text Direction". So immediately the text that we selected earlier will rotate to be perpendicular or vertical. More Tutorials: How to Make Big Curly Brackets in Word How to Delete Page Number in Specific Page How to Set Password for Word Document 2007 How to Divide Into 4 Microsoft Word How to Remove Red Underline in Word