FORMATING UNUSED SPACE

W

William

I saw a worksheet in Excel that was a form comprised of about 10 columns and
20 rows. All of the space surrounding the used area was grayed out, so the
page looked like a form in Access. I don't think it was a matter of using
Fill Color on unused cells; the gray extended to the ends of the workbook.

Does anyone know how this was accomplished
 
J

John C

Do you see any row or column headers in the unused space? It could be the
rest of the rows and columns are hidden.
 
G

Gary''s Student

Open a blank worksheet and click on column G. Then, while holding down the
SHFT key, touch END RIGHTARROW.

This should select all the columns from column G thru column IV and then

Format > Column > Hide

Is this the kind of effect you are looking for?
 
W

William

Thanks, that was it!
--
William


Gary''s Student said:
Open a blank worksheet and click on column G. Then, while holding down the
SHFT key, touch END RIGHTARROW.

This should select all the columns from column G thru column IV and then

Format > Column > Hide

Is this the kind of effect you are looking for?
 
S

shg

Change Style Normal to appear as you wish for the background, and then
format the used area as you wish.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top