Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,942
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Modify a UDF please? Excel Helps Excel Worksheet Functions 0 January 23rd 08 12:10 AM
Modify function for another workbook kirkm[_7_] Excel Programming 2 December 21st 07 10:34 AM
How do I Default a modify password for each workbook Sammy work New Users to Excel 1 December 8th 05 04:11 PM
Modify the default new workbook? Margot Excel Worksheet Functions 1 February 11th 05 12:03 AM
How would I modify the following? BruceJ[_2_] Excel Programming 3 October 29th 03 09:31 PM


All times are GMT +1. The time now is 10:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"