• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Keyboard shortcuts commonly used in Excel

0 Comments

Keyboard shortcuts commonly used in Excel. MS Excel provides many keyboard shortcuts. Using shortcuts can help you work faster and more professionally with Excel. Below is a list of commonly used shortcuts in Excel:

Keyboard shortcuts commonly used in Excel

Keyboard shortcuts commonly used in Excel 2Ctrl + A: Select all content of the worksheet.

Ctrl + B: Bold selected text.

Ctrl + I: Italicize selected text.

Ctrl + K: Insert hyperlink.

Ctrl + U: Underline selected text.

Ctrl + 1: Change formatting of selected cells.

Ctrl + 5: Strikethrough selected text.

Ctrl + P: Print the worksheet.

Ctrl + Z: Undo last action.

Ctrl + F3: Open Excel Name Manager.

Ctrl + F9: Minimize current window.

Ctrl + F10: Maximize current window.

Ctrl + F6: Switch between open workbooks or windows.

Ctrl + Page up: Move between Excel worksheets in the same Excel document.

Ctrl + Page down: Move between Excel worksheets in the same Excel document.

Ctrl + Tab: Move between two or more open Excel files.

Alt + =: Create a formula to sum all cells above.

Ctrl + ‘: Insert value of cell above into current cell.

Ctrl + Shift + !: Format number with comma format.

Ctrl + Shift + $: Format number with currency format.

Ctrl + Shift + #: Format number with date format.

Ctrl + Shift + %: Format number with percentage format.

Ctrl + Shift + ^: Format number with scientific format.

Ctrl + Shift + @: Format number with time format.

Ctrl + Arrow key: Move to the next part of text.

Ctrl + Space: Select entire column.

Shift + Space: Select entire row.

Ctrl + -: Delete selected column or row.

Ctrl + Shift + =: Insert a new column or row.

Ctrl + Home: Move to cell A1.

Ctrl + ~: Toggle display of Excel formulas or their values in cells.

F2: Edit the selected cell.

F3: After a name is created, F3 will paste the name.

F4: Repeat last action. For example, if you change text color in another cell, pressing F4 will change text color in the cell to the same color.

F5: Go to a specific cell. For example, C6.

Keyboard shortcuts commonly used in Excel 1F7: Check spelling of selected text or document.

F11: Create a chart from selected data.

Ctrl + Shift + ;: Enter current time.

Ctrl + ;: Enter current date.

Alt + Shift + F1: Insert a new worksheet.

Alt + Enter: Pressing Alt + Enter will create a new line within a cell. Allows for multiple lines of text within a single cell.

Shift + F3: Open Excel formula window.

Shift + F5: Display search box.

In conclusion, using keyboard shortcuts in Excel can save time and increase productivity. Learning and utilizing these shortcuts can help you become a more efficient Excel user.

Rate this post
20
234 Views
Tips for creating a People Graph in ExcelPrevTips for creating a People Graph in ExcelApril 11, 2023
Tips for quickly comparing data tables in ExcelApril 11, 2023Tips for quickly comparing data tables in ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Avast Ultimate Suite 2021 1 Year 10 Devices Global Avast Ultimate Suite 2021 1 Year 10 Devices Global
    Rated 5.00 out of 5
    $54.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
Products
  • Windows 11 Home Key Global 2021 Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $6.00
  • Avast SecureLine VPN 2021 1 Year 5 Devices Global Avast SecureLine VPN 2021 1 Year 5 Devices Global
    Rated 4.91 out of 5
    $34.00
  • Kaspersky Standard - 1 Device, 1 Year (Global License) Kaspersky Standard - 1 Device, 1 Year (Global License) $21.00
  • Avast SecureLine VPN 2021 2 Years 5 Devices Global Avast SecureLine VPN 2021 2 Years 5 Devices Global
    Rated 5.00 out of 5
    $47.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • SQL Server 2019 Standard SQL Server 2019 Standard $20.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • Windows 10 Pro OEM Key Global - Reinstalling win is still active Windows 10 Pro OEM Key Global - Reinstalling win is still active
    Rated 4.88 out of 5
    $6.00
  • Windows Server 2022 Standard Key Global Windows Server 2022 Standard Key Global
    Rated 4.10 out of 5
    $7.00
  • Kaspersky Plus - 1 Device 1 Year - GLOBAL Kaspersky Plus - 1 Device 1 Year - GLOBAL $23.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.