Excel Shortcut Keys: Using Ctrl + W (Closes the selected workbook window)

Excel Shortcut Keys

Ctrl + W
Closes the selected workbook window.

Excel Shortcut Keys: Using Ctrl + V (Inserts the contents of the Clipboard)

Excel Shortcut Keys

Ctrl + V
Inserts the contents of the Clipboard at the insertion point and replaces any selection.
Available only after you have cut or copied an object, text, or cell contents.

Excel Shortcut Keys: Using Ctrl + U (Underlining the text)

Excel Shortcut Keys

Ctrl + U
Applies or removes underlining.

Excel Shortcut Keys: Using Ctrl + T (Create a Table)

Excel Shortcut Keys

Ctrl + T
Display the Create Table dialog box. Or Create a range into Table.

Excel Shortcut Keys: Using Ctrl + S (Saves the active file)

Excel Shortcut Keys

Ctrl + S
Save the active file with its current file name, location, and file format.

Excel Shortcut Keys: Using Ctrl + R (Fill Right command to copy)

Excel Shortcut Keys

Ctrl + R

Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.

Excel Shortcut Keys: Using Ctrl + Q (Quick Analysis option)

Excel Shortcut Keys

Ctrl + Q

Display the Quick Analysis option for your data when you have cells that contain data selected

Excel Shortcut Keys: Using Ctrl + P (Print file)

Excel Shortcut Keys

Ctrl + P

Display the Print tab in Microsoft Office Backstage view. or Print the sheet/file

 

 

Excel Shortcut Keys: Using Ctrl + O (Open a file)

Excel Shortcut Keys

Ctrl + O

Display the Open dialog box to open or find a file

 

 

Excel Shortcut Keys: Ctrl + N (Create a new workbook)

Excel Shortcut Keys

Ctrl + N

Creates a new, blank workbook

 

 

Excel Shortcut Keys: Ctrl + L (Create a Table)

Excel Shortcut Keys

Ctrl + L

Displays the Create Table dialog box. To Make a Table

or Make your data into uniform to change your range into Table

 

 

Excel Shortcut Keys: Ctrl + K (Insert Hyperlink)

Excel Shortcut Keys

Ctrl + K

Displays the Insert Hyperlink dialog box

For new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.

 

Excel Shortcut Keys: Ctrl + I (Italic)

Excel Shortcut Keys

Ctrl + G (display GoTo dialog box)

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.

 

exce0

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.

 

 

Excel Shortcut Keys Ctrl +B (Bold formatting)

Excel Shortcut Keys

Ctrl + B

Applies or removes bold formatting.