Excel Keyboard Shortcut Control Combination (Part 2)

Excel Keyboard Shortcut
Control Combination
Part 2

Ctrl + 1 - Displays the Format Cells dialog box
Ctrl + 2 - Applies or removes bold formatting
Ctrl + 3 - Applies or removes italic formatting
Ctrl + 4 - Applies or removes underlining
Ctrl + 5 - Applies or removes strikethrough
Ctrl + 6 - Alternates between hiding and displaying objects
Ctrl + 8 - Displays or hides the outline symbols
Ctrl + 9 - Hides the selected row/s
Ctrl + 0 - Hides the selected column/s
Ctrl + A - Selects the entire worksheet
Ctrl + B - Applies or removes bold formatting
Ctrl + C - Copies the selected cells
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
Ctrl + E - Invoke Flash Fill to automatically recognize patterns in adjacent columns and fill the current column
Ctrl + F - Displays the Find and Replace dialog box, with the Find tab selected
Ctrl + G - Displays the Go To dialog box. F5 also displays this dialog box.
Ctrl + H - Displays the Find and Replace dialog box, with the Replace tab selected.
Ctrl + I - Applies or removes italic formatting
Ctrl + K - Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
Ctrl + L - Displays the Create Table dialog box
Ctrl + N - Creates a new, blank workbook
Ctrl + O - Displays the Open dialog box to open or find a file
Ctrl + Shift + O - Selects all cells that contain comments
Ctrl + P - Displays the Print tab in Microsoft Office Backstage view
Ctrl + Shift + P - Opens the Format Cells dialog box with the Font tab selected
Ctrl + Q - Displays the Quick Analysis options for your data when you have cells that contain that data selected.
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
Ctrl + S - Saves the active file with its current file name, location, and file format
Ctrl + T - Displays the Create Table dialog box
Ctrl + U - Applies or removes underlining
Ctrl + Shift + U - Switches between expanding & collapsing of the formula bar
Ctrl + V - Inserts the contents of the Clipboard at the insertion point
Ctrl + Alt + V - Displays the Paste Special dialog box
Ctrl + W - Closes the selected workbook window
Ctrl + X - Cuts the selected cells
Ctrl + Y - Repeats the last command or action, if possible (F4)
Ctrl + Z - Uses the Undo command to reverse the last command or to delete the last entry that you typed

“To EXCEL in the workplace, one must know how to use Excel!”
- Romeo

*************************************************
Want to learn more about Excel?

SUBSCRIBE NOW:
https://www.youtube.com/channel/UCqGtUgcTs7Ml3ZliCqUo-3Q?view_as=subscriber?sub_confirmation=1

YouTube Playlist:
https://www.youtube.com/watch?v=QprmWzbyFJo&list=PL6u1_VTMTuroJ2vYazClV476kTJHb4Gyb&index=1

Or visit me on Facebook at https://www.facebook.com/ExcelbyRomeoCostillas

See you there!
Romeo Costillas
Microsoft Certified Solutions Associate BI Reporting
Microsoft Office Specialist Master
Microsoft Office Specialist Excel Expert

Tagalog Excel | Filipino | Pinoy Excel

#microsoftexcel #excel #excelbyromeocostillas

Видео Excel Keyboard Shortcut Control Combination (Part 2) канала Romeo Costillas