Fix Excel Mobile Not Filling Series Across Blank Cells
Question details
The user needs to fill gaps in a daily or numeric data series across blank cells within the Excel Mobile app.
- Product
- Excel Mobile
- Device & OS
- not provided
- Scenario
- Attempting to select a range of cells with missing data and automatically fill the series pattern, similar to the desktop experience.
- Observed behavior
- The standard "Fill > Series" command found in Excel for Windows is missing in Excel Mobile, preventing the user from automatically filling data gaps.
Verify that your Excel Mobile app is updated to the latest version, and note the pattern of your data (e.g., daily dates or sequential numbers) before applying a workaround.
Use a Formula to Generate Missing Series Values
Since the dedicated "Fill Series" dialog is unavailable on mobile devices, using a simple addition formula is the best way to bridge gaps in your data.
This method works perfectly for continuous numeric sequences or daily date series by simply adding 1 to the previous cell's value.
Tap on the first empty cell immediately following the last entered data point in your series.
Type the equals sign (=), tap the cell directly above it, and type '+1' (for example, =A2+1).
Tap the checkmark icon on the formula bar or press Enter on your mobile keyboard to apply the calculation.
Tap the cell containing your new formula, select 'Fill' from the pop-up context menu, and drag the square handle down over the remaining blank cells to complete the series.
Open the Workbook in Excel for Windows
If you have a large dataset with complex gaps, switching to the desktop version allows you to use the native Fill Series feature.
Switch to WPS Office for a Feature-Rich Mobile Spreadsheet Experience
If you are frustrated by missing features in your current mobile spreadsheet app, WPS Office provides a lightweight, highly compatible, and powerful suite for both mobile and desktop. Enjoy advanced data entry tools without the limitations.
- 1. Install WPS Office: Download and install the free WPS Office app from the Google Play Store or Apple App Store.
- 2. Open your Excel file: Launch WPS Office and open your existing .xlsx workbook directly—no format conversion required.
- 3. Edit your spreadsheets on the go: Use the intuitive mobile interface to access rich spreadsheet features, including drag-to-fill and advanced formulas.
Frequently Asked Questions
Why is the Fill Series command missing in Excel Mobile?
Excel Mobile is designed to be a streamlined, touch-friendly version of the desktop software. To keep the app lightweight and easy to navigate on small screens, some advanced data manipulation tools like the "Fill Series" dialog are excluded.
Can I use basic autofill for dates in Excel Mobile?
Yes. You can use the standard Fill handle for continuous data. Tap a cell containing a date, select 'Fill' from the pop-up menu, and drag the highlighted box down or across to continue the basic date pattern.
Does Excel for the Web have the Fill Series command?
Excel for the Web offers basic autofill capabilities similar to the mobile app, but the comprehensive 'Fill > Series' dialog box for complex step values and customized blank cell filling requires the full desktop version of Microsoft Excel.
