ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to modify the look of the workbook. (https://www.excelbanter.com/excel-programming/422812-how-modify-look-workbook.html)

Vipul

How to modify the look of the workbook.
 
Hi there,

I have a workbook with only one sheet in it.
And i only need to use A1 : G50 range.
I want to disappear all other columns and rows.
How can i make my sheet come up with only A1 : G50 range.

I hope its possible because i have seen some sheets with this kind. But i
still couldnt find how can i do it.

Thanking you.
-Vipul

FSt1

How to modify the look of the workbook.
 
hi
the most popular way of doing this(i think) is to hide all unused columns
and rows.
another way is to set the cell back color and line to dark gray.
a flaw to the color method is that the cell pointer will run over into the
colored part where the cell pointer stops at the hidden columns/rows.

Regards
FSt1

"Vipul" wrote:

Hi there,

I have a workbook with only one sheet in it.
And i only need to use A1 : G50 range.
I want to disappear all other columns and rows.
How can i make my sheet come up with only A1 : G50 range.

I hope its possible because i have seen some sheets with this kind. But i
still couldnt find how can i do it.

Thanking you.
-Vipul



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

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