Ctrl + G (display GoTo dialog box)

Ctrl + G

Displays the Go To dialog box.

F5 also displays this dialog box.


Excel Shortcut Keys : Ctrl + Shift + ) - (unhide Columns)

Ctrl + Shift + )

Unhide Columns

Unhide any didden columns within the selection.



Create a Pivot Table

Create a pivot Table

How to create a Pivot Table in Excel

Excel Keyboard Shortcut : Ctrl + E

Ctrl + E

Adds more value to the active column by using data surrounding that column.


Excel Shortcut Keys: Ctrl + D (Duplicate data)

Ctrl + D

Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.



Excel Keyboard Shortcut : Ctrl + C (Copies the selected cells)

Ctrl + C

Copies the selected cells.



Close All file on a single click in Excel 2013 and 2016

Close All file on a single click in Excel 2016

In Excel 2013 & 2016 All the excel files open in separate window so it's not possible to close all the opened file at once. This is by default, there is no option to close all excel workbook/files at once in version 2013 & 2016.
Previous version of Excel workbook/file opened in one window and we can easily have closed all the files just using the Alt+F4. Excel 2013 each excel file open on separate window and continue in 2016 version.
For example, if we have 10 files open we must close all the files separately or hit the Alt+F4 command 10 times.

Excel Shortcut Keys Ctrl +B (Bold formatting)

Ctrl + B

Applies or removes bold formatting.

Excel Shortcut Keys: Ctrl + A (Select All Data)

Ctrl + A

Select the entire worksheet.

If the worksheet contains data, Ctrl+A selects the current region.

Pressing Ctrl+A a second time selects the entire worksheet.



Recommended for You


Related Posts Plugin for WordPress, Blogger...