Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
carole
 
Posts: n/a
Default how to make form layouts


I have a new job and there are a lot of forms that the previous person
made-. an example of a simple form would be a two columns with 15 rows
(15 rows divided into two by a line down the middle) which have a
height greater than one would normally see - this has names down the
left side and other information on the right side and expands downward
if necessary. This form fills a complete printed 8 1/2 x 11 page. Does
someone know how this is done.


--
carole
------------------------------------------------------------------------
carole's Profile: http://www.excelforum.com/member.php...o&userid=34643
View this thread: http://www.excelforum.com/showthread...hreadid=550723

  #2   Report Post  
Posted to microsoft.public.excel.newusers
kassie
 
Posts: n/a
Default how to make form layouts

To adjust the row height, select the 15 rows, ie select the row numbers, not
column A. Move your mouse to the line between any 2 rows, click and pull it
down to about 3 times the normal height and release. Do a print preview, and
you'll soon see when you are right.

To do the lines and columns, select columns A and B, move your cursor to the
line between the two, where the cursor changes to an adjusting arrow, and
drag to the right till it fills a page width. Select the 30 cells - A1 to
B15, click on the borders icon, and select the type of line you want

"carole" wrote:


I have a new job and there are a lot of forms that the previous person
made-. an example of a simple form would be a two columns with 15 rows
(15 rows divided into two by a line down the middle) which have a
height greater than one would normally see - this has names down the
left side and other information on the right side and expands downward
if necessary. This form fills a complete printed 8 1/2 x 11 page. Does
someone know how this is done.


--
carole
------------------------------------------------------------------------
carole's Profile: http://www.excelforum.com/member.php...o&userid=34643
View this thread: http://www.excelforum.com/showthread...hreadid=550723


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
form help!! harpscardiff Excel Discussion (Misc queries) 7 April 5th 06 03:09 PM
Editing a simple macro Connie Martin Excel Worksheet Functions 5 November 29th 05 09:19 PM
Is there a way to convert a EXCEL form into a WORD form? Carole O Excel Discussion (Misc queries) 1 April 27th 05 10:13 PM
Data Form Deletions CyberTaz Excel Discussion (Misc queries) 1 April 26th 05 01:25 PM
Trying to delete form border, and it deletes all borders PeterM Excel Discussion (Misc queries) 11 January 3rd 05 03:36 PM


All times are GMT +1. The time now is 05:40 AM.

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"