Excel & PDF guides

Read the examples and limitations before working with your own files.

How to merge Excel files with different column orders

Combine XLSX or CSV files by header name, choose a sheet, and trace source rows. A worked example explains column order and formatting limits.

Find duplicate IDs and missing names, then use Data and Review sheets to trace the original rows. Includes a concrete example.

Choose UTF-8 or CP949 to read Korean CSV text and convert it to XLSX. Learn about delimiters, leading zeros, and exporting a selected sheet.

Merge a cover and a main PDF, check document order and page counts, and understand encryption, signature, and form limitations.

Use a 3,1-2 page range to move page 3 to the front and save selected pages. Learn how exclusion, repeated page numbers, and rotation work.

Combine receipt photos into one PDF, set image order and A4 margins, or keep original proportions. Learn the difference between image PDFs and OCR.