Forum Discussion

SONUKAGDANA's avatar
SONUKAGDANA
Copper Contributor
May 30, 2024

Search bar view not available all searched

 When search anything in search bar of colum,,,, then result show only one row or one item,,,,,
Excel on mobile
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jun 03, 2024

SONUKAGDANA 

When using the search function in Excel on mobile (whether it's on iOS or Android), the experience can be different from what you might be used to on the desktop version. If the search bar only shows one result at a time and you want to view all matching results, here are a few tips that might help:

Tips for Searching in Excel on Mobile:

1. Filter Functionality:

  • Instead of using the search bar, you can use the filter feature to see all rows that match your criteria. Here’s how to apply a filter:
      1. Select the column header of the column you want to filter.
      2. Tap on the filter icon (usually looks like a funnel) in the toolbar.
      3. Enter your search term in the search box within the filter options.
      4. This will show all rows that contain the search term.

2. Using Find Function:

  • While the search bar may only show one result at a time, the "Find" function can help you navigate through each occurrence:
      1. Tap the three dots (more options) in the toolbar.
      2. Select "Find and Replace."
      3. Enter your search term.
      4. Use the arrows to navigate through each occurrence of the search term in the worksheet.

3. Highlighting Cells:

  • Another approach is to use conditional formatting to highlight all cells containing the search term:
      1. Tap on a cell in the column you want to search.
      2. Go to the "Home" tab in the toolbar.
      3. Select "Conditional Formatting."
      4. Choose "Text Contains" and enter your search term.
      5. Apply a format (e.g., change the background color) to highlight the cells.

4. Using Excel Online:

  • If the mobile app's functionality is too limited, consider using Excel Online through your mobile browser:
      1. Open your mobile browser and go to office.com.
      2. Sign in with your Microsoft account.
      3. Open Excel Online and access your spreadsheet.
      4. Use the desktop-like search features available in Excel Online.

5. Split View (iPad Only):

  • If you are using an iPad, you can take advantage of the split view feature to see more of your data:
      1. Open Excel.
      2. Swipe up from the bottom of the screen to open the dock.
      3. Drag another instance of Excel from the dock to the right or left side of the screen.
      4. You can now view two parts of the same spreadsheet simultaneously, making it easier to see multiple search results.

Limitations and Workarounds:

  • App Limitations: Note that the mobile version of Excel has some limitations compared to the desktop version. If you frequently need to perform complex searches and analysis, using Excel on a desktop or through Excel Online might be more efficient.
  • Regular Updates: Ensure your Excel mobile app is updated to the latest version, as Microsoft regularly adds new features and improves existing ones.

Summary:

While the search functionality in Excel on mobile might not show all results simultaneously, you can use filters, conditional formatting, or the find function to navigate through multiple results. For more complex tasks, using Excel Online or the desktop version might be necessary. The text and steps were edited with the help of AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.