#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 14
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,345
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can a form made in Excel 2002 be converted into a fillable form? Paraclete Excel Discussion (Misc queries) 1 February 20th 07 09:20 PM
how to generate a unique form # when using an excel form template PJE Excel Worksheet Functions 1 May 24th 06 11:00 PM
How do I put my information form Excel into a Word Merge Form? Jackie Excel Discussion (Misc queries) 2 March 16th 06 08:16 PM
I created a form on excel. want to edit the form without printing Oz Excel Discussion (Misc queries) 1 September 1st 05 08:18 PM
Is there a way to convert a EXCEL form into a WORD form? Sister6 Excel Discussion (Misc queries) 0 April 27th 05 11:35 PM


All times are GMT +1. The time now is 08:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"