WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


How to filter data horizontally

Uploaded time: March 16, 2022 Difficulty Beginner

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.

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


· 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).


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.


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


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. 

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.