| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Design New Template
In Excel, Existing Template = ExpenseStatement, outside of border.
When I create a new template or worksheet, "How do I get rid of/hide the area outside of the statement border" just like the template in Excel (templates folder)?? -- neo-Geek don''t mind me, I''m just learning too. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Design New Template
The green is just fill colour then they have protected all cells except
those that should be filled in do toolsprotection and unprotect sheet -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Larry-Laser" wrote in message ... In Excel, Existing Template = ExpenseStatement, outside of border. When I create a new template or worksheet, "How do I get rid of/hide the area outside of the statement border" just like the template in Excel (templates folder)?? -- neo-Geek don''t mind me, I''m just learning too. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Design New Template
How about a little more info.
No way to modify Unprotected cells without unprotecting entire sheet. -- neo-Geek don''t mind me, I''m just learning too. "Peo Sjoblom" wrote: The green is just fill colour then they have protected all cells except those that should be filled in do toolsprotection and unprotect sheet -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Larry-Laser" wrote in message ... In Excel, Existing Template = ExpenseStatement, outside of border. When I create a new template or worksheet, "How do I get rid of/hide the area outside of the statement border" just like the template in Excel (templates folder)?? -- neo-Geek don''t mind me, I''m just learning too. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Design New Template
This is how you do it, select all cells to the right, above, below and to
the left of the area you want to look like a form and use a fill colour, then select the whole sheet, select the cells where you want to allow input by using mouse and ctrl key, then do formatcellsprotection and make sure locked is unchecked, then protect the sheet -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Larry-Laser" wrote in message ... How about a little more info. No way to modify Unprotected cells without unprotecting entire sheet. -- neo-Geek don''t mind me, I''m just learning too. "Peo Sjoblom" wrote: The green is just fill colour then they have protected all cells except those that should be filled in do toolsprotection and unprotect sheet -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Larry-Laser" wrote in message ... In Excel, Existing Template = ExpenseStatement, outside of border. When I create a new template or worksheet, "How do I get rid of/hide the area outside of the statement border" just like the template in Excel (templates folder)?? -- neo-Geek don''t mind me, I''m just learning too. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Design New Template
and how do I select all cell to the right and below, (all cells are never
ending)?? -- neo-Geek don''t mind me, I''m just learning too. "Peo Sjoblom" wrote: This is how you do it, select all cells to the right, above, below and to the left of the area you want to look like a form and use a fill colour, then select the whole sheet, select the cells where you want to allow input by using mouse and ctrl key, then do formatcellsprotection and make sure locked is unchecked, then protect the sheet -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Larry-Laser" wrote in message ... How about a little more info. No way to modify Unprotected cells without unprotecting entire sheet. -- neo-Geek don''t mind me, I''m just learning too. "Peo Sjoblom" wrote: The green is just fill colour then they have protected all cells except those that should be filled in do toolsprotection and unprotect sheet -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Larry-Laser" wrote in message ... In Excel, Existing Template = ExpenseStatement, outside of border. When I create a new template or worksheet, "How do I get rid of/hide the area outside of the statement border" just like the template in Excel (templates folder)?? -- neo-Geek don''t mind me, I''m just learning too. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Design New Template
Click in the Upper Left corner, hold down the shift key. Go to the lower
right corner and click. -- Regards, Tom Ogilvy "Larry-Laser" wrote in message ... and how do I select all cell to the right and below, (all cells are never ending)?? -- neo-Geek don''t mind me, I''m just learning too. "Peo Sjoblom" wrote: This is how you do it, select all cells to the right, above, below and to the left of the area you want to look like a form and use a fill colour, then select the whole sheet, select the cells where you want to allow input by using mouse and ctrl key, then do formatcellsprotection and make sure locked is unchecked, then protect the sheet -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Larry-Laser" wrote in message ... How about a little more info. No way to modify Unprotected cells without unprotecting entire sheet. -- neo-Geek don''t mind me, I''m just learning too. "Peo Sjoblom" wrote: The green is just fill colour then they have protected all cells except those that should be filled in do toolsprotection and unprotect sheet -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Larry-Laser" wrote in message ... In Excel, Existing Template = ExpenseStatement, outside of border. When I create a new template or worksheet, "How do I get rid of/hide the area outside of the statement border" just like the template in Excel (templates folder)?? -- neo-Geek don''t mind me, I''m just learning too. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Design New Template
Assume you want to select and colour column P to the end, click the header
of column P, hold down ctrl and shift and press right arrow,use the fill colour. To select row 35 and below click the header of row 35 and ctrl + shift and down arrow, repeat fill colour. -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Larry-Laser" wrote in message ... and how do I select all cell to the right and below, (all cells are never ending)?? -- neo-Geek don''t mind me, I''m just learning too. "Peo Sjoblom" wrote: This is how you do it, select all cells to the right, above, below and to the left of the area you want to look like a form and use a fill colour, then select the whole sheet, select the cells where you want to allow input by using mouse and ctrl key, then do formatcellsprotection and make sure locked is unchecked, then protect the sheet -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Larry-Laser" wrote in message ... How about a little more info. No way to modify Unprotected cells without unprotecting entire sheet. -- neo-Geek don''t mind me, I''m just learning too. "Peo Sjoblom" wrote: The green is just fill colour then they have protected all cells except those that should be filled in do toolsprotection and unprotect sheet -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Larry-Laser" wrote in message ... In Excel, Existing Template = ExpenseStatement, outside of border. When I create a new template or worksheet, "How do I get rid of/hide the area outside of the statement border" just like the template in Excel (templates folder)?? -- neo-Geek don''t mind me, I''m just learning too. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Design New Template
Thank You Peo Sjoblom
by your instruction I can see that I can not select all areas at once. It would be nice to have an "Invert Selection" in the edit menu. -- neo-Geek don''t mind me, I''m just learning too. "Peo Sjoblom" wrote: Assume you want to select and colour column P to the end, click the header of column P, hold down ctrl and shift and press right arrow,use the fill colour. To select row 35 and below click the header of row 35 and ctrl + shift and down arrow, repeat fill colour. -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Larry-Laser" wrote in message ... and how do I select all cell to the right and below, (all cells are never ending)?? -- neo-Geek don''t mind me, I''m just learning too. "Peo Sjoblom" wrote: This is how you do it, select all cells to the right, above, below and to the left of the area you want to look like a form and use a fill colour, then select the whole sheet, select the cells where you want to allow input by using mouse and ctrl key, then do formatcellsprotection and make sure locked is unchecked, then protect the sheet -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Larry-Laser" wrote in message ... How about a little more info. No way to modify Unprotected cells without unprotecting entire sheet. -- neo-Geek don''t mind me, I''m just learning too. "Peo Sjoblom" wrote: The green is just fill colour then they have protected all cells except those that should be filled in do toolsprotection and unprotect sheet -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Larry-Laser" wrote in message ... In Excel, Existing Template = ExpenseStatement, outside of border. When I create a new template or worksheet, "How do I get rid of/hide the area outside of the statement border" just like the template in Excel (templates folder)?? -- neo-Geek don''t mind me, I''m just learning too. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =IF problem | Excel Discussion (Misc queries) | |||
| Template design and consolidation | Excel Discussion (Misc queries) | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| Need One Excel Template to copy to TWO Databases | Excel Discussion (Misc queries) | |||
| HELP!I need a specification template purchasing Interior Design it | Excel Worksheet Functions | |||
Linear Mode
