Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i have seen formatting that looks like a lightswitch cover in a house: a
plastic plate w/ rectangular holes where the lightswitches come out. on a spreadsheet, this is used to make it obvious where you are to input data (the rectangular holes, or cells) and obvious where you are NOT supposed to input data (the plastic plate, or protected unwritable cells). say i want to only allow inputs in cells a4, a5, d4, and d5 and not allow inputs in any other cell on the sheet. i know i can protect all but these 4, then shade w/ colors, bold, etc. but it doesn't look as good/professional as this "plate" effect. any thoughts? thanks, mike allen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
EXCEL INVOICE TEMPLATE THAT UPDATES DATA AS I INPUT ITEM# | Excel Worksheet Functions | |||
create template with certain fields to input information only | Excel Worksheet Functions | |||
Where can I get an excel template to input annual leave? | Excel Discussion (Misc queries) | |||
Opening a template form & renaming it from a cell input automatica | Excel Discussion (Misc queries) | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming |