I have an Excel book made by others, where the surroundings of each sheet is
grey and inaccessible. There is nothing wrong with it, on the contrary it is
quite nice. But what has been done to achieve this appearance?

Unused rows and columns hidden?
--
David Biddulph

"Knut" wrote in message
...
I have an Excel book made by others, where the surroundings of each sheet
is grey and inaccessible. There is nothing wrong with it, on the contrary
it is quite nice. But what has been done to achieve this appearance?

Yes, you are on to it. I was able to show many of the columns now, but how
do I release all rows and columns? (And how do I hide them?) I feel there
must be a simpler way..

Knut


"David Biddulph" <groups [at] biddulph.org.uk skrev i melding
...
Unused rows and columns hidden?
--
David Biddulph

"Knut" wrote in message
...
I have an Excel book made by others, where the surroundings of each sheet
is grey and inaccessible. There is nothing wrong with it, on the contrary
it is quite nice. But what has been done to achieve this appearance?

Click on the intersection between the row and column identifiers in
order to highlight the complete sheet. Then you can click on Format |
Columns then Unhide | OK and then click on Format | Rows | Unhide |
OK.

Hope this helps.

Pete

On May 7, 9:18*am, "Knut" wrote:
Yes, you are on to it. I was able to show many of the columns now, but how
do I release all rows and columns? (And how do I hide them?) I feel there
must be a simpler way..

Knut

Columns could be revealed all the way to IV. But I can still not reveal the
rows beneath those used. I want to add something below, but it is impossible
to go beneath row 62 (all is grey and inaccessible)

Knut



"Pete_UK" skrev i melding
...
Click on the intersection between the row and column identifiers in
order to highlight the complete sheet. Then you can click on Format |
Columns then Unhide | OK and then click on Format | Rows | Unhide |
OK.

Hope this helps.

Pete

On May 7, 9:18 am, "Knut" wrote:
Yes, you are on to it. I was able to show many of the columns now, but how
do I release all rows and columns? (And how do I hide them?) I feel there
must be a simpler way..

Knut

I can add rows, of course, so I can achieve what I want, but it seems
impossible to have the sheet look "normal" with white, open squares all
over.


"Knut" skrev i melding ...
Columns could be revealed all the way to IV. But I can still not reveal
the rows beneath those used. I want to add something below, but it is
impossible to go beneath row 62 (all is grey and inaccessible)

Knut



"Pete_UK" skrev i melding
...
Click on the intersection between the row and column identifiers in
order to highlight the complete sheet. Then you can click on Format |
Columns then Unhide | OK and then click on Format | Rows | Unhide |
OK.

Hope this helps.

Pete

On May 7, 9:18 am, "Knut" wrote:
Yes, you are on to it. I was able to show many of the columns now, but
how
do I release all rows and columns? (And how do I hide them?) I feel there
must be a simpler way..

Knut