FORMATING UNUSED SPACE

  • Thread starter Thread starter William
  • Start date Start date
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
 
Do you see any row or column headers in the unused space? It could be the
rest of the rows and columns are hidden.
 
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?
 
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?
Click to expand...
 

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

Similar Threads

conditional formatting 1
How can I sum numbers that have a gray color-fill in cell? 1
How do I free up the space occupied by empty rows? 2
Text Color Changes By Itself 3
hide worksheet parts 2
change last cell reference 1
Excel VBA 1
Unwanted shading of entire spreadsheet 2

Back
Top