How To Only Show Certain Columns In Excel

How to limit number of rows and columns in a worksheet in Excel?

When sharing a range of worksheet with others, you may want to prevent others from viewing other rows and columns. Hither I will innovate some catchy ways to limit number of rows and column in a worksheet in Excel easily.

Limit number of rows and columns with disabling scrolling in Excel
Limit number of rows and columns with hiding rows and columns
Limit number of rows and column with an amazing tool

Limit number of rows and columns with disabling scrolling in Excel

In Excel, users can set scrolling area to preclude from scrolling to other rows and columns.

Pace 1: Correct click the worksheet name in the Sheet tab bar, and then select the View Code from the right-clicking menu.

Footstep 2: Now you go into the Microsoft Visual Basic for Applications window, y'all need to open the Properties Window with clicking View > Backdrop Window.

Note: If the Properties window has been opened already, merely skip this footstep.

Step 3: In the Properties window, find out the ScrollArea in the left bar, and so in the following box enter the range you want to share with others.

Footstep four: Shut the Microsoft Visual Basic for Applications window.

Then y'all volition see both vertical ringlet bar and horizontal scroll bar are freeze, and you cannot scroll to other rows and columns in current worksheet.

One click to hide everything but selected range (hide unused column/rows/cells)

Most of time, we may only apply part of worksheet with numeric blank cells/range left. Kutools for Excel'due south Set Scroll Area utility tin help you one click to hide everything except selected range, or hide all unused cells/rows/column/ranges easily. Full Feature Free Trial 30-solar day!
ad set scroll area 2

Limit number of rows and columns with hiding rows and columns

Apart from setting scrolling area, we can too limit number of rows and columns by hiding unshared rows and columns in Excel.

Pace one: Besides the shared range, you need to select the left ranges and hide them. Select the start cavalcade right to the shared range, then press the Ctrl + Shift + Rightward arrow keys simultaneously to select all right columns.

Step 2: Right click selected columns, and select the Hide from right-clicking menu.

Footstep 3: Select the beginning row beneath shared range, press the Ctrl + Shift + Downward arrow keys at the same time to select all rows beneath shared range, and then hibernate them.

Stride 4: Select the commencement row upwardly shared range, printing Ctrl + Shift + Up pointer simultaneously to select all rows up shared range, and so hibernate them.

Footstep 5: Select the offset cavalcade left to shared range, printing Ctrl + Shift + Leftward arrow simultaneously to select all columns left to shared range, and then hide them.

And then you will see all rows and columns are subconscious except shared range in the worksheet.

Limit number of rows and cavalcade with KTE's Set Coil Expanse utility

The hotkeys seem non easy for many Excel users. Practise not worry about it, you lot can try Kutools for Excel's Prepare Gyre Area utility, which helps you hide all rows and columns except shared range with but ane click in Excel.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial thirty-twenty-four hours, no credit card required! Get Information technology At present

Select the shared range you want to share with others, and click the Kutools > Show / Hide > Set up Scroll Surface area.
ad set scroll area 2

And so yous will see all rows and columns are hidden except shared range in the worksheet immediately.

Prepare Curl Area is one of Kutools for Excel utility, which is designed to one click to hide all unselected rows and columns in active worksheet hands. Click for 30-day free trial, no limitation!

Demo: Limit number of rows and column with merely one click

Kutools for Excel includes more than than 300 handy tools for Excel, free to endeavour without limitation in 30 days. Download and Complimentary Trial At present!

Toggle to prove/hide columns: i click to show all hidden columns, and one click to restore subconscious columns

Kutools for Excel's (Evidence) Columns utility is a expert toggle to show all hidden columns with but one click, and click this Column button for the 2nd time will make these columns hidden again. Total Feature Gratuitous Trial xxx-mean solar day!
ad unhide hidden columns 1

The Best Role Productivity Tools

Kutools for Excel Solves About of Your Problems, and Increases Your Productivity by fourscore%

Reuse: Quickly insert complex formulas, charts and anything that you lot have used earlier; Encrypt Cells with countersign; Create Mailing List and send emails...
Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
Merge Cells/Rows/Columns without losing Information; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
Select Duplicate or Unique Rows; Select Bare Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
Verbal Re-create Multiple Cells without irresolute formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Cheque Boxes and more...
Extract Text, Add Text, Remove by Position, Remove Space; Create and Impress Paging Subtotals; Catechumen Betwixt Cells Content and Comments...
Super Filter (relieve and apply filter schemes to other sheets); Advanced Sort past calendar month/week/day, frequency and more than; Special Filter past bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than 300 powerful features. Supports Role/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features xxx-twenty-four hours gratis trial. 60-day money dorsum guarantee.

kte tab 201905

Part Tab Brings Tabbed interface to Office, and Make Your Piece of work Much Easier

Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Access, Visio and Projection.
Open up and create multiple documents in new tabs of the same window, rather than in new windows.
Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every mean solar day!

officetab bottom