View only work area

D

dbsci

There are Excel templates in which only the work area is visible, and
everything outside the work area is gray. How is that done?
 
J

JE McGimpsey

There are Excel templates in which only the work area is visible, and
everything outside the work area is gray. How is that done?
Click to expand...

The unused rows and columns are hidden. For instance, if you wanted to
show only 10 columns and 50 rows, you could enter

K:IV

in the Name Box (on the Formula Bar), hit Return to select the columns,
then choose Format/Columns/Hide.

Similarly, entering

51:65536

in the Name Box, hitting Return, and choosing Format/Rows/Hide will hide
the unwanted rows.

Note that this will not prevent someone from scrolling (or using the
Name Box to select) outside that boundary. To do that requires using
event macros. Post back if you're interested.
 
D

Darlene Kupke

It worked!!! Thanks for taking the time to help me out.

DSB
Click to expand...
This works great my only question is how do you unhide the rows and columns?
I've been saving the tips on here for my files.

thanks

Darlene
 
B

Bernard Rey

Darlene Kupke wrote :
This works great my only question is how do you unhide the rows and columns?
I've been saving the tips on here for my files.
Click to expand...

Do just the same (enter "K:IV" in the Name Box, hit Return) but choose
"Unhide" from the "Format" menu - "Columns" item: they'll be back...
 
Top