Microsoft Excel Keyboard shortcuts- A complete list of hot keys

Microsoft Excel Keyboard shortcuts- A complete list of hot keys

Hello fellas here, I am focusing on Microsoft Excel Keyboard shortcuts- A complete list of hot keys. So please read this tutorial carefully so you may comprehend it in a better useful way.

Guide: Microsoft Excel Keyboard shortcuts- A complete list of hot keys

Ctrl + PgDnSwitch between worksheet tabs, left to right.Ctrl + Page UpSwitch between the tabs in the worksheet, from right to left.Ctrl + Shift + &Applies the outline border to the selected cells.Ctrl + Shift_Removes the border from the outline of the selected cells.Ctrl + Shift + ~Apply the general number format.Ctrl + Shift + $Apply the Currency format with two decimal places (negative numbers in parentheses).Ctrl + Shift +%Apply the percentage format without decimals.Ctrl + Shift + ^Apply the scientific number format to two decimal places.Ctrl + Shift + #Apply the date format with the day, month and year.Ctrl + Shift + @Apply the time format with the hour and minutes, and AM or PM.Ctrl + Shift +!Applies the number format with two decimal places, thousands separator, and minus sign (-) for negative values.Ctrl + Shift + *Selects the current region around the active cell (the data area delimited by blank rows and columns). In a pivot table, select the entire pivot table report.Ctrl + Shift +:Enter the current time.Ctrl + Shift + “Copies the value of the cell over the active cell in the cell or in the formula bar.Ctrl + Shift + Plus (+)Displays the Insert dialog box for inserting blank cells.Ctrl + Minus (-)Displays the Delete dialog box to delete the selected cells.Ctrl +;Enter the current date.Ctrl + `Toggles between displaying cell values ​​and displaying formulas in the worksheet.Ctrl + ‘Copies a formula from the cell over the active cell in the cell or formula bar.Ctrl + 1Displays the Format Cells dialog box.Ctrl + 2Apply or remove the bold format.Ctrl + 3Apply or remove the italic formatting.Ctrl + 4Apply or remove the underline.Ctrl + 5Apply or remove strikethrough.Ctrl + 6Toggles between hiding and showing objects.Ctrl + 8Show or hide outline symbols.Ctrl + 9Hide the selected rows.Ctrl + 0Hides the selected columns.Ctrl + ASelect the entire worksheet. If the worksheet contains data, Ctrl + A selects the current region. Pressing Ctrl + A a second time selects the entire worksheet. When the insertion point is to the right of a function name in a formula, it displays the Function Arguments dialog box. Ctrl + Shift + A inserts the names of the arguments and parentheses when the insertion point is to the right of the name of a function in a formula.Ctrl + BApply or remove the bold format.Ctrl + CCopy the selected cells.Ctrl + DUse the Fill Down command to copy the content and formatting of the top cell of a selected range into subsequent cells.Ctrl + EAdd more values ​​to the active column using data surrounding that column.Ctrl + FDisplays the Find and Replace dialog box, with the Find tab selected. Shift + F5 also displays this tab, while Shift + F4 repeats the last Find action. Ctrl + Shift + F opens the Format Cells dialog with the Font tab selected.Ctrl + GDisplays the Go To dialog box. F5 also displays this dialog box.Ctrl + HDisplays the Find and Replace dialog box, with the Replace tab selected.Ctrl + IApply or remove the italic formatting.Ctrl + KDisplays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.Ctrl + LDisplays the Create Table dialog box.Ctrl + NCreate a new blank book.Ctrl + ODisplays the Open dialog to open or browse for a file. Ctrl + Shift + O selects all cells that contain comments.Ctrl + PDisplays the Print tab in Microsoft Office Backstage view. Ctrl + Shift + P opens the Format Cells dialog with the Font tab selected.Ctrl + QDisplays the Quick Analysis options for your data when you have cells that contain that selected data.Ctrl + RUse the Fill Right command to copy the content and formatting of the leftmost cell in a selected range to the cells on the right.Ctrl + SSaves the active file with its current file name, location, and file format.Ctrl + TDisplays the Create Table dialog box.Ctrl + UApply or remove the underline. Ctrl + Shift + U toggles between expanding and collapsing the formula bar.Ctrl + VInserts 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 content. Ctrl + Alt + V displays the Paste Special dialog. Available only after you have cut or copied an object, text, or cell content in a worksheet or another program.Ctrl + WClose the selected workbook window.Ctrl + XCut selected cells.Ctrl + YRepeat the last command or action, if possible.Ctrl + ZUse the Undo command to revert the last command or to delete the last entry you typed.

Faq

Guide about Microsoft Excel Keyboard shortcuts- A complete list of hot keys


In this guide, we told you about the Microsoft Excel Keyboard shortcuts- A complete list of hot keys; please read all steps above so that you understand Microsoft Excel Keyboard shortcuts- A complete list of hot keys in case if you need any assistance from us, then contact us.

How this tutorial or guide assisting you?


So in this guide, we discuss the Microsoft Excel Keyboard shortcuts- A complete list of hot keys, which undoubtedly benefits you.



Final note

I hope you like the guide Microsoft Excel Keyboard shortcuts- A complete list of hot keys. In case if you have any queries regards this article/tutorial you may ask us. Also, please share your love by sharing this article with your friends and family. Follow us on Facebook and Twitter if you love our work.

For our visitors: If you have any questions regards the Microsoft Excel Keyboard shortcuts- A complete list of hot keys, then feel free to ask us through the comment section below or directly contact us.
Education: This guide or tutorial is just for educational purposes only.
Misinformation: If you want to correct any misinformation regarding this tutorial “Microsoft Excel Keyboard shortcuts- A complete list of hot keys”, then kindly contact us for the same.
Want to add an alternate method: If anyone wants to add more methods to the guide Microsoft Excel Keyboard shortcuts- A complete list of hot keys, then kindly contact us.

Microsoft Excel Keyboard shortcuts- A complete list of hot keys: advantages guide by trickbugs

  • The Microsoft Excel Keyboard shortcuts- A complete list of hot keys tutorial is free for anyone.
  • The price of the Microsoft Excel Keyboard shortcuts- A complete list of hot keys guide is free for all our visitors so they learn each tutorial carefully.

Trickbugs: Get the latest Trick and Tips
Logo
Enable registration in settings - general