How to hide rows in excel

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
You can hide Rows and Columns, easily.
Right click the Row header and choose "Hide"

Hidden Cells are Different than filtered Cells.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
Hide Rows with a Checkbox
Replies
1
Views
190
Eric W
Eric W
M
  • Solved
automatically hiding a row
Replies
7
Views
252
Mattlake
M
R
  • Question Question
Button to hide/unhide rows with specific text
2
Replies
11
Views
428
NoSparks
N
N
  • Question Question
Hiding/showing rows between two values
Replies
1
Views
435
Joe4
Joe4
C
  • Solved
Hide Columns
Replies
9
Views
158
Joe4
Joe4

Forum statistics

Threads
1,223,893
Messages
6,175,242
Members
452,623
Latest member
russelllowellpercy

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top