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.