Hiding rows and columns
 

From John Walkenbach's bonus CD, he includes a guitar cord using XLS. The
neat thing is that he was able to show only the first dozen columns and rows
even after I do a show "row and column headers" in Options. Anyone knows how
to only show the first few rows?

Thanks

Hiding rows and columns
 

Maybe he hid the rest, select say row 13, Shift-Ctrl-Down Arrow, then
FormatRowsHide

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"matelot" wrote in message
...
From John Walkenbach's bonus CD, he includes a guitar cord using XLS. The
neat thing is that he was able to show only the first dozen columns and
rows
even after I do a show "row and column headers" in Options. Anyone knows
how
to only show the first few rows?

Thanks

Hiding rows and columns
 

Perhaps he did some like select F1:IV1 and then Format, Column, Hide?

--
Jim
"matelot" wrote in message
...
| From John Walkenbach's bonus CD, he includes a guitar cord using XLS. The
| neat thing is that he was able to show only the first dozen columns and
rows
| even after I do a show "row and column headers" in Options. Anyone knows
how
| to only show the first few rows?
|
| Thanks

Hiding rows and columns
 

Oh, did you mean a six-string or 12-string guitar? :)

"matelot" wrote:

From John Walkenbach's bonus CD, he includes a guitar cord using XLS. The
neat thing is that he was able to show only the first dozen columns and rows
even after I do a show "row and column headers" in Options. Anyone knows how
to only show the first few rows?

Thanks

Hiding rows and columns
 

Range("G:IV").EntireColumn.Hidden = True

Or put the cursor in G1, hold down Shift+Ctrl, press the down arrow, press
the right arrow, right-click the mouse and click "Hide"

"matelot" wrote:

From John Walkenbach's bonus CD, he includes a guitar cord using XLS. The
neat thing is that he was able to show only the first dozen columns and rows
even after I do a show "row and column headers" in Options. Anyone knows how
to only show the first few rows?

Thanks

Hiding rows and columns
 

6 string guitar. Pretty cool stuff.
I tried with the shift+Ctrl and "Hide". Now I can't get it back. How can I
unhide back?

"Charlie" wrote:

Oh, did you mean a six-string or 12-string guitar? :)

"matelot" wrote:

From John Walkenbach's bonus CD, he includes a guitar cord using XLS. The
neat thing is that he was able to show only the first dozen columns and rows
even after I do a show "row and column headers" in Options. Anyone knows how
to only show the first few rows?

Thanks

Hiding rows and columns
 

To unhide the columns click on the column letter of the last visible column
(above row 1) and drag the mouse into the empty space to the right of the
column. Then right-click in the highlighted portion of the last column and
click "Unhide".

Likewise for hidden rows.

"matelot" wrote:

6 string guitar. Pretty cool stuff.
I tried with the shift+Ctrl and "Hide". Now I can't get it back. How can I
unhide back?

"Charlie" wrote:

Oh, did you mean a six-string or 12-string guitar? :)

"matelot" wrote:

From John Walkenbach's bonus CD, he includes a guitar cord using XLS. The
neat thing is that he was able to show only the first dozen columns and rows
even after I do a show "row and column headers" in Options. Anyone knows how
to only show the first few rows?

Thanks