How to Limit Columns in Excel (3 Quick Ways)

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will learn to limit columns in Excel. Sometimes, users need to work on specific columns. In that case, one needs to limit columns. Today, we will show 3 quick methods. Using these methods, you can easily limit columns in Excel. So, without any delay, let’s start the discussion.


How to Limit Columns in Excel:3 Quick Ways

To explain these methods, we will use a dataset that contains information about the ID, Name, and Department of some employees of a company. We will try to limit columns using this dataset.


1. Disable Scroll Area to Limit Columns in Excel

In the first method, we will disable the scroll area to limit columns in Excel. To do so, we need to take the help of the Developer tab. Here, you need to set the columns where you want to operate. After setting the columns, you will be able to operate only in the selected columns. Let’s follow the steps below to see how we can limit columns by disabling the scroll area in Excel.

STEPS:

  • In the first place, rightclick on the sheet name to open the Context Menu.
  • Then, select View Code from there. It will open the Visual Basic window.

Disable Scroll Area to Limit Columns in Excel

  • In the Visual Basic window, click on View. A drop-down menu will appear.
  • Select Properties Windows from there.

Disable Scroll Area to Limit Columns in Excel

  • In the Properties Window, go to the ScrollArea field and type the columns in which you want to operate.
  • Here, we want to operate on Columns B and C. So, we have typed B: C in the ScrollArea field.
  • After that, press Ctrl + S to save the changes.
  • After saving the changes, close the Visual Basic window.

Disable Scroll Area to Limit Columns in Excel

  • Finally, if you go to the dataset, you will be able to operate on Columns B and C. You won’t be able to scroll in any other columns.

Disable Scroll Area to Limit Columns in Excel

Read More: How to Set the End of an Excel Spreadsheet


2. Limit Columns by Hiding

Another way to limit columns is to hide them. In this case, we will hide all the columns except the columns we want to operate on. Here, we will hide all the columns except Columns A to E. So, let’s follow the steps below to see how we can hide columns in Excel.

STEPS:

  • Firstly, select the column from where you want to start hiding.
  • In our case, that is Column F.

Limit Columns by Hiding

  • Secondly, press Ctrl + Shift + Right Arrow to select all the columns from Column F.
  • After that, rightclick on the top of the selected columns to open the Context Menu.
  • Select Hide from there.

Limit Columns by Hiding

  • As a result, all columns will be hidden except Columns A to E.

Limit Columns by Hiding

Read More: How to Increase Excel Column Limit


3. Change Width to Limit Columns in Excel

In the last method, we will change the width of the columns to limit them in Excel. This process is similar to the previous one. Here, we will use the same dataset and will limit the Excel sheet to Columns A to E. So, let’s pay attention to the steps below to see how we can change the width of the columns.

STEPS:

  • First of all, press Ctrl + G to open the Go To dialog box.
  • Secondly, type F: XFD in the Reference box.
  • Here, F is the column from where we want to start changing the width and XFD is the last column of the Excel sheet.
  • Click OK to proceed.

Change Width to Limit Columns in Excel

  • After that, rightclick on the selected columns to open the Context Menu.
  • Select Column Width from there. It will open the Column Width dialog box.

  • In the Column Width dialog box, type 0 in the Column width box.
  • Then, click OK to move forward.

  • Finally, you will see that the excel sheet is limited to Columns A to only.

Read More: How to Limit Number of Rows in Excel


Download Practice Workbook

You can download the practice book from here.


Conclusion

In this article, we have discussed easy methods to Limit Columns in Excel. I hope this article will help you to perform your tasks easily. Furthermore, we have also added the practice book at the beginning of the article. To test your skills, you can download it to exercise. You can also visit the ExcelDemy website for more articles like this. Last of all, if you have any suggestions or queries, feel free to ask in the comment section below.


Related Articles

Mursalin Ibne Salehin
Mursalin Ibne Salehin

Hi there! This is Mursalin. I am currently working as a Team Leader at ExcelDemy. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I manage and help the writers to develop quality content in Excel and VBA-related topics.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo