Skip to content

How To Blog

how to

  • How to Install 64-bit Office via Office 365 Office Tips
  • how to Fix If Face ID isn’t working on your iPhone or iPad 2022 iPad
  • Best eBook Reader Software for Mobile, Laptop or PC Software Reviews
  • How to Get iOS like Magnify Markup on Android How-To
  • 4 Free/Cheaper Rosetta Stone Alternatives Computer Tips
  • Troubleshooting Windows 8 (8.1) “We Weren’t Able to Connect to the Store” Error

    Troubleshooting Windows 8 (8.1) “We Weren’t Able to Connect to the Store” Error

  • Nest vs ecobee – Which Smart Thermostat is Better? Smart Home
  • The Best Smart Lights When Style Matters Smart Home

Top 40 Microsoft Excel Keyboard Shortcuts

Posted on June 22, 2022June 22, 2022 By blog_786 No Comments on Top 40 Microsoft Excel Keyboard Shortcuts

Top 40 Microsoft Excel Keyboard Shortcuts.

Microsoft Excel is a versatile software designed to help anyone who deals with spreadsheets and data professionally or in everyday life. It allows you to organize and store your data and perform complex mathematical calculations using formulas and functions. What’s even cooler is that Excel can also help you visualize your data and projects with pie charts, Gantt charts, flow charts, and just about every type of chart you can imagine.

Read :The best keyboard shortcuts required for Microsoft Word for better progress

Microsoft Excel was originally designed for data entry, but the software has since expanded to accommodate everything from accounting, task management, and financial modeling to event programming. This means that it is not the easiest software to use. To work effectively in Excel, you need to use keyboard shortcuts, and that’s what we’ll be focusing on in this article.

Top 40 Microsoft Excel Keyboard Shortcuts

Why Do You Need Keyboard Shortcuts?

Even if you know what Microsoft Excel is and have used it extensively in the past, you might still be surprised by all the features and shortcuts you can use to get things done quickly and efficiently. Excel has hundreds of keyboard shortcuts and shortcuts, but don’t worry, you don’t have to memorize them all.

You will use some Excel keyboard shortcuts more than others. So, let’s focus on the most important ones that you will need on a daily basis.

Commonly Used Excel Shortcuts

You are probably familiar with some keyboard shortcuts as they are commonly used in most Windows 10/11 and Microsoft Office applications. However, here is a helpful table with the most commonly used Excel keyboard shortcuts that you need to start using to quickly improve your spreadsheet prowess.

Ctrl+ASelect AllCtrl+CCopyCtrl+VPaste

Ctrl+XCutCtrl+ZUndoCtrl+YRedoCtrl+BBoldCtrl+IItalicizeCtrl+UUnderline Alt +HGo to Home tabDelete (or DEL)Delete content in cellCtrl+OOpen workbook Ctrl+WClose workbookAlt+H+HSelect cell fill color

These shortcuts are handy, and you should get used to using them not only in Excel, but also in Microsoft Word, Internet browsers, or any other application that you often use for work or play.

Pivot Table Shortcuts in Excel

The pivot table is a powerful tool in Excel. It can sum selected rows and columns of a spreadsheet, or even reorganize them. Pivot tables are handy if you have long rows of data that need to be summarized, and they also allow you to compare your data. If you find yourself using a lot of PivotTables, start using the keyboard shortcuts below regularly.

Right-click to access the context menu for the selected row, column, or cell.

Ctrl +DDelete tableCtrl+MMove tableCtrl+RRename table

Alt+Shift+Right ArrowGroup selected PivotTable itemsAlt+Shift+Left ArrowUngroup selected PivotTable items.

Now that you know the basic keyboard shortcuts, let’s focus on other Excel keyboard shortcuts that will increase your productivity and speed.

Shortcuts for Navigating in Excel

Navigate Excel and switch between worksheet tabs faster using the following keyboard shortcuts.

Ctrl+Page UpPress this command combination to switch worksheet tabs to the right.Ctrl+ Page DownThis command will switch the worksheet tabs to the left.Ctrl+BackspaceThis keyboard shortcut will show you which cell is active. F11 The F11 key will create a new diagram. This is a great shortcut that will allow you to skip all Excel toolbar navigation.Ctrl+FPress this keyboard shortcut to quickly access the search function.

Ctrl+QQuick access to the help function in Excel.Ctrl+arrow keyGo to the last filled cell in the direction of the arrow key. For example, Ctrl+Right Arrow will move you to the last cell on the right, and Ctrl+Down Arrow will select the last cell below. Ctrl+F12This command quickly opens the Open File dialog box and allows you to access another book.Ctrl+F1This key combination toggles the display of feeds.

Shortcuts for Selecting Items in Excel

Save time by selecting columns and rows faster by using the following keyboard shortcuts instead of clumsy mouse movements.

Ctrl+SpacePress Ctrl+Space to select an entire column. You no longer need to use the heading and navigate with the mouse.Shift+SpacePress Shift+Space to select the entire line.Ctrl+ 0This simple shortcut will hide all selected columns.

Shortcuts for Functions and Formulas in Excel

Excel mainly consists of formulas and functions. Stop typing them variable by variable and boost your productivity with the keyboard shortcuts below.

Ctrl+’Switch between showing all formulas on the worksheet. Alternatively, you can click a cell to display the formula in the formula bar.Ctrl+Alt+F9Use this keyboard shortcut when you need to calculate all the formulas in all your active workbooks. Ctrl+Shift+$To automatically convert a cell to currency, select it and press Ctrl+Shift+$. It can also work with multiple cells while they are selected.Ctrl+Shift+%This keyboard shortcut applies a percentage format to the selected cell.Alt+ =This label will automatically insert the SUM() function. This is arguably the most used formula in Excel and needs to have a shortcut.

The Sum() function automatically sums data across multiple columns and rows. Just be sure to select one extra column on the right and one extra row at the bottom. Excel will use them to display the summary data.Alt+H+O+IThis keyboard shortcut is a combination of keystrokes that executes a function in sequence. First, press Alt + H to select the Home tab, then press O while holding the Alt key to select the formatting menu. Finally, press I to automatically fit the column width.

Remember to hold your finger on the Alt key as you press each letter.Ctrl+[This keyboard shortcut allows you to see which cells are referenced by other cells. This is especially useful if you are working with complex formulas.Ctrl+Shift+JUse this keyboard shortcut to see a list of all the constants in your worksheet. Alt+MOpen the formulas tab.Shift+F3Press Shift+F3 to open the insert function window to insert a function.

Time and Date Shortcuts in Excel

Instantly log various actions using the time and date keyboard shortcuts below.

Ctrl+Shift+#This keyboard shortcut will allow you to change the date [email protected]

Pressing a combination of these keys will allow you to quickly access the style of the time of day. From here, you can go ahead and add it to the selected cell. Ctrl+;Would you like to add the current date to your Excel spreadsheet? Just click this shortcut to quickly add it.Ctrl+Shift+;This function will place the exact current time in the selected cell.

Editing Shortcuts in Excel

Editing cells, rows, columns, and comments can be very time consuming. Increase speed with the following keyboard shortcuts.

Ctrl+1Open the cell formatting dialog box. This shortcut will allow you to make changes to the appearance of a cell.Ctrl+KIf you select a cell or data entered in a cell and use this shortcut, a hyperlink box will open. Copy and paste the hyperlink into the box (using the copy/paste keyboard shortcuts for extra practice).F2This should be one of the most used Excel keyboard shortcuts as it will allow you to edit the cell . Use it to quickly make changes.F4The F4 key will repeat your last action. Whether it’s a formula or editing, this key will copy the action and save you a lot of time.Ctrl+Plus (+)Quickly insert new rows and columns with the Ctrl key shortcut. Ctrl+minus (-)Press Ctrl+- to delete a row or column.Shift+F2Insert a comment or edit an existing comment in the selected cell.

Formatting Shortcuts in Excel

Formatting Excel data makes it readable and presentable. But that doesn’t mean you have to waste time, so start using the keyboard shortcuts below.

Ctrl+Shift+&This Excel keyboard shortcut quickly applies borders to the selected cell. This is very useful if you want your spreadsheet to be neatly organized and look attractive.Ctrl+Shift+_To quickly remove borders, select the desired cells and press this keyboard shortcut. . Ctrl+Shift+~This keyboard shortcut will give the selected cell or group of cells a general format.

Keep in mind that the general format is the default format, meaning you get the numbers you enter and nothing else.Ctrl+Shift+^This command applies exponential format to the cell you select. Ctrl+Shift+!This keyboard shortcut applies the comma formatting style to the selected cell. For example, when a number in a cell is over 1000, this command will display it with a comma as 1000. Use this shortcut to visualize numbers.

Whether you’re a spreadsheet wizard or a one time blue moon user of Excel, knowing a few shortcuts will make your job a lot easier and take less time. Share your favorite Excel keyboard shortcuts and keyboard shortcuts in the comments below!

Top 40 Microsoft Excel Keyboard Shortcuts

Top 40 Microsoft Excel Keyboard Shortcuts

MS Office Tips Tags:Excel, Keyboard, Microsoft, Shortcuts

Post navigation

Previous Post: Best Sites for Travel Deals 2022
Next Post: How to Connect a Nintendo Switch Controller to a PC

Related Posts

  • How to Hide Sheets, Cells, Columns, and Formulas in Excel MS Office Tips
  • Charting Your Excel Data MS Office Tips
  • Microsoft Word Not Responding? 8 Ways To Fix It MS Office Tips
  • Turn Caps Lock Text back to Normal in MS Word MS Office Tips
  • The best keyboard shortcuts required for Microsoft Word for better progress MS Office Tips
  • How To Sync Outlook Contacts With Android, iPhone, Gmail & More iPhone

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

  • Apple Watch
  • Computer Tips
  • Cool Websites
  • Free Software Downloads
  • Gadgets
  • Gaming
  • General Software
  • Google Software/Tips
  • Hardware
  • How-To
  • iOS
  • iPad
  • iPhone
  • Linux Tips
  • macOS
  • MS Office Tips
  • Networking
  • Product Reviews
  • Reviews
  • Safari
  • Smart Home
  • Smartphones
  • Software Reviews
  • technology
  • text
  • Tutorials
  • Uncategorized
  • Urdu Books PDF
  • Web Site Tips
  • Windows
  • Windows 10
  • January 2023
  • December 2022
  • November 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • December 2019
  • July 2019
  • May 2019
  • April 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018

2021 Android ) Apple apps Best browser change Chrome Closing words Concluding remarks Download email Error Facebook From Google Image Internet Keyboard Mac make Movies Music online Packaging phone? Photos Print Search Shortcuts sites Switch Time Tips Tricks turn using Video Videos Watch What With Working? your YouTube

  • 5 Easy Ways to Make Money Online technology
  • Change or Remove Headers and Footers When Printing in Internet Explorer or Edge How-To
  • How to fix Touch ID that doesn’t work on Mac Uncategorized
  • Best calculator ti-84 plus 2020

    Best calculator ti-84 plus 2020

  • How To Use TikTok On PC Cool Websites
  • How to Fix Instagram Lagging on iPhone and Android iPhone
  • Is Your TV Screen Blurry or Fuzzy? Try These 10 Fixes Computer Tips
  • Best ti 84 calculator case 2020

    Best ti 84 calculator case 2020

Copyright © 2023 How To Blog.

Powered by PressBook News WordPress theme

Manage Cookie Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage vendors Read more about these purposes
View preferences
{title} {title} {title}
Go to mobile version