CARA COPY PASTE DI EXCEL TANPA MERUBAH FORMAT

Copying and pasting in Microsoft Word and Excel is something that we do on a daily basis, but did you know that it can sometimes mess up the formatting and formulas? In this article, we will explore some tips and tricks to help you copy and paste without altering the format or formula.

Cara Copy Paste Word & Rumus Excel Tanpa Merubah Format

One of the most common issues when copying and pasting in Word is the loss of formatting. Here are two ways to copy and paste without losing any formatting:

1. Use “Paste Special”

Instead of using the regular copy and paste function, try using “Paste special”. This allows you to select the specific format that you want to copy. Here’s how to do it:

  1. Select the text that you want to copy.
  2. Go to “Edit” and select “Copy” or use the keyboard shortcut “Ctrl + C”.
  3. Place your cursor where you want to paste the text.
  4. Go to “Edit” and select “Paste Special” or use the keyboard shortcut “Ctrl + Alt + V”.
  5. In the “Paste Special” window, select the format that you want to use and click “OK”.
Baca Juga :  Cara Membuat Raport K13 2018 Revisi Menggunakan Excel Bagas Tutorial

By doing this, you can copy just the text, without any formatting, or choose to copy the formatting without the text.

2. Use “Keep Text Only”

If you want to copy and paste text without any formatting, you can use the “Keep Text Only” function. This will strip all formatting from the text and paste only the plain text. Here’s how to do it:

  1. Select the text that you want to copy.
  2. Go to “Edit” and select “Copy” or use the keyboard shortcut “Ctrl + C”.
  3. Place your cursor where you want to paste the text.
  4. Go to “Edit” and select “Paste” or use the keyboard shortcut “Ctrl + V”.
  5. In the pop-up menu, select “Keep Text Only”.

This will remove all formatting from the text and paste it as plain text.

Cara Copy Paste Di Excel Tanpa Merubah Format

Copying and pasting in Excel can be tricky, especially when you have formulas and formatting. Here’s how to copy and paste without changing the formula or format:

1. Use “Paste Special”

Similar to Word, you can use “Paste special” function in Excel to select the format or formula that you want to copy. Here’s how to do it:

  1. Select the cell(s) that you want to copy.
  2. Go to “Edit” and select “Copy” or use the keyboard shortcut “Ctrl + C”.
  3. Place your cursor where you want to paste the cells.
  4. Go to “Edit” and select “Paste Special” or use the keyboard shortcut “Ctrl + Alt + V”.
  5. In the “Paste Special” window, select the format or formula that you want to use and click “OK”.
Baca Juga :  CARA MEMBUAT SINGKATAN DALAM EXCEL

By doing this, you can copy just the formula, without any formatting, or choose to copy the formatting without the formula.

2. Use “Paste Link”

If you want to link the copied cells to the original cells, you can use the “Paste Link” function. This will ensure that any changes made to the original cells are automatically reflected in the pasted cells. Here’s how to do it:

  1. Select the cell(s) that you want to copy.
  2. Go to “Edit” and select “Copy” or use the keyboard shortcut “Ctrl + C”.
  3. Place your cursor where you want to paste the cells.
  4. Go to “Edit” and select “Paste Link”.

Now, any changes made to the original cells will be reflected in the pasted cells, without changing the formula or format.

FAQ

1. Is it possible to copy and paste images in Word or Excel without losing the formatting?

Yes, it is possible to copy and paste images without losing the formatting. Here’s how to do it:

  1. Select the image that you want to copy.
  2. Go to “Edit” and select “Copy” or use the keyboard shortcut “Ctrl + C”.
  3. Place your cursor where you want to paste the image.
  4. Go to “Edit” and select “Paste” or use the keyboard shortcut “Ctrl + V”.
  5. If the formatting still changes, right-click on the image and select “Format Picture”. In the “Format Picture” window, select “Layout and Properties” and then “Position”. Under “Position”, select “In Line with Text”.

This will ensure that the image is pasted with the correct formatting.

Baca Juga :  CARA BUKA FILE MEMAKAI EXCEL ONLINE

2. How can I paste a large table in Word without losing the formatting?

If you have a large table in Excel that you want to copy and paste into Word, the best way to do it without losing the formatting is to use ” Paste Special” function. Here’s how:

  1. Select the entire table that you want to copy.
  2. Go to “Edit” and select “Copy” or use the keyboard shortcut “Ctrl + C”.
  3. Place your cursor where you want to paste the table in Word.
  4. Go to “Edit” and select “Paste Special” or use the keyboard shortcut “Ctrl + Alt + V”.
  5. In the “Paste Special” window, select “Microsoft Office Excel Worksheet Object” and click “OK”.

This will paste the table as an Excel object in Word, allowing you to edit the table without losing any formatting or formulas.

Video Tutorial: Cara Copy Paste di Microsoft Excel Tanpa Merubah Rumus dan Format

For those who prefer to learn visually, here’s a video tutorial on how to copy and paste in Excel without changing the formula or format: