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

i845 Chipset

The fact that system builders were obliged to use expensive DRDRAM - by virtue of the absence of any Pentium 4 chipsets supporting conventional SDRAM - had been an issue ever since the Pentium 4's launch at the end of 2000. The situation changed … [Read More...]

User Account Creation

Launch by clicking Start > Control Panel and User Accounts. From the list of options, click Create a new account. Enter a name for the new account ... ... and click Next. Select the appropriate account type ... ... and click Create Account. A Computer … [Read More...]

Remove InstantRadioPlay Toolbar

InstantRadioPlay Toolbar is another problematic toolbar that promises to offer useful features. It will allow you to listen to the radio online through the toolbar. You may think that is a useful feature, but if you have this toolbar, you should make every effort to remove the InstantRadioPlay … [Read More...]

Why Cross-Chain Trading Is the Future of Crypto Investing?

The rapid growth and evolution of the cryptocurrency market have opened up exciting opportunities for investors. Within this dynamic landscape, … [Read More...]

Revolutionize Your Internet Experience with Orbi 960 – The Ultimate WiFi System

In a world where seamless connectivity is essential, slow and unreliable internet connections are a major problem. Whether you are running a business, … [Read More...]

Do You Need a VPN When Trading Cryptocurrency?

There’s no doubt that the biggest global industries in 2023 are tech-driven, while there remains a significant crossover between many of these … [Read More...]

Goodbye Bitcoin: the 3 alternative cryptocurrencies that have great upside potential, according to experts

Bitcoin has been a very lucrative investment for people that got into it early. One report from The Motley Fool pointed out that $10 of bitcoin … [Read More...]

Self-driving cars face their Achilles’ heel and may be targets of hackers

The market for self-driving cars is booming. Customers spent $22.22 billion on these autonomous vehicles in 2021 and they will likely spend more in … [Read More...]

How to avoid scams with bitcoin and other cryptocurrencies

Cryptocurrencies got a bad reputation when scams multiplied like ants on a piece of cake. Even today many people associate bitcoin and other … [Read More...]

Guides

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

Recent Posts

Two in one Prixton Laptops are available for less than $60

Prixton laptops are really changing the future of the computer market. These new laptops are available for less than $30. They are also two in one … [Read More...]

Developing a Business Continuity Plan – 3 Things to Consider

If you run a business then you may already know the importance of backing up data, securing your network and fending off viruses and hackers. But, … [Read More...]

Tips on How to Land a Remote Job in Cyber Security

The demand for skilled cyber security professionals is growing as well as a number of threats and risks. Any company needs an expert or team to … [Read More...]

[footer_backtotop]

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