Fix Text Alignment and Cell Formatting in a Microsoft Excel Invoice Template
Question details
The user needs to align text copied from Notes into an Excel invoice template and remove unwanted lines or formatting from cells and exported PDFs.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Copying invoice content from Notes into a Microsoft invoice template and exporting the completed worksheet as a PDF.
- Observed behavior
- Pasted text appears misaligned, and unwanted lines or formatting appear in invoice cells and the exported PDF.
Identify the invoice template and select the affected cells to check whether they are merged or use Wrap Text. Compare the worksheet with File > Print preview to see whether the unwanted lines also appear in the PDF output.
Paste Plain Text and Adjust Invoice Cell Alignment
Use this approach when text copied from Notes does not align with the invoice template.
Select the invoice cells and check Home > Alignment for Merge & Center and Wrap Text. If cells are merged, select the merged area before entering text.
Copy the text from Notes, select the target cell in Excel, and open Home > Paste > Paste Special. Choose a plain-text option such as Text or Unicode Text if available.
Enter each invoice item, description, or value in its intended worksheet cell. To keep multiline text within one cell, double-click the cell and paste into the cell's editing area.
Select the affected cells and use Home > Alignment to set horizontal and vertical alignment and turn Wrap Text on or off. Adjust column widths or row heights by dragging the column or row boundaries.

Remove Unwanted Invoice Lines and Check PDF Print Settings
Use this approach when extra lines or formatting appear in invoice cells or in the exported PDF.
Format and Export Your Invoice in WPS Spreadsheets
Open the invoice in WPS Spreadsheets, adjust cell alignment and borders, and preview the result before exporting it to PDF.
- 1. Open the invoice: Launch WPS Office, choose Open, and select the Excel invoice template.
- 2. Enter invoice text: Select the appropriate worksheet cell and paste or type each invoice entry. Use a plain-text paste option if available to avoid bringing in source formatting.
- 3. Adjust the layout: Select the affected cells and use the Home tab's alignment, Wrap Text, and Borders controls to correct the invoice layout.
- 4. Preview and export: Open Print Preview to check the invoice, then use the PDF export option to create the final file.

Frequently Asked Questions
Why does text pasted from Notes look misaligned in my invoice?
The target cells may have different alignment, wrapping, or merged-cell settings. Select them and check Home > Alignment, then paste using a plain-text option if available.
How do I remove lines from invoice cells without removing the text?
Select the affected cells and choose Home > Borders > No Border. This removes their borders without deleting cell contents; reapply any borders the invoice needs.
Why do lines appear in the PDF even though I do not want gridlines?
Check Page Layout > Sheet Options > Gridlines and clear Print. If lines remain in File > Print preview, they may be cell borders rather than gridlines.
Can conditional formatting add unwanted lines or other formatting?
Yes. Select the affected cells and open Home > Conditional Formatting > Manage Rules to inspect and edit or remove rules that apply unwanted formatting.




