How to filter data horizontally

Uploaded time: March 16, 2022 Difficulty: Beginner

How to filter data horizontally

How to filter data horizontally

How to filter data horizontally

The filter function is often  used in data processing, but only when the data is vertically arranged. Today we will filter data horizontally using two ways.

· 1. Transpose data

Take this table as an example. To filter the sales of all categories, we need to select and copy the entire table with Ctrl+C and then right-click Transpose at Paste Special. By doing so, the table is transformed into a vertically-oriented table. gif.gif


Go to the Home tab, and click AutoFilter to get the sales of all categories.

gif_1.gif

 

· 2. Hide data

What can we do if we only want to process data in the original table?


Select the range B2:M2, and then use the Tab key to select any Sales and highlight it with the white color. (Note: Tab allows you to move one cell rightward).

gif_2.gif


Then press the shortcut key Ctrl+G to activate the Go To dialog, where we need to select Row differences. Then, all columns are selected except the Sales column.

gif_3.gif

 

At this time, click the Home tab, and pick Hide Columns at Rows and Columns.

gif_4.gif


Did you get it? Come and try it!

Excel is the most powerful tool to manage and analyze various types of Data. This free WPS Spreadsheet tutorial for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process.