How To Unhide All Rows In Excel
Unhide all rows and columns – This is your one-stop solution for unhiding all the rows and columns in your spreadsheet. You don’t have to look for anything or spend a second thinking if you “dragged over” all the rows that could have a hidden row in between. Kasper Langmann, Microsoft Office Specialist Here’s how to unhide all the hidden rows and all the hidden columns in one fell swoop.1. Select all the cells in the spreadsheet by clicking the ‘Select All’ button. Or you can use the Ctrl + A shortcut.2. Right-click any of the selected rows and click Unhide. This unhides all the hidden rows.3. Right-click any of the selected columns and click Unhide. This unhides all the columns. And that’s how you unhide all rows and columns at once🔍

Why can’t I unhide all rows in Excel?

An error occurred. – Try watching this video on www.youtube.com, or enable JavaScript if it is disabled in your browser. If rows are hidden from row 1, it is important to correctly highlight the rows and right click on the correct row. In the example below, you need to highlight all the rows above 9.

You do this by left clicking on the number 9 and dragging up, BUT then you right click while hovering over the 9 again. If you right click in the top left corner it highlights everything again and you can’t find the UNHIDE option. If you try the above and it does not work, it is possible that you have frozen panes which make it look like the row is hidden but it is frozen.

Go to the VIEW and FREEZE PANES buttons. If it says ‘Unfreeze Panes’ then this is the problem. Once you unfreeze them you will be able to scroll upwards and see the hidden rows. If neither of these work, it may just be that the row heights are so small it looks like it is hidden.

What is the shortcut to unhide all in Excel?

How to unhide all Excel rows and columns with a shortcut key? The steps to unhide all rows and columns with a shortcut key are listed as follows: Select the entire worksheet by either clicking the triangle to the left of column A or pressing ‘Ctrl+A.’ Press the shortcut ‘ Ctrl+Shift+9 ‘ to unhide all rows.

Is there a way to unhide all columns in Excel at once?

Shortcuts to Unhide All Columns in Excel If you’ve ever hidden a column in Microsoft Excel only to find that you can’t unhide it using the usual methods, you’re not alone. It’s a common problem that can be frustrating, especially if you can’t remember which column you hid or how many columns you hid.

  1. Fortunately, there are a few shortcuts that can help you unhide all columns in Excel, no matter how many you’ve hidden or where they’re located.
  2. Here’s a look at a few of the most effective methods.
  3. One of the quickest and easiest ways to unhide all columns in Excel is to use the keyboard shortcut Ctrl+Shift+0 (zero).

This shortcut will unhide any hidden columns to the left of the active cell. If there are no hidden columns to the left of the active cell, Excel will unhide all columns in the worksheet. Another keyboard shortcut that can be used to unhide all columns in Excel is Ctrl+A.

This shortcut selects all cells in the worksheet, including hidden cells. Once all cells are selected, you can use the Unhide command on the Format menu to unhide any hidden columns. Be aware that using this shortcut also selects all cells in the worksheet, which can be undesirable in some situations.

If you know which column is hidden but can’t remember how many columns are hidden to the left or right, you can use the Go To command on the Edit menu to quickly select the hidden column. Once the hidden column is selected, you can use the Unhide command on the Format menu to unhide it.

You can also select multiple columns by holding down the Shift key while you use the Go To command to select each column you want to unhide. If you’ve hidden multiple columns and can’t remember which ones they are, you can use the Find and Replace dialog box to quickly unhide all hidden columns. To do this, open the Find and Replace dialog box by pressing Ctrl+F.

In the Find what field, type a space followed by an asterisk (*). In the Replace with field, type a space followed by an asterisk (*). Then click the Replace All button. This will replace all spaces with asterisks, which will unhide any hidden columns. If you’ve hidden multiple columns and can’t remember which ones they are, you can use the Go To command on the Edit menu to quickly select the hidden columns.

To do this, open the Go To dialog box by pressing Ctrl+G. In the Reference field, type the cell address of the first hidden column. Then click the OK button. This will select the first hidden column. To select additional hidden columns, hold down the Shift key while you use the Go To command to select each column you want to unhide.

If you’ve hidden multiple columns and can’t remember which ones they are, you can use the Find and Replace dialog box to quickly unhide all hidden columns. To do this, open the Find and Replace dialog box by pressing Ctrl+F. In the Find what field, type a space followed by an asterisk (*).

In the Replace with field, type a space followed by an asterisk (*). Then click the Replace All button. This will replace all spaces with asterisks, which will unhide any hidden columns. If you’ve hidden multiple columns and can’t remember which ones they are, you can use the Go To command on the Edit menu to quickly select the hidden columns.

To do this, open the Go To dialog box by pressing Ctrl+G. In the Reference field, type the cell address of the first hidden column. Then click the OK button. This will select the first hidden column. To select additional hidden columns, hold down the Shift key while you use the Go To command to select each column you want to unhide.

  • If you’ve hidden multiple columns and can’t remember which ones they are, you can use the Find and Replace dialog box to quickly unhide all hidden columns.
  • To do this, open the Find and Replace dialog box by pressing Ctrl+F.
  • In the Find what field, type a space followed by an asterisk (*).
  • In the Replace with field, type a space followed by an asterisk (*).

Then click the Replace All button. This will replace all spaces with asterisks, which will unhide any hidden columns. If you’ve hidden multiple columns and can’t remember which ones they are, you can use the Go To command on the Edit menu to quickly select the hidden columns.

To do this, open the Go To dialog box by pressing Ctrl+G. In the Reference field, type the cell address of the first hidden column. Then click the OK button. This will select the first hidden column. To select additional hidden columns, hold down the Shift key while you use the Go To command to select each column you want to unhide.

If you’ve hidden multiple columns and can’t remember which ones they are, you can use the Find and Replace dialog box to quickly unhide all hidden columns. To do this, open the Find and Replace dialog box by pressing Ctrl+F. In the Find what field, type a space followed by an asterisk (*).

  • In the Replace with field, type a space followed by an asterisk (*).
  • Then click the Replace All button.
  • This will replace all spaces with asterisks, which will unhide any hidden columns.
  • If you’ve hidden multiple columns and can’t remember which ones they are, you can use the Go To command on the Edit menu to quickly select the hidden columns.
You might be interested:  How To Unpair Apple Watch Without The Phone?

To do this, open the Go To dialog box by pressing Ctrl+G. In the Reference field, type the cell address of the first hidden column. Then click the OK button. This will select the first hidden column. To select additional hidden columns, hold down the Shift key while you use the Go To command to select each column you want to unhide.

  • If you’ve hidden multiple columns and can’t remember which ones they are, you can use the Find and Replace dialog box to quickly unhide all hidden columns.
  • To do this, open the Find and Replace dialog box by pressing Ctrl+F.
  • In the Find what field, type a space followed by an asterisk (*).
  • In the Replace with field, type a space followed by an asterisk (*).

Then click the Replace All button. This will replace all spaces with asterisks, which will unhide any hidden columns. If you’ve hidden multiple columns and can’t remember which ones they are, you can use the Go To command on the Edit menu to quickly select the hidden columns.

To do this, open the Go To dialog box by pressing Ctrl+G. In the Reference field, type the cell address of the first hidden column. Then click the OK button. This will select the first hidden column. To select additional hidden columns, hold down the Shift key while you use the Go To command to select each column you want to unhide.

If you’ve hidden multiple columns and can’t remember which ones they are, you can use the Find and Replace dialog box to quickly unhide all hidden columns. To do this, open the Find and Replace dialog box by pressing Ctrl+F. In the Find what field, type a space followed by an asterisk (*).

In the Replace with field, type a space followed by an asterisk (*). Then click the Replace All button. This will replace all spaces with asterisks, which will unhide any hidden columns. If you’ve hidden multiple columns and can’t remember which ones they are, you can use the Go To command on the Edit menu to quickly select the hidden columns.

To do this, open the Go To dialog box by pressing Ctrl+G. In the Reference field, type the cell address of the first hidden column. Then click the OK button. This will select the first hidden column. To select additional hidden columns, hold down the Shift key while you use the Go To command to select each column you want to unhide.

If you’ve hidden multiple columns and can’t remember which ones they are, you can use the Find and Replace dialog box to quickly unhide all hidden columns. To do this, open the Find and Replace dialog box by pressing Ctrl+F. In the Find what field, type a space followed by an asterisk (*). In the Replace with field, type a space followed by an asterisk (*).

Then click the Replace All button. This will replace all spaces with asterisks, which will unhide any hidden columns. If you’ve hidden multiple columns and can’t remember which ones they are, you can use the Go To command on the Edit menu to quickly select the hidden columns.

  1. To do this, open the Go To dialog box by pressing Ctrl+G.
  2. In the Reference field, type the cell address of the first hidden column.
  3. Then click the OK button.
  4. This will select the first hidden column.
  5. To select additional hidden columns, hold down the Shift key while you use the Go To command to select each column you want to unhide.

If you’ve hidden multiple columns and can’t remember which ones they are, you can use the Find and Replace dialog box to quickly unhide all hidden columns. To do this, open the Find and Replace dialog box by pressing Ctrl+F. In the Find what field, type a space followed by an asterisk (*).

In the Replace with field, type a space followed by an asterisk (*). Then click the Replace All button. This will replace all spaces with asterisks, which will unhide any hidden columns. Excel is a powerful tool that can help you manage and analyze data with ease. However, sometimes you may find yourself struggling to navigate through a large spreadsheet with hidden columns.

Fortunately, there are several shortcuts that can help you unhide all columns in Excel quickly and efficiently.

Why does Ctrl Shift 0 not work?

Ctrl+Shift+0 not accepted as key command (due to Windows and Office programs) Cubase 12.0.50 on Windows 10. I wanted to assign a key command to a macro and chose Ctrl+Shift+0. However, the dialogue box didn’t recognize the key combo. Alt+Shift+0, Ctrl+0, Ctrl+Shift+9, etc. and other combinations seem to be recognized. Just not Ctrl+Shift+0. Can anyone confirm or provide a reason? Thanks! EDIT: I did try combinations of the left and right side Ctrl and Shift keys too. No change.2 Likes I’m on Nuendo and Win 11, but it works for me Weirdness. I was able to reproduce in Cubase, so I tried to figure out what was going on- checked a bunch of things, to no avail, and figured I’d come back to it later and try to solve. In the mean time I restarted my machine, I saw ‘s reply, and tried again – now the shortcut works.1 Like Interesting. Restarted computer. No change for me though. Does it work in other applications? Is there any keyboard layout switch software in use? 1 Like OK. It’s a Windows thing. Go to Language Settings > Keyboard > Input language hot keys > Advanced Key Settings. Change the key sequence for “Between input languages” to Not Assigned. Apparently this was a problem in Excel, which is where I found posts with the solution. Just posting to say that there might also be another cause. I had checked that Windows setting (and other MS Office related ones, and there was no assignment. There are some very low-level, difficult to reconfigure keyboard shortcuts for the MS Office products, including this shortcut:, (yes, just those modifier keys). My point is that MS is binding keystrokes in a way that’s meant to be opaque to the user, so it’s difficult or impossible to change.3 Likes steve:, (yes, just those modifier keys). Am I the only one who finds it extremely funny that a combination of keys clustered together (so probably best to hit with a flat palm or fist) launches Linkedin? “THAT DOES IT! I QUIT!” WHACKS KEYBOARD Browser: >Please edit your Linkedin profile.2 Likes Actually, those four keys, held down with none other, launches MS Office, and if that is not installed, opens their website. Yes, very annoying for anyone who does lots of keystroke customization. Then, append various keys to launch the individual programs I took me a while to find a fix, and in the meantime I did workarounds to hide the effect, including an ahk timer that closes the window that opens within 100 milliseconds, and, I actually made a hosts entry to redirect the url to localhost. The fix was to run this command (as admin) from a,reg file or cmd prompt. REG ADD HKCU\Software\Classes\ms-officeapp\Shell\Open\Command /t REG_SZ /d rundll32 1 Like If only they would ask first. My biggest gripe with Windows key management is NumLock not allowing shift to work. It stills gives me pause why recall marker X doesn’t work. (Shift+NumPad 1-9) And then after a few seconds I remember: “aaah, it’s because Num Lock is on.) This is why I use ahk – to “fix” 1 Like : Ctrl+Shift+0 not accepted as key command (due to Windows and Office programs)

How do I select all hidden objects in Excel?

CTRL+G > Special > Objects to select all objects and delete. Home tab > Find and Select > Selection Pane to do it selectively.

Which shortcut is used to hide or unhide?

8. Alt + H + O + H – This shortcut key allows you to hide the selected worksheet in Excel. Simply select the worksheet you want to hide and press Alt + H + O + H. To unhide the worksheet, right-click on any worksheet tab and select Unhide. Then, select the worksheet you want to unhide and click OK.

How do you quickly hide and unhide columns in Excel?

How to hide unused columns in Excel – To make only the working area of your sheet visible, you can hide all unused (blank) columns to the right of your data. Here’s how:

  1. Select the column to the right of the last column with data.
  2. Press Ctrl + Shift + Right Arrow to highlight all the unused columns to the end of the sheet.
  3. Press the Ctrl + 0 key combination to hide the selected columns. Done!
You might be interested:  How Much Does It Cost To Resize A Ring?

As the result, the workspace is cleaned up and only the relevant information is displayed to the users:

Why won’t columns unhide in Excel?

Unhide Columns in Between Selected Columns – There are also several ways that you can unhide columns within selected columns in Excel. The methods listed below are handy when trying to unhide specific columns in Excel, Using a Keyboard Shortcut.

  • Choose the columns that contain your hidden columns within them.
  • Hold down ALT H, then ALT O, ALT U, and ALT L.
  • If you execute this correctly, your columns will instantly unhide themselves.

Using the Mouse. One fast way to unhide a chosen column in Excel is with your mouse. Hover the mouse between the two lettered columns containing a hidden column. For example, hover your mouse between Columns C and E if Column D is hidden. You will notice a double-line icon. Using the Format Option in the Ribbon. From the home tab, several options exist to hide and unhide columns in Excel. Choose the columns where there are hidden in between.

  • Select the Home tab.
  • From the Cells group, select Format.
  • Hover your cursor on the Hide and Unhide option.
  • Select “Unhide Columns.”

By Changing the Column Width. If none of the other options have worked for you to unhide columns in Excel, it might be that your cue is not hidden, and the honesty column width might have changed to 0. In this instance, even if you press unhide, the width will not change from 0, and you can’t select or see it. To do this:

  • From the name box, type your cell address in that column. For example, if your column is column D, type D1.
  • While the column isn’t visible, the cursor will go in between C1 and E1.
  • Select the Home tab.
  • From the Cells group, select the Format option.
  • Select the Column Width choice, and the dialogue box will appear.
  • Enter your chosen column width value to make it visible.

What is the shortcut to expand all rows?

15 essential Excel shortcuts for expanding columns If you work with data in Microsoft Excel, you know how important it is to be able to quickly and easily expand or collapse columns. After all, data sets can often be very large, and scrolling back and forth between different parts of the sheet can be time-consuming and frustrating.

  1. That’s why we’ve put together this list of 15 essential Excel shortcuts for expanding and collapsing columns.1.
  2. To expand the width of a column to fit its contents, simply double-click on the right-hand border of the column header.2.
  3. To collapse a column, so that it’s width is reduced to the minimum necessary to fit its contents, simply double-click on the left-hand border of the column header.3.

To quickly expand or collapse all columns on a sheet, use the keyboard shortcut Ctrl+A (select all), then double-click on the right-hand border of any column header.4. To expand or collapse all columns to a specific width, select all columns (Ctrl+A), then double-click on the right-hand border of the column header and enter the desired width.5.

To quickly expand or collapse all rows on a sheet, use the keyboard shortcut Ctrl+A (select all), then double-click on the bottom border of any row header.6. To expand or collapse all rows to a specific height, select all rows (Ctrl+A), then double-click on the bottom border of the row header and enter the desired height.7.

To expand or collapse all cells in a selection, use the keyboard shortcut Ctrl+A (select all), then double-click on the right-hand border of any cell.8. To quickly expand or collapse all cells in a selection to a specific size, select all cells (Ctrl+A), then double-click on the right-hand border of the cell and enter the desired width and height.9.

To expand or collapse all cells in a sheet to a specific size, use the keyboard shortcut Ctrl+A (select all), then double-click on the right-hand border of any cell and enter the desired width and height.10. To quickly expand or collapse all rows and columns in a sheet, use the keyboard shortcut Ctrl+A (select all), then double-click on the right-hand border of any cell.11.

To expand or collapse all rows and columns in a selection to a specific size, select all cells (Ctrl+A), then double-click on the right-hand border of the cell and enter the desired width and height.12. To quickly expand or collapse all cells in a sheet, use the keyboard shortcut Ctrl+A (select all), then double-click on the right-hand border of any cell, then press the Enter key.13.

To expand or collapse all cells in a selection to a specific size, select all cells (Ctrl+A), then double-click on the right-hand border of the cell, then press the Enter key and enter the desired width and height.14. To quickly expand or collapse all rows and columns in a sheet, use the keyboard shortcut Ctrl+A (select all), then double-click on the right-hand border of any cell, then press the Enter key.15.

To expand or collapse all rows and columns in a selection to a specific size, select all cells (Ctrl+A), then double-click on the right-hand border of the cell, then press the Enter key and enter the desired width and height. Excel is a powerful tool for organizing and analyzing data, but it can be time-consuming to manually adjust column widths to fit your data.

What is the shortcut to make all rows the same size in Excel?

How to Change Row Height in Excel? 5 Easy Ways (Note: This guide on how to change row height in Excel is suitable for all Excel versions including ) Excel consists of a multitude of cells. These cells are arranged in rows and columns for easy data entry and retrieval.

By default, the rows and columns appear with a specific height and width. Sometimes, when you enter data in the cells, the rows and columns might adjust to the height and width of the content. In most cases, the content will be hidden unless you enter the edit mode or double-click on the cell. In some cases, this can even cause a # error.

When the data in multiple cells exceed the display width, it’ll be hard to view the data. This hinders the readability of the data and makes the data look incomplete.

  • In such cases, you can change the row height or the column width to make the data in the cell easily readable to the user.
  • In this article, I will tell you how to change row height in Excel.
  • You’ll Learn:
  • Watch this short video on How to Change Row Height in Excel
  1. Related Reads:

There are a variety of ways to change row height in Excel. Some methods are used to change the row height for particular cells, whereas others help to change the row height or column width to suit the data in the cells. Let us see each method in detail with an example. Consider an Excel workbook that has the following data. Example At first glance, it seems as though the data perfectly fit in each cell. Upon taking a closer look, it can be seen that the data visible to the user is not the actual data. Some of the text is hidden within the cells, which makes it difficult for the reader to understand and infer the contents of the cell.

First, identify the cell that you want to change the height or width of.

If you want to change the row height, place your cursor on the row headings on the left side of the sheet. And, in case you want to change the column width, move the cursor to the column headings on the top of the sheet.

Click and drag the row or column headers

Once you hover over the row or column headers, you can see the mouse pointer change to a double-sided resize pointer.

Now by holding the left mouse button, drag to the desired height/width.

You might be interested:  How To Tell If A Dog Is Having A Seizure While Sleeping?

This sets the height of the particular row.

In the same way, you can set the column width to get a perfect readable view. Change row height in Excel by clicking and dragging This method is a simple and easy method to change the row height. However, one drawback to this method is that when data is large, you have to click and drag every row. Also, when you change the height of one particular row, the other row’s height might get altered.

Place the mouse pointer in between the rows where you want to change the height.

You can see the mouse pointer change to a double-sided resize pointer.

Double click on the place and you can see the row height change to fit the content in the cell. You can see that if the row or column is expanded, double-clicking on the row shortens it. On the other hand, if the row is shortened, double-clicking expands it.

Note: To adjust the row height for multiple cells together, select all the cells and double-click on the row header. In most cases when changing the row height, you would aim to make the contents of the cell visible. Double-clicking on the rows/column fits the rows and columns to the perfect height. Let us see how.

Select the cells you want to adjust the height.

Navigate to Home, Under the Cells section, click on the dropdown from Format,

Since we want to adjust the row height, click on AutoFit Row Height,

Change row height in Excel using AutoFit Rows

This instantly adjusts the row height to fit the content of the cells. This way, you can adjust the row height for any number of cells altogether.

Row height is changed to fit the content

  • Suggested Reads:

When you change the row height by clicking and dragging or by double-clicking, you will not know the height or width value you set the rows or columns to. There might be times when you have to set the row height or column width to a specific value.

First, select the rows that you want to change the height. To do this, navigate to the row header where you can see the mouse pointer change to an arrow.

Left-click and hold the mouse button to select the rows.

Now, right-click on the row headings and select Row Height,

How to change row height in Excel manually

Another way to select Row Height is by navigating to Home, Under the Cells section, click on the dropdown from Format and select Row Height,

This opens the Row Height dialog box.

Specify the row height you want and click OK,

Set to specific value

This sets the row height to the specific units you have entered.

If you are not satisfied with the row height, you can select the rows, change the value again, and click OK.

The row height is changed One advantage is that when you use this method and set the row height, all the rows will have the same height. This helps the rows and columns look aesthetically similar as they all have uniform spacing. Keyboard shortcuts always help in quick and efficient ways to solve problems.

Select the rows you want to change height either by clicking on the left mouse button and dragging them. Or hold shift and use the arrow keys to select the rows.

Press the ALT key. This opens the hotkeys layout in the Excel window.

Now press H and then O, This opens the Format dropdown.

You can see the keyboard shortcut keys which correspond to specific options in the Format dropdown. If you want to set the row height to a specific value, press H, In case you want to autofit the row height to the content in the cells, press A,

Change row height in Excel using Hotkeys Note: In the same way, you can change the column width easily using the shortcut keys. Press the keys Alt + H + O + W one after the other to change the column width,

  1. Also Read:

You cannot alter the row height or column width when entering the edit mode in any cell. To exit the edit mode, click anywhere outside the particular cell or click on the row or column headings. When you see a single selection arrow or a double-sided resize arrow, you can change row height in Excel.

  • The easiest and most efficient way to change the row height to fit the content is by selecting all the rows you want to change the height and double-clicking on the row.
  • This changes the row height to fit the contents of the cell in an instant.
  • Yes, you can change the row height using the keyboard shortcut keys.

Select the rows by holding the Shift key and using the arrow keys to select the cells. Then, press the shortcut keys Alt+H+O+H to set the row height manually, If you want to autofit the row height, press the keys Alt+H+O+A, Changing the row height or column width is a very essential feature.

  • This helps simplify large amounts of data that may be hidden or intertwined in the cells, confusing the users.
  • Simplified data, on the other hand, is easy for the user to read, understand, and perform operations to.
  • In this article, we saw how to change row height in Excel in 5 easy ways.
  • Using the same methods, you can also change the column width.

Depending on your preference and purpose, choose the method that suits you the best. If you need more high-quality Excel guides, please check out our center. Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to,

How do I unhide all rows in a team?

How to unhide the rows or columns

To unhide everything:Select all cells by clicking the button at the intersection of the row numbers and the column letters.On the Home tab, select Format > Hide & Unhide > Unhide Rows and Format > Hide & Unhide > Unhide Columns.(Also make sure that the worksheet has not been filtered)

-Kind regards, HansV https://www.eileenslounge.com Type of abuse Harassment or threats Inappropriate/Adult content Nudity Profanity Software piracy SPAM/Advertising Virus/Spyware/Malware danger Other Term of Use or Code of Conduct violation Child exploitation or abuse Harassment is any behavior intended to disturb or upset a person or group of people.

Threats include any threat of suicide, violence, or harm to another. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software.

Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites. Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation.

Details (required): 250 characters remaining 1 person found this reply helpful · Was this reply helpful? Sorry this didn’t help. Great! Thanks for your feedback. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. How satisfied are you with this reply? Thanks for your feedback.

: How to unhide the rows or columns

How do I unhide all cells in Excel for Mac?

How to Unhide All Columns by Setting the Column Width – You can also manually set the column width for all your Excel columns. If you select all of the cells in your spreadsheet first, this will make all of your columns the same width, helping to reveal your hidden columns. To unhide all columns in Excel by setting the column width:

Click the empty square at the top-left of your spreadsheet.Alternatively, press Cmd+A on Mac or Ctrl+A on Windows. Under the Home menu, click on the Format icon. Select Column Width, Enter a value that is large enough to show all of the data in your cells and click OK, Your hidden cells will appear. You may need to adjust the cell width if it is too big or too small.