pctechguide.com

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

Excel Shortcuts for More Complicated Commands

We previously wrote an article on the benefits of using keyboard shortcuts in Excel. The shortcuts we focused on were used for simple formatting options. However, there are other shortcuts that are valuable for more complicated challenges. You can read more about them below.

Display Format Cells box while keeping the Fonts Tab active

Navigating the formatting process in Excel can be exceedingly tedious at times. One of the challenges that you will face is trying to apply multiple formatting commands at one time. When you try calling the format cells box, it often closes the fonts tab. This can be a painstaking process, because you will need to keep switching between the two windows.

There is a simple keyboard shortcut that enables you to keep both windows open simultaneously. All you need to do is press:

  • Ctrl + Shift + f

This command enables you to keep both of them open at once, which makes editing much easier.

Change the font size

This is another feature in Excel that is not too difficult to use, but still takes more time than the other standard formatting commands. The font size drop-down icon is easily accessible from the main menu. However, there are going to be times when you want to use a keyboard shortcut instead of having to move your mouse to the drop-down.

You can simply click the tab three times. You will then be able to easily change the font size by pressing the appropriate numerical characters from your keyboard.

Adding borders to your cells

Are you trying to add borders to the outside of your cells? There are some easy to use keyboard shortcuts that make it a lot easier. This is one of the more convenient shortcuts, because finding the appropriate icons in your main menu can be a huge hassle if you don’t know what to look for.

The shortcuts that you need to use are going to depend on whether you are using a PC or a Mac. If you are using a PC, then you will need to press either Alt + H or Alt + B. Both commands will have the same effect.

What if you have a Mac? Then you will need to press the following: COMMAND + Option + 0.

You will be able to easily add borders to the outside of your cell by pressing these buttons.

Insert a table

Inserting a table into Microsoft Excel is going to be one of the most annoying processes. You can cut the amount of time that it takes you in half by using a handy keyboard shortcut.

This is another keyboard shortcut that is going to depend on the machine that you are using.

If you are using a PC, then you are going to need to press:

  • Ctrl+T

MAC users will need to use the following command instead:

  • ^T

There is no reason to make the process of creating tables more difficult than it needs to be. You might as well take advantage of these keyboard shortcuts.

Select an entire row to modify

Most commands in Excel are used to make changes to single cells. However, there are going to be times when you need to edit an entire row instead. You could do this by clicking the number corresponding to that row in the far left of your Excel application window. However, if you already have your cursor in a cell within the row that you intend to edit, then you can use a simple keyboard shortcut to edit it instead.

What is the keyboard shortcut if you have a PC? It is:

  • Shift+Space

But what if you are using a Mac instead? Then you will need to press the following:

  • ?+Space

Select an entire column to edit

You can also choose to edit an entire column at one time. If you are using a PC, then you can select a column by pressing:

  • Ctrl + Space

The keyboard shortcut if you are using a Mac is:

  • ?+Space

Just make sure that your cursor is in the cell within the column that you would like to edit first.

Filed Under: Communications

Latest Articles

How To Install Drivers For Your Creative Sound Card

Its necessary to install device drivers and applications to use the Sound Blaster Audigy. The following instructions - applicable to all supported Windows operating systems - describe how to install these drivers and associated bundled applications: After installation of the Sound Blaster … [Read More...]

Macs Get Viruses Too – So Take Precautions

I recently talked to a colleague in Spain about the cybersecurity landscape over there. He made a good point about the fact that Macs are believed to be a lot more secure than they actually are. A lot of this is due to misinformation that originated in the United States, which led to Mac users in … [Read More...]

Slow Computer

5 Tips to Cure PC Slowness

Today's PCs are designed to be fast and agile. No one wants a computer that takes ages to boot up and even longer to load web pages. This isn't the 90s anymore where slow computers were more common. But, sometimes a computer can get gummed up and may need a little TLC to get it back to its old self. … [Read More...]

Why Internet Bundles Are the Next Battleground for Gamers

A weak internet connection can turn seamless gaming sessions into frustrating experiences filled with lag, buffering or sudden disconnects. For … [Read More...]

Importance of Inbound Marketing in the Digital Age

A couple of months ago, Zacks reported that Hubspot was starting to make some major changes to its inbound marketing strategy. They talk a lot about … [Read More...]

Damage Control Strategies for Resolving Online PR Crises

Last July, Astrologer faced a major crisis after its CEO went viral at a ColdPlay concert when having an affair. This was just one of the many times a … [Read More...]

AI is Not Killing Computer Jobs Like Doomers Projected

There is no denying the reality that AI technology has played a massive role in disrupting our lives. A growing number of people claim that AI … [Read More...]

Everything You Need to Know About Sourcing Circuit Boards From U.S. Suppliers

In This Article This article includes: Why Source PCBs From the United States?How to Get a Quote From a U.S.-Based PCB ManufacturerThe Top U.S. … [Read More...]

Top Taplio Alternatives in 2025 : Why MagicPost Leads for LinkedIn Posting ?

LinkedIn has become a strong platform for professionals, creators, and businesses to establish authority, grow networks, and elicit engagement. Simple … [Read More...]

Guides

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

Recent Posts

Rango Protection 2014 – Antispyware 2014

Rango XP Protection 2014 is known as malware. This is a fake antivirus client that get's installed normally through a trojan virus. In most cases the … [Read More...]

Disabling and Uninstalling Soundcards

You first need to remove or disable any existing audio components. Under Windows XP, invoke Device Manager by right-clicking My Computer > … [Read More...]

Driver Detective Review

Updated review for the latest Driver Detective version in 2015 PROS: Driver Detective is very easy to use. It has a quick installation process and … [Read More...]

[footer_backtotop]

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