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.
How to Hide Extra Cells in Excel: 2 Quick Steps
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 the 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.
- 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.
- As a result, you will see that all extra columns have become hidden.
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 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.
- Hide Data in Excel
- How to Hide Unused Cells in Excel
- How to Hide Blank Cells in Excel
- How to Hide Part of Text in Excel Cells
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.
- Then, just right-click on the row header to open the context menu.
- And, select the Hide option to hide the rows.
- As a result, you have hidden the extra cells in the Excel file.
Download Practice Workbook
In this article, you have found how to hide extra cells in Excel. I hope you found this article helpful. Please, drop comments, suggestions, or queries if you have any in the comment section below.