How to Search an Excel Spreadsheet With a Shortcut

Save

Microsoft Excel allows users to manage data and finances through spreadsheets. Each spreadsheet is made up of a collection of rows and columns of individual cells that store information. Formulas are then applied to the cells to conduct calculations. Excel, like most Microsoft Office applications, comes with a set of shortcut or function keys that can be used to manage and edit spreadsheets quickly. A simple function key can also help users find values throughout a spreadsheet that may contain many cells of information.

  • Launch the Excel. Click "Start" from the bottom of the screen. Click "All Programs" and then click "Microsoft Excel."

  • Open the Excel spreadsheet of your choice. Click the "Windows" icon from the top of the screen and click "Open." Click the spreadsheet to select it and click "Open."

  • Press the "CTRL" and "G" keys simultaneously. Alternatively, you can also press "Shift" and "F5." The "Go To" dialog box launches.

  • Enter the value you wish to search for in the "Go To" box and press "Enter." The first instance of the value is highlighted. Continue to press the "Enter" key to find additional instances of the value.

References

Promoted By Zergnet

Comments

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!