What is the quickest way to hide a lot of rows and colums ?

G

Guest

I want to hide all but the first ten rows and ten columns of a worksheet. Is
there a quicker way than highlighting and scrolling through the rows/columns
I want to hide?
 
G

Guest

Hi Stephen
You could use a Macro
Press ALT + F11
and paste this in

Sub HIDE()
Columns("A:J").Select
Selection.EntireColumn.Hidden = True
Rows("1:10").Select
Selection.EntireRow.Hidden = True
End Sub

HTH
Michael Mitchelson
 
K

Ken Wright

Select the whole of Row 11 then simply hold down CTRL+SHIFT and hit the DOWN
arrow. Now hide the rows. then just repeat for the Columns.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hide, unhide column or row after protect worksheet 4
Hide and Unhide Function 4
hide rows which add up to zero 1
Hide rows function 4
Hiding of rows and columns 1
Unhide columns and rows 2
Filter/Hide 4
Macro to hide rows with zero values in columns 2

Top