Excel Table Cards for smartphones

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Excel for iPhone and Android smartphones have a useful extension of Excel Tables called Cards.  It’s a better way to view tables on a smaller screen with larger text and easier editing.

Instead of scrolling right/left on the small screen, all the info for a single table row can be seen and edited as a Card.  New cards (rows) can be added, or rows/cards deleted.

Excel Table Cards for smartphones - Excel Table Cards for smartphones

Each Table Card is a row in an Excel table.

Enter Table Cards

Select inside any Excel Table then choose the Cards icon on the bottom row.

Excel Table Cards for smartphones 1 - Excel Table Cards for smartphones

That opens the main Card view with the first few table columns visible.

Excel Table Cards for smartphones 2 - Excel Table Cards for smartphones

Scroll up/down to see more cards/rows.

+  add a new table row / card.

Find – finds any rows/cards with matching text. The search is not case-sensitive and finds partial matches.  The number of cards/rows is discreetly show at right.

Excel Table Cards for smartphones 3 - Excel Table Cards for smartphones

All the card details

Tap on any small card to open up the full card details, in other words all the columns in that row.

Excel Table Cards for smartphones 4 - Excel Table Cards for smartphones

Text fields (cells) can be edited (or selected and copied).

Formula results are shown with a little ‘fx’ icon. The formula itself can’t be changed in Card view.

The ‘three dots’ menu, top-right, opens up more options:

  • Insert Above
  • Insert Below
  • Delete

What about Excel for Windows, Mac and iPad?

Excel Cards don’t exist in other versions of Excel, at least not in that name.

Excel for Windows has Form … which shows a dialog box of the current table row.  All the move, add, delete and find options are there.  For reasons passing understanding, Form isn’t on the Data or Table ribbons.

Excel Table Cards for smartphones 5 - Excel Table Cards for smartphones

Neither Cards nor Form is available on Excel for Mac or iPad.

Solved – the problem with Excel Tables and Transpose

PivotTables and PivotCharts from scratch, for Microsoft Excel

What are Excel Tables and why you should use them

Make automatic Excel worksheet list or table of contents

subs profile e1563205311409 - Excel Table Cards for smartphones
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address