# How to edit XLSX spreadsheets on Android

A practical guide to editing XLSX spreadsheets on Android, including cells, sheets, formatting, formulas and workbook search.

## Quick answer
A practical guide to editing XLSX spreadsheets on Android, including cells, sheets, formatting, formulas and workbook search.

Spreadsheet editing on a phone works best when the app keeps the familiar ideas of cells, formulas and sheets but adapts them to a smaller screen.

## 1. Open the workbook and choose the right sheet
XLSX files can contain multiple sheets, so confirm you are working in the correct tab before changing values.

## 2. Select a cell and edit its value or formula
A formula bar makes it easier to see and change the raw cell contents, especially when a displayed value is the result of a calculation.

## 3. Apply formatting only where it helps
Bold, italic, underline, alignment, text colour, fill colour and number formats such as currency, percentage and date can make a small workbook much easier to read.

## 4. Use workbook search for larger files
Search can save a lot of scrolling when you need to locate a particular value, label or entry.

## 5. Save and re-check calculated cells
After changing formulas or source values, check the important results before sharing the edited workbook.

## Common mistakes to avoid
- Typing over a formula when you only meant to change an input value
- Editing the wrong sheet in a multi-sheet workbook
- Using text formatting where a number/date format is more appropriate
- Saving over the only copy before checking important calculations

## Common questions
### Can I edit XLSX formulas on Android?
Yes. OfficeForge includes a formula bar and supports common calculations including SUM, AVERAGE, MIN, MAX, COUNT and IF.

### Can I change spreadsheet formatting on Android?
Yes. OfficeForge supports common cell styles, alignment, colours and number formats such as currency, percentage and date.

### Can I search an XLSX workbook?
Yes. OfficeForge includes workbook search to help locate values across the spreadsheet.

## Related Trefnio product
OfficeForge
- Product page: https://trefnio.co.uk/apps/officeforge/
- Status: In development; submitted to Google Play for review before testing.
