Microsoft Excel Shortcut Keys —

0 views

Skip to first unread message

Hans Dagenais

unread,

Jun 28, 2024, 8:19:46 PM6/28/24

to discbymerif

Microsoft Excel is extensively used across the globe to store and analyze data. Despite various new data analytics tools in the market, Excel remains the go-to product for working with data. It has numerous in-built features, which makes it easier for you to organize your data.

Data in Excel is in the form of rows and columns. Excel is commonly used to record and analyze data, perform mathematical operations, and visualize structured data in charts and graphs. Finally, another important application of Excel is that it helps in automating tasks through excel macros.

Microsoft Excel Shortcut Keys

Download File ===== https://www.google.com/url?hl=en&q=https://urlin.us/2yLW2o&source=gmail&ust=1719706784581000&usg=AOvVaw00D1N1H3TZd5x2mU3C3EmI

Now the question is, if you have to memorize these shortcuts, the answer is no. However, it would be an advantage if you can remember a few of them. With regular practice, you will be able to remember most of the common Excel shortcuts.

A cell in Excel holds all the data that you are working on. Several different shortcuts can be applied to a cell, such as editing a cell, aligning cell contents, adding a border to a cell, adding an outline to all the selected cells, and many more. Here is a sneak peek into these Excel shortcuts.

We will learn how to add a comment to a cell. Comments are helpful when giving extra information about cell content. We will also learn how to find value and replace it with another value in the spreadsheet. After this, we will look into how to insert the current time, current date, activate a filter, and add a hyperlink to a cell. Finally, we will see how to apply a format to the data in a cell.

With our courses, you'll learn to analyze data, create insightful reports, and make data-driven decisions that can help drive business success. Whether you're a beginner or an experienced professional, these courses will help you take your skills to the next level. So why wait? Sign up for Simplilearn's Data Analytics course today and start building the career of your dreams!

Excel shortcut keys will indeed help you build your reports and analysis faster and better. After reading this article, you would have understood the different types of Excel shortcuts related to the workbook, cell formatting, row and column formatting, and pivot tables.

We hope you find these hacks useful and can easily master these shortcut keys by working on excel regularly. Do you have any questions related to this article? If so, then please put it in the comments section of the article and our experts will get back to you at the earliest.

Excel shortcuts are keyboard combinations that allow you to perform tasks quickly and efficiently. They can save you a lot of time, especially if you work with large spreadsheets. For example, instead of clicking on the "Bold" button on the toolbar, you can press Ctrl+B to bold a cell.

Shortcuts are important in Excel because they can help you work more efficiently. By using shortcuts, you can save time and focus on other tasks. They can also help you avoid repetitive strain injuries, as you don't have to use the mouse as much.

You can create your own Excel shortcuts by going to the File menu and selecting Options. Then, click on the Advanced tab and scroll down to the Keyboard shortcuts section. In this section, you can create new shortcuts by clicking on the New button and entering the shortcut key combination and the command that you want to assign it to.

To manage shortcuts in Excel, you can customize or modify existing shortcuts through the Excel Options menu. Simply go to the "Customize Ribbon" section and click on the "Keyboard Shortcuts" button to assign or change shortcuts according to your preference.

There are over 270 Excel shortcuts for both the keyboard and mouse, including shortcuts for the Windows, Mac, and Web versions of Excel. These shortcuts can help you navigate, format, and analyze data more efficiently.

1. How to use "ALT" key in mac. I was using quick access toolbar shortcut like ALT+1, +2, +3 to paste values, formulas, add filters, clear all etc. there was many useful shortcut that i use with ALT key, but i cannot use them anymore. And i was using ALT key to reach ribbon user interface faster. For example ALT + W + F + F if i am not wrong to freeze panels, or ALT + A + L + B to change grouping side to from below to above etc. For a while i don't use them so they can be wrong but i told what my problem is. How can i use ALT key in excel like in microsoft.

2. in mac there is not arrow in the right bottom of ribbon groups that we arrange detailed options for groups. Now i cannot change group side from bottom to top. Instead of bottom side, i wish to change it top that group sign from the 4th row to 1st row.

3. While i was using excel on microsoft, i exported a customization file for my quick access toolbar and ribbon settings with the extension "exportedui" but there is not any option to import it on mac. Is there any way to use it on mac?

3. Probably there is not import option on mac to use it but i wanted to ask it. Even if i arrange it manually again, it still looks i cannot use them effectively because ALT key on Windows doesn't work same as on Mac.

Those restrict me to use excel effectively. I am using excel 2021 on Mac. And even when i want to use get data option, it doesn't let me take data from another excel file. What absurd things these are !

@NikolinoDE by the way i found how to change grouping order.
When i use an application, top tabs change according to this application. And these tabs include features for active application. And there is a Data tab here that hides the feature to arrange grouping order.

Hi there. I researched it more detailed and I have learned that the shortcuts I am trying to use with ALT key in Windows are called as "Accelerator keys" and it is not available on Mac. There is a site that allows you to use them on Mac even if it doesn't include all features in that site.
However i found another way that allows Mac users to customize shortcuts as you want in the site below. I tried to use ALT+W+F+F for freeze panes to do it same like on Windows but you can only use 1 key after modifier keys. So i will assign a few shortcuts to solve the problem that slows me to use excel.

I have an Asus Laptop that I am using for work and the Page Up and Page Down keys are the same button as the Up and Down Arrow keys. When I try to use the "ctrl + pg up" shortcut to switch between excel sheets, excel performs the "ctrl + up arrow" short cut to move between cells instead. Is there a work around for this inconvenience? Thanks!

@HaroldBruijn_saig I am using Asus laptop in my internship so is it possible to use Ctrl+ pg down or up only .I mean to say that page up and page down notes can be activated without fn key ??? Is it possible

I am using a german version, we have different Shortcuts for that (CTRL + . and CTRL + :). It works in 2013 as it worked before. Is your install in the same language as it was before? Maybe consult the help file to find out the correct combination?

I have Excel 2016 in German and I am using a german keyboard. For inputting the current date in an empty cell, I can use Ctrl+Dot as known from previous versions. So, in this case, it's for now an error in online help article regarding Ctrl+Semicolon.

For Excel 2016, there are some more errors in the Online Help Article for the German shortcuts, such as some Alt shortcuts, for example Alt+M which opens the Tell Me Box instead of the formulas tab. I already reported this to the MS localization team and they are going to check this.

In 365 it was until late ( CTRL + ; ) -- Now thanks your post and after some while I find it on ( CTRL + . ) I have but no clue what benefit this change shortcuts around has for an Microsoft employee, for Millions of users searching what it might be today it is a huge waste of time.

It would help those users which travel lots and far and use different types of IT like I do if Microsoft could decide that they like the most. The dot or the semicolon. We are already a global community, thanks also to Microsoft.

I have but to say I am german, have a Ukrainian Laptop with (most probably russian) Windows set to english, (still always russian comments popping up, so I guess it is a russian windows they sold me) - english set Excel 365 and 3 languages permanently in use on an dual language qwerty english keyboard (especially with imprints for the ukrainian language) and using the Microsoft Keyboard Layout creator for adjusting some keys from russian use to ukrainian.

Now I am german, english speaking, living in Ukraine and learning ukrainian as 3rd language, that's still some challenge for the windows world. I do some french but that's nasty on that keyboard (you know these accontegraphs and gs and so :) - that's difficult - especially in google translator, it is always asking the french keyboard. So if I do french all day I could adjust to but like this it is a bit nasty.

So, I am kind of a hardware software language pioneer trying to sort out my crosscultural language minutely changing computer system. Living just in the english world does not really have those problems. So I understand that the Microsoft guys have some problem with it.

Asking for my date in excel, sometimes it does with the : sometimes with the . sometimes it does not do it at all. So I am living with three kind of surprise options. Often now I type it in full because it is faster than to search and hope.