Cards View in Excel now generally available on mobile

Published Mar 31 2020 08:50 AM 11.9K Views
Microsoft

We know all know it can be hard to work with a large spreadsheet on a phone. Columns often span beyond the limits of a screen and as you scroll to view the data in the farther columns it can be difficult to keep track of which row you are viewing. Cards View in Excel was designed to fix that problem.

 

Cards View enables you to view and edit a row of data from an Excel spreadsheet in a format that fits within your phone’s screen. When viewing an Excel spreadsheet in the new Office mobile app or the Excel mobile app, simply tap on the Card View icon in the bottom left corner of the screen and you will see the a collection of cards with each card containing the data from each row of the spreadsheet. You can work with the data just as you normally would, but this time all on one screen. Scroll through the cards to view different rows of data, search within the spreadsheet, make edits to the data, or simply view an entire row of data all at once.

 
 
 

View an entire row of Excel data on one screen with Cards View.View an entire row of Excel data on one screen with Cards View.

 

We have been rolling this feature out to users over the last couple weeks and expect the roll-out to be complete by the end of this week. Get the latest update of the Microsoft Office app or Microsoft Excel app for Android or iOS to try out this new feature and say goodbye to hassle of keeping track of rows as you scroll across the columns of a spreadsheet. For more information on how to use this feature, please review the Cards View support article.

4 Comments
Occasional Visitor

Hello,

 My name is Marcus. I am new to this excel thing, can I be taken through in order for me to get a better idea, so that with your help I can be able to enter data and work with data supplied to get results.

 Thanks in advance for your help.

 Marcus Lewis

Frequent Visitor

Hi, I really like the cards view, but I found that it is messing with my dates!

I have a table, and a date field, but using the date format of Spain (and the majority of countries in the world)... When I enter the date using the Card View in excel on Android, it saves the date in the wrong format.

I go to Card view, in the date field I click the calendar icon, the Calendar is displayed, I select "5 Nov 2020" and save.

The date saved in my sheet is "11/05/2020" but for me that date corresponds to 11th of May 2020... because I have the European format.

 

Any clue on why this is happening, it is a bug? 

Occasional Visitor

I have same issue as previous person. When choose date from card interface it overrides current format and set month/day/year. Meanwhile if you choose date from main interface date format will be according to your setting.

Please fix this bug, it makes cards unusable. 

Occasional Visitor

This is a really great feature - I've found it much more versatile than I had envisioned. I particularly enjoy the buttons for calendar and phone that automatically generate in the cards for columns that hold phone numbers and calendars.

Two additional functions I think would make it even better:

 

1) something similar to that for addresses - a button that directly opens the location in the phone's map app.

2) Option to integrate dates/info from the cards onto the outlook calendar

%3CLINGO-SUB%20id%3D%22lingo-sub-1266783%22%20slang%3D%22en-US%22%3ECards%20View%20in%20Excel%20now%20generally%20available%20on%20mobile%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1266783%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20know%20all%20know%20it%20can%20be%20hard%20to%20work%20with%20a%20large%20spreadsheet%20on%20a%20phone.%20Columns%20often%20span%20beyond%20the%20limits%20of%20a%20screen%20and%20as%20you%20scroll%20to%20view%20the%20data%20in%20the%20farther%20columns%20it%20can%20be%20difficult%20to%20keep%20track%20of%20which%20row%20you%20are%20viewing.%20Cards%20View%20in%20Excel%20was%20designed%20to%20fix%20that%20problem.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECards%20View%20enables%20you%20to%20view%20and%20edit%20a%20row%20of%20data%20from%20an%20Excel%20spreadsheet%20in%20a%20format%20that%20fits%20within%20your%20phone%E2%80%99s%20screen.%20When%20viewing%20an%20Excel%20spreadsheet%20in%20the%20new%20Office%20mobile%20app%20or%20the%20Excel%20mobile%20app%2C%20simply%20tap%20on%20the%20Card%20View%20icon%20in%20the%20bottom%20left%20corner%20of%20the%20screen%20and%20you%20will%20see%20the%20a%20collection%20of%20cards%20with%20each%20card%20containing%20the%20data%20from%20each%20row%20of%20the%20spreadsheet.%20You%20can%20work%20with%20the%20data%20just%20as%20you%20normally%20would%2C%20but%20this%20time%20all%20on%20one%20screen.%20Scroll%20through%20the%20cards%20to%20view%20different%20rows%20of%20data%2C%20search%20within%20the%20spreadsheet%2C%20make%20edits%20to%20the%20data%2C%20or%20simply%20view%20an%20entire%20row%20of%20data%20all%20at%20once.%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorBill%20Doll_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20id%3D%22tinyMceEditorBill%20Doll_1%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20id%3D%22tinyMceEditorBill%20Doll_2%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Excel%20Cards%20GIF%20-%20IDC.gif%22%20style%3D%22width%3A%20197px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F180777i87BF98D28DEF26FC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Excel%20Cards%20GIF%20-%20IDC.gif%22%20alt%3D%22View%20an%20entire%20row%20of%20Excel%20data%20on%20one%20screen%20with%20Cards%20View.%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EView%20an%20entire%20row%20of%20Excel%20data%20on%20one%20screen%20with%20Cards%20View.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20have%20been%20rolling%20this%20feature%20out%20to%20users%20over%20the%20last%20couple%20weeks%20and%20expect%20the%20roll-out%20to%20be%20complete%20by%20the%20end%20of%20this%20week.%20Get%20the%20latest%20update%20of%20the%20Microsoft%20Office%20app%20or%20Microsoft%20Excel%20app%20for%20Android%20or%20iOS%20to%20try%20out%20this%20new%20feature%20and%20say%20goodbye%20to%20hassle%20of%20keeping%20track%20of%20rows%20as%20you%20scroll%20across%20the%20columns%20of%20a%20spreadsheet.%20For%20more%20information%20on%20how%20to%20use%20this%20feature%2C%20please%20review%20the%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Farticle%2Fuse-cards-view-to-work-with-table-data-on-your-phone-fda6099e-2de8-4a52-a926-90a7ee61a32b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ECards%20View%20support%20article%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1266783%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20spreadsheets%20are%20now%20easier%20to%20work%20with%20on%20a%20phone%20with%20Cards%20View%20which%20lets%20you%20view%20and%20edit%20a%20whole%20row%20of%20data%20all%20on%20one%20screen.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1605047%22%20slang%3D%22en-US%22%3ERe%3A%20Cards%20View%20in%20Excel%20now%20generally%20available%20on%20mobile%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605047%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3BMy%20name%20is%20Marcus.%20I%20am%20new%20to%20this%20excel%20thing%2C%20can%20I%20be%20taken%20through%20in%20order%20for%20me%20to%20get%20a%20better%20idea%2C%20so%20that%20with%20your%20help%20I%20can%20be%20able%20to%20enter%20data%20and%20work%20with%20data%20supplied%20to%20get%20results.%3C%2FP%3E%3CP%3E%26nbsp%3BThanks%20in%20advance%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3BMarcus%20Lewis%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1860636%22%20slang%3D%22en-US%22%3ERe%3A%20Cards%20View%20in%20Excel%20now%20generally%20available%20on%20mobile%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1860636%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20really%20like%20the%20cards%20view%2C%20but%20I%20found%20that%20it%20is%20messing%20with%20my%20dates!%3C%2FP%3E%3CP%3EI%20have%20a%20table%2C%20and%20a%20date%20field%2C%20but%20using%20the%20date%20format%20of%20Spain%20(and%20the%20majority%20of%20countries%20in%20the%20world)...%20When%20I%20enter%20the%20date%20using%20the%20Card%20View%20in%20excel%20on%20Android%2C%20it%20saves%20the%20date%20in%20the%20wrong%20format.%3C%2FP%3E%3CP%3EI%20go%20to%20Card%20view%2C%20in%20the%20date%20field%20I%20click%20the%20calendar%20icon%2C%20the%20Calendar%20is%20displayed%2C%20I%20select%20%225%20Nov%202020%22%20and%20save.%3C%2FP%3E%3CP%3EThe%20date%20saved%20in%20my%20sheet%20is%20%2211%2F05%2F2020%22%20but%20for%20me%20that%20date%20corresponds%20to%2011th%20of%20May%202020...%20because%20I%20have%20the%20European%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20clue%20on%20why%20this%20is%20happening%2C%20it%20is%20a%20bug%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1937939%22%20slang%3D%22en-US%22%3ERe%3A%20Cards%20View%20in%20Excel%20now%20generally%20available%20on%20mobile%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1937939%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20same%20issue%20as%20previous%20person.%20When%20choose%20date%20from%20card%20interface%20it%20overrides%20current%20format%20and%20set%20month%2Fday%2Fyear.%20Meanwhile%20if%20you%20choose%20date%20from%20main%20interface%20date%20format%20will%20be%20according%20to%20your%20setting.%3C%2FP%3E%3CP%3EPlease%20fix%20this%20bug%2C%20it%20makes%20cards%20unusable.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2188328%22%20slang%3D%22en-US%22%3ERe%3A%20Cards%20View%20in%20Excel%20now%20generally%20available%20on%20mobile%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2188328%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20a%20really%20great%20feature%20-%20I've%20found%20it%20much%20more%20versatile%20than%20I%20had%20envisioned.%20I%20particularly%20enjoy%20the%20buttons%20for%20calendar%20and%20phone%20that%20automatically%20generate%20in%20the%20cards%20for%20columns%20that%20hold%20phone%20numbers%20and%20calendars.%3CBR%20%2F%3E%3CBR%20%2F%3ETwo%20additional%20functions%20I%20think%20would%20make%20it%20even%20better%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20something%20similar%20to%20that%20for%20addresses%20-%20a%20button%20that%20directly%20opens%20the%20location%20in%20the%20phone's%20map%20app.%3C%2FP%3E%3CP%3E2)%20Option%20to%20integrate%20dates%2Finfo%20from%20the%20cards%20onto%20the%20outlook%20calendar%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎Mar 31 2020 08:16 AM
Updated by: