Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 258
Default Filling in a Gov't Form

Good morning --

I'd like to use Excel to fill in a set of Federal forms. So that they don't
reject it, I'd like to scan it in, and then just orient the cells to fit and
print in the correct spots in the forms. I'd prefer not to do this in Word,
for a variety of reasons.

I've tried scanning in the document, pasting it, and then "send to back",
but it still covers up any text in the cells.

Can someone tell me if and how I can do this?

Thanks in advance.

Peter
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default Filling in a Gov't Form

Format | Sheet | Background
then choose the scanned picture of the form.

Good luck on setting up the cell alignment - it gets tricky. You'll
probably also want to set the sheet's PrintArea so that it prints a copy that
includes all of the form you've got set up as the background.

You'll notice that the background will be repeated many times on the sheet -
that is because it is a background. By controlling the PrintArea, you'll
control what actually gets printed.

For setting up the sheet so that you can fill in the appropriate areas
relatively easily, this is one time I recommend using the Merge Cells
function. Grab lots of columns and set their width to something narrow, like
3 or 4. Then use row height adjustments to get the bottom of the rows lined
up with the form properly. You can merge cells on a row to get the space you
need to type in responses. By having lots of columns to use for the merges,
you have more flexibility in getting them aligned. It'll probably take you a
couple of tries to get things lined up just the way you want. I suggest that
you start doing your alignments in a top-down, left to right fashion as it
will probably make aligning column edges with blank spot starts easier as you
work across the page.

"pdberger" wrote:

Good morning --

I'd like to use Excel to fill in a set of Federal forms. So that they don't
reject it, I'd like to scan it in, and then just orient the cells to fit and
print in the correct spots in the forms. I'd prefer not to do this in Word,
for a variety of reasons.

I've tried scanning in the document, pasting it, and then "send to back",
but it still covers up any text in the cells.

Can someone tell me if and how I can do this?

Thanks in advance.

Peter

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
scanning form and filling in blanks Swedish Excel Discussion (Misc queries) 0 October 27th 06 03:33 AM
filling a form in Excel... lookup? maybe? bigwerdz Excel Discussion (Misc queries) 2 September 29th 06 04:18 PM
Form Filling Abhishek kedia Excel Discussion (Misc queries) 0 September 22nd 06 02:29 PM
Filling in a form from a list sweetsue516 Excel Discussion (Misc queries) 0 March 29th 06 06:50 PM
filling a form in webpage R.VENKATARAMAN Excel Discussion (Misc queries) 0 August 19th 05 08:51 AM


All times are GMT +1. The time now is 12:05 PM.

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

About Us

"It's about Microsoft Excel"