ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Fill-in Forms (https://www.excelbanter.com/excel-discussion-misc-queries/239105-fill-forms.html)

Kelsey13

Fill-in Forms
 
Hi,

I am trying to create a form which I can fill in when my customers are
ordering from me. I have already created a printable form in excel which I
use, but I would like to input the information directly into the
worksheet/form as I ask them for information to input.
If I try to use the form as it is and type in information, if I need more
room, it moves everything over, so if I wanted to print it out it would no
longer be in the format which it was originally created. (example --
everything would shift over to a new page if alot of info. was inputed.)

Jacob Skaria

Fill-in Forms
 
Are you aware of the below options..

--From menu FormatCellsAlignment
OR Right click FormatcellsAlignment

--FilePageSetupFit to pages

If this post helps click Yes
---------------
Jacob Skaria


"Kelsey13" wrote:

Hi,

I am trying to create a form which I can fill in when my customers are
ordering from me. I have already created a printable form in excel which I
use, but I would like to input the information directly into the
worksheet/form as I ask them for information to input.
If I try to use the form as it is and type in information, if I need more
room, it moves everything over, so if I wanted to print it out it would no
longer be in the format which it was originally created. (example --
everything would shift over to a new page if alot of info. was inputed.)


Kelsey13

Fill-in Forms
 
Actually, I don't think I was quite clear at what I am attempting to create.
for instance, if I want to find a template of a service form through excel
template, I can find one and use it to fill in information where I want it.
But what I need is to do the same thing, but it needs to fit the needs of my
business. I don't know if I can edit one that is already done.

Thanks,
Kelly

"Jacob Skaria" wrote:

Are you aware of the below options..

--From menu FormatCellsAlignment
OR Right click FormatcellsAlignment

--FilePageSetupFit to pages

If this post helps click Yes
---------------
Jacob Skaria


"Kelsey13" wrote:

Hi,

I am trying to create a form which I can fill in when my customers are
ordering from me. I have already created a printable form in excel which I
use, but I would like to input the information directly into the
worksheet/form as I ask them for information to input.
If I try to use the form as it is and type in information, if I need more
room, it moves everything over, so if I wanted to print it out it would no
longer be in the format which it was originally created. (example --
everything would shift over to a new page if alot of info. was inputed.)



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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com