How to Hide Unused Cells in Excel (3 Quick Ways)

Excel has a large built-in spreadsheet to input data. However, most of the time, many of the cells remain unused. To prevent the entry of any scatter data on the datasheet, we can hide the unused cells in several ways. In this article, we will demonstrate 3 easy methods to hide unused cells in Excel. If you are curious about it, download our practice workbook and follow us.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


3 Easy Methods to Hide Unused Cells in Excel

To demonstrate the approaches, we consider a dataset of 10 employees of any organization and their salaries in the first quarter of any year. So, our dataset is in the range of cells B5:E14. We are going to hide the rest of the unused cells in the spreadsheet.


1. Utilizing Context Menu

In this method, we will use the Context Menu to hide the unused cells. We are going to hide all the cells except our dataset. The steps of this process are given below:

📌 Steps:

  • First, we will hide all the unused columns. For that, select the entire column A.
  • After that, right-click on your mouse and choose the Hide option.

Utilizing Context Menu to Hide Unused Cells

  • You will see column A will disappear.

Utilizing Context Menu to Hide Unused Cells

  • Similarly, select the entire column F and press ‘Ctrl+Shift+Right Arrow (→)’ to select all the empty columns.
  • Again, right-click on your mouse and choose the Hide option.

  • All the unused columns will hide from our dataset.

Utilizing Context Menu to Hide Unused Cells

  • Now, we are going to hide the unused rows.
  • Select the entire row 1 and right-click on your mouse.
  • Then, choose the Hide option.

Utilizing Context Menu to Hide Unused Cells

  • Row 1 will disappear.
  • Similarly, select the entire row 15 and press ‘Ctrl+Shift+Down Arrow (↓)’ to select all the empty rows.
  • Again, right-click on your mouse and choose the Hide option.

  • At last. you will get all the unused cells hidden from our spreadsheet.

Utilizing Context Menu to Hide Unused Cells

Thus, we can say that our method worked perfectly, and we are able to hide unused cells in Excel.

Read More: How to Hide Part of Text in Excel Cells (2 Effective Methods)


2. Applying Hide & Unhide Feature

In this process, we are going to use the Hide & Unhide feature from the drop-down of the Format command to hide the unused cells. We will hide all the cells except our dataset. The steps of this approach are given as follows:

📌 Steps:

  • At first, we are going to hide all the unused columns. For that, select the entire column A.
  • Then, in the Home tab, click the drop-down arrow of the Format option and choose the Hide Columns option from the Hide & Unhide Menu, located in the Cells group.

Applying Hide & Unhide Feature to Hide Unused Cells

  • You will see column A will disappear.

Applying Hide & Unhide Feature to Hide Unused Cells

  • Again, select the entire column F and press ‘Ctrl+Shift+Right Arrow (→)’ to select all the empty columns.
  • Similarly, click the drop-down arrow of the Format option and choose the Hide Columns option from the Hide & Unhide Menu, located in the Cells option.

  • All the unused columns will hide from our dataset.

Applying Hide & Unhide Feature to Hide Unused Cells

  • Now, we will hide the unused rows.
  • For doing that, select the entire row 1.
  • Afterward, in the Home tab, click the drop-down arrow of the Format option and choose the Hide Rows option from the Hide & Unhide Menu, located in the Cells group.

Applying Hide & Unhide Feature to Hide Unused Cells

  • Row 1 will disappear.

Applying Hide & Unhide Feature to Hide Unused Cells

  • Similarly, select the entire row 15 and press ‘Ctrl+Shift+Down Arrow (↓)’ to select all the empty rows.
  • Then, click the drop-down arrow of the Format option and choose the Hide Columns option from the Hide & Unhide Menu, located in the Cells group.

  • Finally, you will notice all the unused cells hidden from our spreadsheet.

Applying Hide & Unhide Feature to Hide Unused Cells

So, we can say that our method worked effectively, and we are able to hide unused cells in Excel.

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


3. Using Keyboard Shortcut

In this approach, we will use the keyboard shortcut to hide the unused cells. The procedure of this method is shown below:

📌 Steps:

  • First, we will hide all the unused columns. For that, select the entire column A.

  • Afterward, press ‘Ctrl+0’ to hide the column.
  • You will see column A will disappear.

Using Keyboard Shortcut to Hide Unused Cells

  • Similarly, select the entire column F and press ‘Ctrl+Shift+Right Arrow (→)’ to select all the empty columns.
  • Again, press ‘Ctrl+0’, and all the unused columns will hide from our dataset.

Using Keyboard Shortcut to Hide Unused Cells

  • Now, we will hide the unused rows.
  • For that, select the entire row 1.
  • Then, press ‘Ctrl+9’, and you will notice row 1 will disappear.

  • Similarly, select the entire row 15 and press ‘Ctrl+Shift+Down Arrow (↓)’ to select all the empty rows.
  • Again, press ‘Ctrl+9’ on your keyboard.
  • In the end, you will get all the unused cells hidden from our spreadsheet.

Using Keyboard Shortcut to Hide Unused Cells

Finally, we can say that our method worked successfully, and we are able to hide unused cells in Excel.

Read More: How to Hide Blank Cells in Excel (5 Easy Ways)


Conclusion

That’s the end of this article. I hope that this article will be helpful for you and you will be able to hide unused cells in Excel. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.

Don’t forget to check our website ExcelDemy for several Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Soumik Dutta

Soumik Dutta

Hi! I am Soumik. I have completed my Bachelor of Science in Naval Architecture and Marine Engineering. I have found my calling in Machine Learning and Data Science, and in pursuing so, I have realized the importance of Data Analysis. Excel is one excellent tool to fulfill the purpose. I am always trying to learn every day about different features of Excel and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo