Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMATING UNUSED SPACE
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 -- William -- William |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMATING UNUSED SPACE
Do you see any row or column headers in the unused space? It could be the
rest of the rows and columns are hidden. -- ** John C ** "William" wrote: 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 -- William -- William |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMATING UNUSED SPACE
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? -- Gary''s Student - gsnu200812 "William" wrote: 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 -- William -- William |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMATING UNUSED SPACE
Thanks, that was it!
-- William "Gary''s Student" wrote: 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? -- Gary''s Student - gsnu200812 "William" wrote: 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 -- William -- William |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMATING UNUSED SPACE
Change Style Normal to appear as you wish for the background, and then format the used area as you wish. -- shg ------------------------------------------------------------------------ shg's Profile: http://www.thecodecage.com/forumz/member.php?userid=13 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=27490 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying to next unused row | Excel Worksheet Functions | |||
deleting unused space at the end of a worksheet | Excel Worksheet Functions | |||
what to do with unused cells | Excel Worksheet Functions | |||
Paper Space / Model Space ? | Excel Discussion (Misc queries) | |||
Eliminate unused columns | Excel Discussion (Misc queries) |