CARA MENGHAPUS TULISAN DI EXCEL

Have you ever had to remove unwanted text or watermark from a photo, video, or document but didn’t know how? It can be frustrating and time-consuming to try and erase it manually. Luckily, there are several ways to quickly and easily remove text or watermark from different types of files. In this article, we will walk you through the steps for removing text or watermark from Excel, photo, PDF, and video files.

Removing Text from Excel

If you want to remove text from an Excel file, you have several options. Here are the steps:

Option 1: Clearing the Text

To clear the text from a specific cell, you can simply select the cell and press the delete key, or right-click on the cell and select “Clear Contents” from the context menu. If you want to clear the text from multiple cells, select the cells you want to clear, and then repeat the steps above.

However, if you want to clear all the text from the entire worksheet, you can use the “Select All” feature. Here’s how:

1. Click on the rectangle at the top-left corner of the worksheet to select all cells.
2. Press the delete key or right-click and select “Clear Contents” to remove the text.

Option 2: Removing Gridlines and Headings

If you want to remove the gridlines and headings from the worksheet to create a cleaner look, you can use the “Hide” feature. Here’s how:

1. Click on the “View” tab on the ribbon.
2. Check or uncheck the “Gridlines” and “Headings” boxes in the “Show” group to turn them on or off.

Removing Watermark from a Photo

Removing a watermark from a photo can be more challenging than removing text from an Excel file, but there are still several ways to do it. Here are the steps:

Option 1: Using an Online Watermark Remover

There are several online tools that allow you to remove watermarks from photos for free. One popular option is Inpaint. Here’s how to use it:

1. Upload your photo to Inpaint’s website by clicking “Upload Image” or by dragging and dropping the photo onto the webpage.
2. Use the “Marker” tool to select the watermark by drawing a line around it.
3. Click the “Erase” button to remove the watermark.
4. Download the edited photo by clicking “Download” or “Save”.

Option 2: Using Adobe Photoshop

If you have Adobe Photoshop, you can use the Clone Stamp tool to remove the watermark from your photo. Here’s how:

1. Open your photo in Photoshop.
2. Select the Clone Stamp tool from the toolbar on the left.
3. Choose a brush size that’s slightly larger than the watermark.
4. Hold down the Alt key and click on an area of the photo that’s similar to the watermark.
5. Release the Alt key and click and drag over the watermark to clone the surrounding pixels and cover it up.
6. Repeat steps 4 and 5 until the watermark is completely covered.
7. Save your edited photo by clicking “File” > “Save As”.

Removing Text from PDF

If you want to remove text from a PDF file, you can either edit the PDF directly or convert it to a Word document for easier editing. Here are the steps:

Option 1: Editing PDF Directly

If you have Adobe Acrobat DC, you can edit the text directly on the PDF. Here’s how:

1. Open your PDF in Adobe Acrobat DC.
2. Click the “Edit PDF” tool in the right-hand pane.
3. Select the text you want to remove.
4. Press the delete key or right-click and select “Delete” from the context menu.
5. Save your edited PDF by clicking “File” > “Save”.

Option 2: Converting PDF to Word

If you don’t have Adobe Acrobat DC, you can use an online converter tool such as Smallpdf. Here’s how:

1. Upload your PDF to Smallpdf’s website by clicking “Choose File” or by dragging and dropping the PDF onto the webpage.
2. Wait for the PDF to convert to a Word document.
3. Open the converted Word document in Microsoft Word.
4. Select the text you want to remove.
5. Press the delete key or right-click and select “Delete” from the context menu.
6. Save your edited Word document by clicking “File” > “Save”.
7. Convert the Word document back to a PDF using Smallpdf’s PDF converter tool if necessary.

Removing Text from Video

Removing text from a video can be a bit tricky, but it’s possible with the right tools. Here’s how:

Option 1: Using Adobe Premiere Pro

If you have Adobe Premiere Pro, you can use the “Track Matte Key” effect to remove text from a video. Here’s how:

1. Open your video in Adobe Premiere Pro.
2. Drag the “Track Matte Key” effect from the “Effects” panel onto the video clip with the text.
3. Click the “Eyedropper” tool next to the “Matte” option in the effect controls.
4. Select a neutral background color from the video using the eyedropper.
5. Adjust the “Matte Generation” and “Matte Cleanup” options until the text is removed.
6. Save your edited video by clicking “File” > “Export”.

Option 2: Using iMovie on Mac

If you’re on a Mac, you can use iMovie to remove text from a video. Here’s how:

1. Open your video in iMovie.
2. Select the clip with the text.
3. Click the “Clip Filter and Audio Effects” button in the top-right corner of the viewer.
4. Select “Crop to Fit” from the pop-up menu.
5. Drag the “Crop” sliders to remove the text.
6. Save your edited video by clicking “File” > “Share” > “File”.

FAQ

Here are some frequently asked questions about removing text and watermarks:

1. Can I remove a watermark from a video without losing quality?

It depends on the quality of the original video and the method you use to remove the watermark. If you use a high-quality video editor like Adobe Premiere Pro and follow the steps correctly, you should be able to remove the watermark without losing much quality. However, if you use a lower-quality tool, the video may become pixelated or blurry.

2. Is it legal to remove watermarks from photos or videos?

It depends on the context. If you’re removing a watermark from a photo or video that you own and plan to use for personal use or non-commercial purposes, it may be legal. However, if you’re removing a watermark from someone else’s content or plan to use the edited photo or video for commercial purposes, it may be illegal. It’s important to check the copyright laws in your country and make sure you have permission to use the content before removing watermarks.

Video Tutorial

Still not sure how to remove text or watermarks from your files? Check out this video tutorial for more tips and tricks: