pctechguide.com

  • Home
  • Guides
  • Tutorials
  • Articles
  • Reviews
  • Glossary
  • Contact

Convenient Excel Shortcuts for Quick Formatting

The first version of Microsoft Excel was launched in 1985. The world’s most popular spreadsheeting software has evolved significantly over the past 35 years. Earlier versions of Microsoft Excel were not very user-friendly. New keyboard shortcuts have been introduced over the past few versions, which make the application much easier to use.

We found that a lot of people aren’t familiar with the different Excel shortcuts that are available. We put together a guide on some of the most helpful shortcuts. Afterwards, we realized that it was a lot longer than we expected, so we decided to break it up into two parts. The first part will focus on the benefits of using some of the more common and simpler shortcuts that will help you save time on formatting. Although these shortcuts may not seem like they will save a huge amount of time when they need to be invoked, they will be needed a lot more frequently. The 0.5 seconds that you will save by bolding or underlining a cell with a shortcut command will add up significantly once you realize that you need to use them so often.

The next post is going to cover less common keyboard shortcuts for more complicated issues. You will find that these shortcuts may not be needed as often, but they can really eliminate a lot of frustrations when you do. Adding tables and making multiple formatting changes at once is going to be enough of a challenge as it is, so you might as well know what keyboard shortcuts can make your life easier.   

Here are some of the simpler shortcuts that you should be aware of if you are using Microsoft Excel.

Format cells dialog

The default numerical formatting for cells doesn’t include any decimals or special characters, such as currency signs. If you want to change the formatting, then you will need to invoke the Format Dialog box.

If you don’t want to have to scroll through all of your menus to find the Format Dialog box, then you can simply use the Ctrl + 1 shortcut instead.

Apply or remove bold

Adding bold to your text isn’t as common in Excel as it is in Microsoft Word or many other applications. However, there are still plenty of instances when it is necessary to bold a specific cell.

A keyboard shortcut might not be as big of a timesaver with this function as many others, because the bold button is easily visible from the main menu. Nevertheless, you can still save time by using one of the following keyboard shortcuts:

  • Ctrl + b
  • Ctrl + 2

Either of these shortcuts will have the same effect.

Apply or remove italic

Adding and removing italic text is also occasionally necessary when you are using Excel. You can accomplish this with either of the following keyboard shortcuts:

  • Ctrl + i
  • Ctrl + 3

Apply or remove underline

You will probably need to underline cells more often then you will need to bold or italicize them. Therefore, a keyboard shortcut to underline cells in your Excel document could save you a lot of time. Either of the following shortcuts will accomplish this for you:

Ctrl + u

Ctrl + 4

Add or remove strikethrough

Adding or removing a strikethrough will occasionally be necessary. Although this feature may not be as commonly used, it can be a serious hassle when you do need to use it. The problem is that it can be hard to find the strikethrough button on the main menu, especially if you don’t know what to look for. Don’t worry – there is a keyboard shortcut that makes things a lot easier. You can simply hit Ctrl + 5.

Ctrl + Shift + F

This command will be easier to remember than using the command from your Home menu.

Familiarize yourself with different Excel shortcuts to save time

Creating, editing and formatting Excel documents can be a massive time sink. The good news is that there is a plethora of keyboard shortcuts that make it easy to call the commands that you need to accomplish the necessary tasks. Take some time to learn them. This will save you countless hours over the course of a month.

Filed Under: Communications

Latest Articles

Understanding the Basics of Visual Basic Script

Visual Basic Script, derived from the programming language "Visual Basic".Excerpt from the article "Playing with VBScript: TBS Gladiators": Visual Basic Script (…) comes bundled with Windows operating systems -since about 1996-, and is part of Microsoft's Visual Basic engine -year 1991 to … [Read More...]

Updating Your Creative Soundcard Drivers

It's wise to check periodically to see if updated drives have been released for your sound card. For the Creative Audigy card, this means going to the appropriate Support page for your country or region, and clicking on DOWNLOAD DRIVERS. Make the appropriate selections and click … [Read More...]

Five applications of artificial intelligence in agriculture

Machine learning has affected many industries and agriculture is no exception. In this post, we are going to analyze the advantages of its implementation, as well as the factors that discourage farmers from implementing it. Artificial intelligence creates new possibilities for generating value in … [Read More...]

20 Cool Creative Commons Photographs About the Future of AI

AI technology is starting to have a huge impact on our lives. The market value for AI is estimated to have been worth $279.22 billion in 2024 and it … [Read More...]

13 Impressive Stats on the Future of AI

AI technology is starting to become much more important in our everyday lives. Many businesses are using it as well. While he has created a lot of … [Read More...]

Graphic Designers on Reddit Share their Views of AI

There are clearly a lot of positive things about AI. However, it is not a good thing for everyone. One of the things that many people are worried … [Read More...]

Redditors Talk About the Impact of AI on Freelance Writers

AI technology has had a huge impact on our lives. A 2023 survey by Pew Research found that 56% of people use AI at least once a day or once a week. … [Read More...]

11 Most Popular Books on Perl Programming

Perl is not the most popular programming language. It has only one million users, compared to 12 million that use Python. However, it has a lot of … [Read More...]

10 Exceptional Books on ChatGPT that Will Blow Your Mind

ChatGPT is a powerful new AI tool that is taking the world by storm. You are going to find a lot of amazing books that will teach you how to make the … [Read More...]

Guides

  • Computer Communications
  • Mobile Computing
  • PC Components
  • PC Data Storage
  • PC Input-Output
  • PC Multimedia
  • Processors (CPUs)

Recent Posts

Intel Centrino mobile computer platform

The first generation Centrino platform (codenamed Montara) was announced in March 2003. The trio of systems that comprise … [Read More...]

DVD+R

The first DVD+RW drives had no capability to write to write-once DVD media. However, in early 2002 Verbatim became the … [Read More...]

4 Benefits of Accounts Receivable Management Software

A growing number of companies rely on software to streamline their operations these days. One of the functions many companies use software for is … [Read More...]

[footer_backtotop]

Copyright © 2025 About | Privacy | Contact Information | Wrtie For Us | Disclaimer | Copyright License | Authors