How can I use the keyboard to show a hidden cell in Excel? – Best shortcuts

Working in Excel requires you to be focused and complete the task quickly You can also use shortcuts to help you with certain tasks.. The keyboard allows you to quickly activate many functions, such as hiding cells if their data is auxiliary. However, they are necessary for the proper functioning of formulas.

How to find hidden cells in an Excel file?

Excel offers many functions. Excel can sum the values ​​of alternate cells using odd or even rows. This function is very useful when trying to determine the relationship between budget and actual spending. To complete this task, you will need to create an additional column. It is often hidden in the background.

You can change a value in its base function using two methods. The first is to look at the order of the columns and rows. This will identify any gaps.

We are going to run the second one using a keyboard shortcut. Press F5 to open a pop-up window and click on “Special” Next, check the “Visible cells only” option After pressing OK, all visible cells are selected. Hidden cells remain blank.

How can I open a hidden cell in Excel from the keyboard?

Excel works with columns and rows. The intersection of the two is known as a cell. You can also enter data into this program. Excel has a function that allows you to sort data in one or more rows. However, it is best to display the cells first, so that the values ​​are not lost. You can get it using the mouse Or you can use the keyboard shortcuts.

Hidden lines can be shown

The rows should be oriented horizontally, so it's a good idea to do this. To find out which one is hidden, you can look at When we see a break in the enumeration on the left side, we can use the key combination Ctrl Shift 8 to show the lines and hide them again by pressing «Ctrl+18».

Open hidden columns

You can identify the columns with the letters at the top and hide them again by pressing “Ctrl+Shift+9”.

What should I do if Excel won't let me show hidden cells from the keyboard?

Excel usually allows you to use these shortcuts without much trouble. However, if you have an older version of Excel You will be prompted to update the version. You must do the homework from Microsoft OfficeIf your computer does not have these requirements, you can use other methods.

Select the Format option

This is a method you can use to reveal hidden cells to make any changes. Excel will show all hidden cells when you run this alternative method. You don't need to know how many hidden cells you have. It is better to choose a selection of all of them first. Apply this option to maintain a detailed order.

1. Choose the area you want to use. If you want to open the entire document, press “Ctrl+A” or the triangle in the upper left corner.
2. Go to the “Home” tab. Locate the “Cells” section and click “Format.”
3. Find “Row Height” and enter the desired value.
4. Click “OK to finish.” This will apply the row height to all sections, including hidden cells.

Use the mouse

You can easily identify the row or column that is hidden by simply looking at its order. Once you have found the break, click on the right and then go to the “Unhide” option.