Question: how to copy and paste with borders in excel?
Answer: Click the upper-left cell in the range with the border you want to copy. Drag your cursor to the range's lower-right cell, selecting the entire range. Click "Home" on Excel's menu bar. Click the "Format Painter" icon from the ribbon's Clipboard tab.