Shortcuts in Microsoft® Office Excel 2010

Microsoft Office Excel 2010 comes with many features, like Sparklines, Set, Data, Slicers, and PowerPivot among others. All these features can help to increase the performance of Microsoft Office Excel 2010. It provides improved web services as well. It provides tight integration with Microsoft SharePoint for security, content management, version control, document-level compliance, data connection management, and service administration. Shortcuts are helpful in increasing the performance of Microsoft Office Excel 2010.

• Displaying and using windows
• Previewing and printing
• Entering data

Displaying and using windows

In order to switch to the next program, you need to press the 'ALT' and 'TAB' keys concurrently. You can switch to the previous program by pressing the 'ALT', 'SHIFT' and 'TAB' keys simultaneously. To display the 'Start' menu, you need to press the 'CTRL' and 'ESC' keys together. In order to close the selected workbook window, you need to press the 'CTRL' and 'W' or the 'CTRL' and 'F4' keys. By pressing the 'CTRL' and 'F5' keys simultaneously, you can restore the window size of the selected workbook window.

Previewing and printing

In order to display the 'Print' dialog box, you need to press the 'CTRL' and 'P' keys or the 'CTRL', 'SHIFT' and 'F12' keys together. By pressing the page up or page down arrow keys, you can move by one page when zoomed out. In order to move to the first page when zoomed out, you need to press the 'CTRL' and up arrow or the 'CTRL' and left arrow keys. To move to the last page when zoomed out, you need to press the 'CTRL' and down arrow or the 'CTRL' and right arow keys together.

In order to complete a cell entry and select the cell below, you need to press the 'ENTER' key. If you want to start a new line in the same cell, then you need to press 'ALT' + 'ENTER'. By clicking 'CTRL' + 'ENTER', you can fill the selected cell range with the current entry. To complete a cell entry and select the previous cell, you need to press 'SHIFT' + 'ENTER'.

iYogi is the fastest growing online and remote tech support provider in the direct-to-consumers and small businesses sector. Our highly skilled and experienced tech experts available, 24x7x365 can provide the best issue resolution and customer satisfaction.

• Comprehensive support for shortcuts in Microsoft Office Excel 2010
• Diagnostic & repair for your technologies
• Troubleshoot software errors
• Update drivers and security to protect against online threats
• Connect to Internet, devices, and peripherals
• Optimize your computer’s speed and performance.