ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW TO HIDE ALL EXTRA ROW AND COLUMNS (https://www.excelbanter.com/excel-worksheet-functions/225221-how-hide-all-extra-row-columns.html)

dvalderrama

HOW TO HIDE ALL EXTRA ROW AND COLUMNS
 
i want to hise the rest of the worksheet for example i have a gride that is
like 20 cells by 20 cell, how can i just have that one boxe showing instead
of the whole worksheet like column bb or row 223. i just want to keep it in
range that i need

dvalderrama

thanks'
 
thanks

dvalderrama

HOW TO HIDE ALL EXTRA ROW AND COLUMNS
 
thanks

"Glenn" wrote:

dvalderrama wrote:
i want to hise the rest of the worksheet for example i have a gride that is
like 20 cells by 20 cell, how can i just have that one boxe showing instead
of the whole worksheet like column bb or row 223. i just want to keep it in
range that i need


First, select the columns you want to hide. You can do this by clicking on the
first column letter that you want hidden and then holding down the Shift and
Ctrl keys and hitting the right-arrow key. Then select Format / Column / Hide.

The second step should be pretty obvious...


Glenn

HOW TO HIDE ALL EXTRA ROW AND COLUMNS
 
dvalderrama wrote:
i want to hise the rest of the worksheet for example i have a gride that is
like 20 cells by 20 cell, how can i just have that one boxe showing instead
of the whole worksheet like column bb or row 223. i just want to keep it in
range that i need


First, select the columns you want to hide. You can do this by clicking on the
first column letter that you want hidden and then holding down the Shift and
Ctrl keys and hitting the right-arrow key. Then select Format / Column / Hide.

The second step should be pretty obvious...


All times are GMT +1. The time now is 11:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com