Forum Discussion
Border control on a expandable worksheet
Hello, I have had a quote form I created many years ago that I am updating. The quote form uses VLOOKUP functions to grab information such as cost and descriptions from another sheet that we populate...
Try this trial to see if it can help. Open a blank sheet. On any given row put a dark border, write something, or shade in a column for a reference point. Select a large range, say from A1 to P23. Now go to conditional formatting and create a formula that says =row()=23. Select format... go to the border tab and put a bottom line in the sample cell. Say ok until you are out. On your spreadsheet you should have a line going across the page from a to p on line 23. If you add or delete any row, the line will stay on row 23 as the reference cells will move up or down.
You can format this line or lines in any way you see fit. Helpful?