Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Form on Excel
I've created a form for sales people to fill out on Excel. I've locked the
cells I don't want them to be able to change. How can I make only those cells that are part of the form show on the screen and not those to the left or bottom of it? Thanks for the help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Form on Excel
Put borders around the cells you want to be seen and turn off the gridlines?
-- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "joaniemic" wrote in message ... I've created a form for sales people to fill out on Excel. I've locked the cells I don't want them to be able to change. How can I make only those cells that are part of the form show on the screen and not those to the left or bottom of it? Thanks for the help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Form on Excel
Hide rows and columns below and to the right.
Gord Dibben MS Excel MVP On Tue, 17 Jun 2008 08:05:00 -0700, joaniemic wrote: I've created a form for sales people to fill out on Excel. I've locked the cells I don't want them to be able to change. How can I make only those cells that are part of the form show on the screen and not those to the left or bottom of it? Thanks for the help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a form made in Excel 2002 be converted into a fillable form? | Excel Discussion (Misc queries) | |||
how to generate a unique form # when using an excel form template | Excel Worksheet Functions | |||
How do I put my information form Excel into a Word Merge Form? | Excel Discussion (Misc queries) | |||
I created a form on excel. want to edit the form without printing | Excel Discussion (Misc queries) | |||
Is there a way to convert a EXCEL form into a WORD form? | Excel Discussion (Misc queries) |