How to Increase Font or Display Size of a Recovered Excel File in WPS Office
Question details
The user wants to enlarge the font or display size of a recovered Excel file and needs to know how to do it depending on whether the recovered content contains editable spreadsheet cells, an inserted image, or a PDF.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A recovered Excel file appears with small text or display size, and the user wants to enlarge it for readability or editing.
- Observed behavior
- Recovered files may contain editable spreadsheet cells, a static image, or PDF-like content; only editable cell text can be directly enlarged from the Home tab.
Open the recovered file in WPS Office Spreadsheets and click the text. If a cell cursor appears and the formula bar shows the text, use the font-size method; if the content behaves like a static image or PDF, use the image/PDF method.
Increase the Font Size of Editable Excel Cells in a Recovered File
Use this when the recovered file contains selectable spreadsheet cells and you need larger text in the cells.
Recovered Excel files often retain editable worksheet cells. Increasing the font size changes the actual cell formatting, which is the most direct fix when text is too small.
Open the recovered file in WPS Office Spreadsheets, click the first cell or drag across the target range that contains the small text.
Click the Home tab on the ribbon to display font and formatting controls.
In the Font group, click the Font Size drop-down or the Increase Font Size button, then choose a larger number such as 12 or 14.
If the cell text appears unchanged, double-click the cell or place the cursor in the formula bar to confirm the cell is editable, then repeat the font change.
Adjust Worksheet Zoom to Enlarge the Display Without Editing Fonts
Use this when you only need a larger on-screen view and do not want to modify cell formatting.
Handle a Recovered File That Contains an Image or PDF
Use this when the recovered Excel file inserts the content as a picture or PDF and the text cannot be selected as cells.
Enlarge Recovered Excel Text and Display Size with WPS Office Spreadsheets
Open your recovered Excel file in WPS Office Spreadsheets, select the worksheet cells, and use the Home tab font controls or View tab zoom tools to make small text readable. For image or PDF content, open the source file in WPS Office or WPS PDF, correct the text size, and reinsert it into a new spreadsheet.
- 1. Open the recovered file: Launch WPS Office Spreadsheets and open the recovered Excel workbook from File > Open.
- 2. Select editable cells: Click or drag to select the cells whose text needs to be enlarged.
- 3. Increase font size: Click Home, then use the Font Size drop-down or Increase Font Size button to apply a larger size.
- 4. Zoom for display-only changes: Click View > Zoom or drag the bottom-right zoom slider to enlarge the worksheet display without changing cell formatting.
- 5. Handle image or PDF content: If the content is not selectable as cells, resize the object or edit the source in WPS Office Writer/WPS PDF and insert the corrected version.
Frequently Asked Questions
Why can’t I select the text in my recovered Excel file?
If the recovered content was inserted as a picture or PDF page, it behaves as a single object rather than editable cells. Click it; if no cell cursor appears, resize the object or edit the original file in WPS Office Writer or WPS PDF.
How do I zoom in on a recovered Excel worksheet in WPS Office?
Open the file in WPS Office Spreadsheets, click the View tab, and choose Zoom or use the zoom slider in the bottom-right corner. You can set 125%, 150%, or another percentage.
Does increasing the zoom change the printed font size?
No. Zoom only changes the on-screen display size. To make printed text larger, select the cells and increase the font size from the Home tab.
Can WPS Office enlarge text inside a scanned PDF that was recovered as an Excel file?
Not as cell text. A scanned PDF is an image, so WPS Spreadsheets cannot edit the underlying text. Open the PDF in WPS Office or WPS PDF tools; if it is scanned, you may need OCR or image-quality improvement before inserting it back.
What is the fastest way to enlarge all editable cells in a recovered Excel sheet?
Press Ctrl+A to select the entire sheet, click Home > Increase Font Size, or choose a larger number from the Font Size drop-down. Be aware that this may affect layout in cells with wrapped text or merged cells.
