How to display columns in Excel: 6 steps (with pictures)

You may come across an Excel spreadsheet with hidden columns. It is very easy to make them appear, regardless of the version of Excel (Windows or macOS).

Steps

Step 1. Open your Excel document

There are two possibilities: either you double-click directly on the document which contains hidden columns or you run Excel first, then you open the document in question from the home page or from the general menu bar.

Step 2. Select the columns on either side of the hidden columns

Hold down the Shift key, then click the column header to the left of the hidden column, then click the column header to the right. The two columns are then highlighted.

Suppose the columns B and VS are hidden (illustration), hold down the Shift key, click TO, then on D.
Special case: if it is the column TO which is hidden, in the white field (formula bar) above the header B, type A1.

Step 3. Click on the Home tab

In the green ribbon, this tab is the second from the left, at the top of the Excel window. In doing so, you bring up the toolbar of the section Home.

Step 4. Click Format

This option is in third position in the group Cells, rather to the right of all groups. A drop-down menu will then appear.

Step 5. Select Hide & Show

You will find this possibility in the menu and in the section Visibility. By clicking on it, a context menu will appear on the right.

Step 6. Click Show Columns

In the menu Hide & show, this option is in fifth position. From then on, the hidden columns of your document are displayed on the screen again.

Advice

If the columns remained hidden after this operation, it is because the width of the columns in question is set to 0. To widen them, bring the mouse cursor over one of the small lines close to the header row, wait for your cursor becomes a double horizontal arrow and by clicking on the mouse, drag the cursor to the right of the desired width.
If you want to display all the hidden columns (dispersed or not) of an Excel spreadsheet, click on the button (black and triangular) Select all which is to the left of the column TO and above the line

Step 1.. Then all you have to do is operate as explained above.

How to make hand sanitizer: 8 steps (with pictures)

When you're in a rush and have nowhere to wash your hands, hand sanitizer will save your life. Sanitizers sold in stores can be overpriced and often have an unpleasant chemical smell. Making your own hand sanitizer is easy, and you can adapt the recipe to your personal needs.

How to write a diary: 15 steps (with pictures)

Diaries are a fantastic tool for discussing your feelings, writing down your dreams and ideas, and reflecting on your daily life in a safe and private space. While there isn't one way to keep a journal, there are a few tips you should know that will help you get the most out of this activity.

How to meditate (with pictures)

The goal of meditation is to increase your focus and understand your own mind. You will eventually reach a higher level of awareness and inner peace. This practice is very old, but scientists have not finished discovering all its benefits. If you meditate regularly, it can help you control your emotions, improve your focus, reduce stress, and even make a better connection with the people around you.

How to download music from Instagram: 9 steps (with pictures)

Did you know that it is possible to download music from an Instagram video? You will need to copy the direct URL of the public post, use an online video downloader, and then convert it to MP3. Then save the file to your computer, tablet or phone.

How to send videos to Discord: 11 steps (with pictures)

You can send a video to someone on Discord using a phone, tablet, or computer. No matter what platform you use, you can share videos up to 8MB in size in a chat channel or direct message. If you want to be able to send larger videos (up to 50MB), you can subscribe to Discord Nitro to increase your file sending limits or upload your video to another site, like Google Drive or Dropbox, before you go.