Learn Photography

You can download and use the spreadsheet below to determine the image size on your prints.

There are also tables with common border sizes.

The spreadsheet is an Excel spreadsheet.

Excel is part of Microsoft Office (Windows), iWork (Mac), and may also be opened with OpenOffice.

Calculator_for_Border_Image_Sizes_for_Full-frame_Prints.xlsx

1) Enter the paper size (the red numeral 1, below).

2) Enter the size of the left and right borders (the cyan 2).

The spreadsheet computes the image size for you (the green 3 and circles).

Lightroom values are located in the pink table.

First, select the table for the left and right border size that you want: 0, .25, .5, or 1 inch.

In that table, look for the paper size that you're using in the first column.

The image size is in the last column.

Left & Right Borders | Top & Bottom Borders | Image Size | |

5" x 7" | 0" | .167" | 4.667" x 7" |

8" x 10" | 0" | .667" | 6.667" x 10" |

8.5" x 11" | 0" | .583" | 7.333" x 11" |

8" x 12" | 0" | .0" | 8" x 12" |

11" x 14" | 0" | .833" | 9.333" x 14" |

16" x 20" | 0" | 1.333" | 13.333" x 20" |

17" x 22" | 0" | .167" | 14.667" x 22" |

Left & Right Borders | Top & Bottom Borders | Image Size | |

5" x 7" | .25" | .35" | 4.5" x 6.3" |

8" x 10" | .25" | .833" | 6.333" x 9.5" |

8.5" x 11" | .25" | .75" | 7" x 10.5" |

8" x 12" | .25" | .167" | 7.667" x 11.5" |

11" x 14" | .25" | 1" | 9" x 13.5" |

16" x 20" | .25" | 1.5" | 13" x 19.5" |

17" x 22" | .25" | 1.333" | 14.333" x 21.5" |

Left & Right Borders | Top & Bottom Borders | Image Size | |

8" x 10" | .5" | 1" | 6" x 9" |

8.5" x 11" | .5" | .917" | 6.667" x 10" |

8" x 12" | .5" | .333" | 7.333" x 11" |

11" x 14" | .5" | 1.167" | 8.667" x 13" |

16" x 20" | .5" | 1.667" | 12.667" x 19" |

17" x 22" | .5" | 1.5" | 14" x 21" |

Left & Right Borders | Top & Bottom Borders | Image Size | |

16" x 20" | 1" | 2" | 12" x 20" |

17" x 22" | 1" | 1.833" | 13.333" x 20" |