How to Limit Columns in Excel: 3 Quick Methods

Method 1 – Disable Scroll Area to Limit Columns in Excel.

STEPS:

  • Rightclick on the sheet name to open the Context Menu.
  • 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.

Disable Scroll Area to Limit Columns in Excel

  • In the Properties Window, go to the ScrollArea field and type the columns you want to operate.
  • Operate on Columns B and C. So, we have typed B: C in the ScrollArea field.
  • Press Ctrl + S to save the changes.
  • Close the Visual Basic window.

Disable Scroll Area to Limit Columns in Excel

  • If you go to the dataset, you can 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

 


Method 2 – Limit Columns by Hiding

STEPS:

  • Select the column from where you want to start hiding.
  • That is Column F.

Limit Columns by Hiding

  • Press Ctrl + Shift + Right Arrow to select all the columns from Column F.
  • Rightclick on the top of the selected columns to open the Context Menu.
  • Hide from there.

Limit Columns by Hiding

  • All columns will be hidden except Columns A to E.

Limit Columns by Hiding

 


Method 3 – Change Width to Limit Columns in Excel

STEPS:

  • Press Ctrl + G to open the Go To dialog box.
  • Type F: XFD in the Reference box.
  • 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.

Change Width to Limit Columns in Excel

  • 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.
  • Click OK to move forward.

  • The Excel sheet is limited to Columns A to only.

 


Download Practice Workbook


Related Articles


<< Go Back to Row and Column Limit | Rows and Columns in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mursalin Ibne Salehin
Mursalin Ibne Salehin

Mursalin Ibne Salehin holds a BSc in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. Over the past 2 years, he has actively contributed to the ExcelDemy project, where he authored over 150 articles. He has also led a team with content development works. Currently, he is working as a Reviewer in the ExcelDemy Project. He likes using and learning about Microsoft Office, especially Excel. He is interested in data analysis with Excel, machine learning,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo