What are some important shortcuts for Microsoft Excel 2016?

+1 vote
asked Oct 4 in General Discussions by ryan
Please provide some helpful shortcuts that can make the use of excel 2016 more easy and joyful.

1 Answer

0 votes
answered Oct 4 by lorein0688 (930 points)

Shortcut

Description

ALT H, H

- Choose a fill color.

ALT H, A, then C

 - Center align cell contents.

ALT H, B

- Add borders.

ALT H, D, then C 

- Delete column.

CTRL 9

- Hide the selected rows.

CTRL 0

- Hide the selected columns.

SHIFT + TAB

- Move to the previous cell in a worksheet or the previous option in a dialog box.

CTRL Arrow key

- Move to the edge of the current data region in a worksheet.

CTRL Home

- Move to the beginning of a worksheet.

CTRL Page Down

- Move to the next sheet in a workbook.

CTRL Page Up

- Move to the previous sheet in a workbook.

ALT Page Down

- Move one screen to the right in a worksheet.

ALT Page Up

- Move one screen to the left in a worksheet.

CTRL 1

- Open the Format Cells dialog box.

F2

- If editing is turned on, F2 will edit the active cell and put the insertion point at the end of its contents.

 

Welcome to Q&A - Repair MS Excel File, where you can ask questions and receive answers from other members of the community.
...