CARA MEMISAHKAN FILE KE SHEET LAIN DI EXCEL SUAI KELAS

Excel is a software that is widely used by everyone, both in large companies or just for personal use. In Excel, we can create various kinds of tables, charts, and formulas. One issue that is often faced by Excel users is how to separate or split an Excel sheet into separate sheets. In this article, we will discuss the steps to separate Excel sheets into separate files easily, with images and step-by-step instructions.

CARA MEMISAHKAN FILE KE SHEET LAIN DI EXCEL SUAI KELASCara Memisahkan Banyak Sheet di Excel Menjadi Excel Terpisah

First, open the Excel file that you want to split into separate sheets. In this example, we will use an Excel file that contains data from a sales report. The Excel file has three sheets: Sales Report, Regional Sales, and Product Sales. We will separate these sheets into separate files.

  1. First, go to the sheet that you want to separate into a separate file. In this example, we will separate the Sales Report sheet.
  2. Right-click on the sheet that you want to separate. A drop-down menu will appear.
  3. Select Move or Copy… from the drop-down menu. The Move or Copy dialog box will appear.
  4. In the Move or Copy dialog box, select New book from the To book dropdown list. This will create a new Excel file with only the selected sheet.
  5. Make sure that the Create a copy checkbox is unchecked. This will ensure that the selected sheet is moved to the new file instead of creating a copy of the sheet.
  6. Click OK. The selected sheet will be moved to a new Excel file.
  7. Save the new Excel file with a name that is different from the original file. For example, if the original Excel file is named Sales Report.xlsx, you can name the new Excel file Sales Report – Sheet1.xlsx.
  8. Repeat the above steps for the other sheets that you want to separate into separate files.
Baca Juga :  CARA MEMISAHKAN FILE EXCEL YG SEDANG DIBUKA

Now, you have successfully separated an Excel sheet into a separate file. Repeat the above steps for the other sheets that you want to separate into separate files.

tutorial imageCara Memisahkan Sheet di Excel Menjadi File Lain

If you want to separate all sheets in an Excel file into separate files, you can use this method:

  1. First, open the Excel file that you want to split into separate files.
  2. Press ALT + F11 to open the Visual Basic Editor.
  3. In the Visual Basic Editor, go to Insert -> Module to create a new module.
  4. Paste the following code in the new module:
  5. Sub SplitSheets()
    Dim ws As Worksheet
    Application.ScreenUpdating = False
    For Each ws In ActiveWorkbook.Worksheets
        ws.Copy
        ActiveWorkbook.SaveAs Filename:=ws.Name & ".xlsx", FileFormat:=xlOpenXMLWorkbook
        ActiveWorkbook.Close SaveChanges:=False
    Next
    Application.ScreenUpdating = True
    End Sub
      
  6. Press F5 to run the macro. This will create separate Excel files for each sheet in the original file.
  7. All of the new Excel files will be saved in the same folder as the original file.
  8. Close the Visual Basic Editor and return to the Excel file.

Now, you have successfully separated all sheets in an Excel file into separate files. This method is useful if you have many sheets and do not want to separate them all manually.

tutorial imageCara Memisahkan Sheet di Excel Menjadi File Lain – Sobat-Tutorial

If you prefer to use a third-party tool, there are several software options that can help you easily separate Excel sheets into separate files. One of them is Kutools for Excel.

  1. First, install Kutools for Excel on your computer. You can download it from the official website.
  2. Open the Excel file that you want to split into separate files.
  3. Go to Kutools > Worksheet > Split Workbook.
  4. In the Split Workbook dialog box, select the sheets that you want to split into separate files. You can also choose to split the sheets by a specific number of rows or columns.
  5. Select the location where you want to save the new Excel files. You can choose to save them in the same folder as the original file or in a new folder.
  6. Click OK. Kutools for Excel will automatically create separate Excel files for each selected sheet.
Baca Juga :  Cara Menghitung Moving Average Batas Atas Batas Bawah Di Excel

Now, you have successfully separated Excel sheets into separate files using Kutools for Excel. This software is easy to use and can save you a lot of time if you need to split many sheets into separate files.

tutorial imageCara Memisahkan File PDF dengan Mudah secara Online ataupun Offline

If you need to split a PDF file into separate pages, you can use various online tools or software. One of the online tools that you can use is SmallPDF.

  1. First, go to the SmallPDF website. (https://smallpdf.com/split-pdf)
  2. Click Choose File to select the PDF file that you want to split.
  3. Select the pages that you want to split. You can choose to split all pages or select specific pages.
  4. Click Split PDF. SmallPDF will automatically split the selected pages into separate PDF files.
  5. Download the new PDF files or save them to cloud storage.

You can also use Adobe Acrobat to split a PDF file into separate pages. Here are the steps:

  1. First, open the PDF file that you want to split in Adobe Acrobat.
  2. Go to View -> Tools -> Pages.
  3. In the Pages panel, select Split Document.
  4. In the Split Document dialog box, select the pages that you want to split into separate files. You can choose to split them into a single-page PDF or multiple-page PDF files.
  5. Specify the location where you want to save the new PDF files.
  6. Click OK. Adobe Acrobat will automatically split the selected pages into separate PDF files.

FAQ

Q: Can I split Excel sheets into separate files without using a third-party tool?

Baca Juga :  Cara Menambahkan Cell Didata Yang Banyak Pada Excel

A: Yes, you can use the Move or Copy function in Excel to split Excel sheets into separate files. This method is suitable if you only have a few sheets to split. If you have many sheets, it may be faster to use a third-party tool.

Q: Can I split a PDF file into separate pages using Adobe Acrobat?

A: Yes, you can use Adobe Acrobat to split a PDF file into separate pages. The steps are relatively easy, and you can choose to split the pages into a single-page PDF or multiple-page PDF files.

Video Tutorial

Watch this video tutorial for a step-by-step guide on how to split Excel sheets into separate files: