Excel Shortcut Keys
Ctrl + G
Displays the Go To dialog box.
F5 also displays this dialog box.
Excel Shortcut Keys: Ctrl+F (Find data)
Excel Shortcut Keys
Ctrl + F
Display the Find and Replace dialog box, with the Find tab selected.
You can find the data or text using the Ctrl+F
Excel Shortcut Keys : Ctrl + Shift + ) - (unhide Columns)
Excel Shortcut Keys
Ctrl + Shift + )
Unhide Columns
Unhide any didden columns within the selection.
Excel Keyboard Shortcut : Ctrl + E
Excel Shortcut Keys
Ctrl + E
Adds more value to the active column by using data surrounding that column.
Excel Shortcut Keys: Ctrl + D (Duplicate data)
Excel Shortcut Keys
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)
Excel Shortcut Keys
Ctrl + C
Copies the selected cells.
Close All file on a single click in Excel 2013 and 2016
Excel Tutorial
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.
Subscribe to:
Posts (Atom)
LinkWithin
