Excel for Mac Professional 2019: Select & position cells for printing into a pre-printed form

[JohnDohe]

Hi,

Re: Excel for Mac Professional 2019

I've got a pre-printed form with dozens of boxes and fields that have to be
filled in with various data from cells of my spreadsheet.

Not only must I select specific cells to print, but they also have to be positioned
into the various boxes and fields of the pre-printed form.

How to go about this?

Thanks!

 

[usagora]

Unless the creator of the pre-printed forms has provided you with a template spreadsheet designed specifically for the form, then you're going to have to do a lot of measuring!

First, switch to page layout view so you can see your margins and the page ruler. Then set your margins for the spreadsheet to match the margins of the pre-printed form to make things easier. Then you'll need to position your cells in your spreadsheet the same distance from the margins as they are on the form. You can do this by adjusting the row and column heights on surrounding cells to "fine-tune" the placement.

 

[JohnDohe]

Unless the creator of the pre-printed forms has provided you with a template spreadsheet designed specifically for the form, then you're going to have to do a lot of measuring!

First, switch to page layout view so you can see your margins and the page ruler. Then set your margins for the spreadsheet to match the margins of the pre-printed form to make things easier. Then you'll need to position your cells in your spreadsheet the same distance from the margins as they are on the form. You can do this by adjusting the row and column heights on surrounding cells to "fine-tune" the placement.

Hey, thanks!
Yeah, I figured this was going to be a bear to do.
Just needed a hint on how to get started.
Thanks!