Excel on iPad Pro

I want to select and delete just the blank cells that are scattered among cells with data, so that all the data is nicely compacted. On my windows laptop, I would just hit F5 and Go To, Special, tick the blanks box and click delete. A dropdown box appeared so I could choose to move the cells with data up. I can’t find anywhere how to do this on my iPad. Please help!

iPad Pro 12.9-inch Wi-Fi, Cellular

Posted on Feb 28, 2021 10:31 PM

Similar questions

Deleting cells in Numbers Is there a way to delete individual or groups of cells WITHOUT deleting rows or columns? Do the other cells in the row and column move the way they do in Excel? Thank you.
2096 1
Clearing data in a cell but not the formatting I have a spreadsheet with a column of entries that are formatted as a pop-up menu. What I am trying to do is clear the data values, but not delete the pop-up formatting. I can't find a way to do that. If I select the column and hit the delete key, the data disappears as expected, but so does the pop-up menu. If I use the edit menu and select either "Delete" or "Clear", the same thing happens. Is there any way that I can delete the data from these cells, without losing the pop-up menu?
1395 2
Insert Cell Cells moves down or right, Delete a single cell shifts data up or right Does anyone know how to ask apple for a feature? All posts related to this are 8 - 12 years old.... I like using spreadsheet as a ToDo list.... this is a must have feature Instead of inserting a Row or column, is it possible to only insert cells and have the adjacent cells move up/down/left/right? see https://discussions.apple.com/thread/1890274 https://discussions.apple.com/thread/1750824 Thanks Ipad 9.7 Pro iMac 27 5k 2017 iPhone 11 Pro Max MacBook Air i7 mid 2013 etc House Hold has about 20+ apple devices... iOS 13 iOS 13.41
270 1

1 reply

Rudegar

Level 10

180,060 points

Feb 28, 2021 11:26 PM in response to Floatawayyafairy

microsoft has a support page for their excel ios version Excel for iPad Help - Excel for iPad (microsoft.com)

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Excel on iPad Pro

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up