Office
 

Microsoft Excel 2013 : Moving Around the Workbook (part 2) - Use the Keyboard to Navigate, Go To a Specific Location

3/24/2015 2:25:39 AM

Use the Keyboard to Navigate

Using the keyboard, you can navigate in a worksheet to:

• Another cell

• Another part of the worksheet

Refer to the table for keyboard shortcuts for navigating around a worksheet.


Did You Know?

You can change or move cell selections after pressing Enter. When you press Enter, the active cell moves down one cell. To change the direction, click the File tab, click Options, click Advanced, select the After Pressing Enter, Move Selection check box, click the Direction list arrow, select a direction, and then click OK.


Keys For Navigating in a Worksheet

Image

Go To a Specific Location

1. Click the Home tab.

2. Click the Find & Select button, and then click Go To.

3. Select a location or type a cell address to where you want to go.

4. To go to other locations (such as comments, blanks, last cell, objects, formulas, etc.), click Special, select an option, and then click OK.

Image

Timesaver

To open the Special dialog box directly, click the Find & Select button, and then click Go To Special.


5. Click OK.

 
Others
 
- Microsoft Excel 2013 : Moving Around the Workbook (part 1) - Use the Mouse or Finger to Navigate
- Microsoft Excel 2013 : Arranging Windows (part 2) - Arrange or Switch Between Windows, Compare Windows Side By Side
- Microsoft Excel 2013 : Arranging Windows (part 1) - Resize and Move a Window, Resize and Move a Window Using a Mouse
- Microsoft Excel 2013 : Converting an Existing Workbook - Convert an Excel 97-2003 to Excel 2013
- Microsoft Excel 2013 : Creating a Workbook Using a Template
- Microsoft Excel 2013 : Choosing Dialog Box Options
- Microsoft Excel 2013 : Working with the Ribbon and Toolbars (part 2) - Customize the Ribbon or Quick Access Toolbar
- Microsoft Excel 2013 : Working with the Ribbon and Toolbars (part 1) - Choose a Command Using a Toolbar or Ribbon, Add or Remove Items from the Quick Access Toolbar
- Microsoft Excel 2013 : How to fix - Checking Accessibility
- Video tutorial : How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 3)
 
 
REVIEW
 
- First look: Apple Watch

- 10 Amazing Tools You Should Be Using with Dropbox
 
VIDEO TUTORIAL
 
- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 1)

- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 2)

- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 3)
 
Popular tags
 
Video Tutorail Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 Adobe Indesign Adobe Flash Professional Dreamweaver Adobe Illustrator Adobe After Effects Adobe Photoshop Adobe Fireworks Adobe Flash Catalyst Corel Painter X CorelDRAW X5 CorelDraw 10 QuarkXPress 8 windows Phone 7 windows Phone 8 BlackBerry Android Ipad Iphone iOS
 
 
Top 10
 
- Microsoft Visio 2010 : Adding Sophistication to Your Drawings - Working with background pages and borders
- Microsoft Visio 2013 : Adding Sophistication to Your Drawings - Managing pages and page setup
- Microsoft Excel 2013 : Checking Compatibility - Check Workbook Compatibility
- Microsoft Excel 2013 : Working with Accounts - Work with Online Accounts, Add Online Services
- Microsoft Excel 2013 : Saving a Workbook to Online Services - Save a Workbook to Online Storage
- Microsoft Excel 2013 : Saving a Workbook with Different Formats - Save a Workbook with Another Format
- Microsoft Excel 2013 : Saving a Workbook (part 2) - Save an Excel 97-2003 Workbook
- Microsoft Excel 2013 : Saving a Workbook (part 1) - Save a Workbook for Excel 2013
- Microsoft Excel 2013 : Getting Help While You Work - Use the Help Viewer to Get Answers, Search for Help, Use Local or Online Help
- Microsoft Excel 2013 : Moving Around the Workbook (part 2) - Use the Keyboard to Navigate, Go To a Specific Location