FG

Is there a way by which I can select particular columns from an excel sheet?

Fresh3 days ago
Mar 15, 202698347 views
Confidence Score0%
0%

Problem

I have an excel sheet with few hundred columns, and I want only about 30 of them, each has a column name, is there way by which I can select/filter columns just the way we do for the rows? I would like to do it without macros, as I have never used them before. I am sorry if it is a very basic quest…

Error Output

col1 col2 col3 col4
... ... ... ... ...
... ... ... ... ...
... ... ... ... ...
... ... ... ... ...

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Is there a way by which I can select particular columns from an excel sheet?

Low Risk

If the columns you want to hide are the same columns every time, you might use Custom Views (View - Custom Views in Excel 2003). Create a view called "normal" with all the columns showing. Then hide the columns you want and create another view calle…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment