Formatting Issues

Fix Text Alignment and Cell Formatting in a Microsoft Excel Invoice Template

Ayan MasoodAyan Masood Nov 18, 2026 871 views

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.

Fix Text Alignment and Cell Formatting in a Microsoft Excel Invoice Template
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.
Before you start

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.

Solution 1Recommended

Paste Plain Text and Adjust Invoice Cell Alignment

Use this approach when text copied from Notes does not align with the invoice template.

1
Inspect the target cells

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.

2
Paste without source formatting

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.

3
Place entries in separate cells

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.

4
Set alignment and sizing

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.

Paste Plain Text and Adjust Invoice Cell Alignment
Merged cells can affect layout: Merged cells may make text alignment and row-height adjustments less predictable. Check the template layout before unmerging cells.
Edit invoices with WPS Office

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. 1. Open the invoice: Launch WPS Office, choose Open, and select the Excel invoice template.
  2. 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. 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. 4. Preview and export: Open Print Preview to check the invoice, then use the PDF export option to create the final file.
Adjust invoice text alignment, wrapping, and cell bordersOpen and edit Microsoft Excel XLSX and XLS filesPreview the invoice before exporting to PDFUse a familiar spreadsheet interface
microsoft office alternative - wps office

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.