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

Get FREE Advanced Excel Exercises with Solutions!

If you are searching for a 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.

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: Hide Data in Excel


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 Unused Cells in Excel 


Download Practice Workbook


Conclusion

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.


Related Articles


<< Go Back to Hide Cells | Excel Cells | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Osman Goni Ridwan
Osman Goni Ridwan

OSMAN GONI RIDWAN is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, OSMAN has transitioned into the role of a content developer. Specializing in creating technical content exclusively centered around Excel... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo