How to Hide Extra Cells in Excel (with Quick Steps)

If you are searching for the solution or some special tricks to hide extra cells in Excel then you have landed in the right place. Often you want to focus only on the portion of the dataset and grey out the unused cells. You can simply hide the unused cells to grey out the unused part of the worksheet. There is a quick way to hide extra cells in Excel. For this, you have to hide all rows below the dataset and all columns right after the dataset. This article will show you each and every step with proper illustrations so you can easily apply them for your purpose. Let’s get into the main part of the article.


Download Practice Workbook


Steps to Hide Extra Cells in Excel

If you want to hide extra cells in Excel then, you have to do it in two steps. First, you will have to select the extra cells then you have to hide them. And to select the extra cells, you will first select the extra columns and then select extra rows. In this section, I will show you the quick steps to hide extra cells in Excel on Windows operating system. You will find detailed explanations of methods and formulas here. I have used Microsoft 365 version here. But you can use any other versions as of your availability. If any methods won’t work in your version then leave us a comment.


Step 1: Hide Extra Columns

To hide the extra columns right after the dataset, first, have to select and then hide them. Follow the steps below for this :

  • First, click on the column header of the first unused cell. Thus you have selected that column.

How to Hide Extra Cells in Excel

  • Then, you have to press Ctrl + Shift + Right arrow on the keyboard simultaneously to select all remaining columns.
  • After that, right-click on the column header to open the options.
  • Select the Hide option to hide the columns.

How to Hide Extra Cells in Excel

  • As a result, you will see that all extra columns have become hidden.

How to Hide Extra Cells in Excel

You can hide cells in 2 more ways. You can hide cells from the Format options, and by using the Excel keyboard shortcuts also. I am describing here how you can hide these ways to hide cells in Excel.

There are more ways to find the Hide command.

Hide from Format Options:

After selecting the cells, rows, or columns, you can use the Format feature in Excel to hide the selected things.

  • First, select the columns
  • Then, go to the Home tab and click on the Format menu.
  • Here, click on the “Hide & Unhide” option and select the “Hide Column” option.
  • Thus, all the selected columns will be hidden.

Hide from Format Options

Hide Using Keyboard Shortcut:

Alternatively, you can use a simple Excel keyboard shortcut to hide the selected cells, columns, or rows. After selecting the cells, rows, or columns just press Ctrl+0 and you will see the selected ones become hidden.

Read More: How to Hide Cells in Excel Until Data Entered (2 Easy Ways)


Step 2: Hide Extra Rows

Similarly, you have to remove the extra rows below the dataset. Follow the steps below for this:

  • Click on the row header of the row immediately after the dataset to select.
  • Then, press the Excel keyboard shortcut Ctrl + Shift + Down arrow key simultaneously. Thus, you will select the extra rows under the dataset.

Remove Extra Rows

  • Then, just right-click on the row header to open the context menu.
  • And, select the Hide option to hide the rows.

Remove Extra Rows

  • As a result, you have hidden the extra cells in the Excel file.

Remove Extra Rows

Read More: How to Hide Cell Contents in Excel Formula Bar (5 Methods)


Conclusion

In this article, you have found how to hide extra cells in Excel. I hope you found this article helpful. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Osman Goni Ridwan

Osman Goni Ridwan

I am Ridwan, graduated from Naval Architecture and Marine Engineering Dept, BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands. My prime goal is to be a data analyst as I do love to solve problems and play with data.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo