how do you copy and paste in excel and keep the gridlines?
The gridlines can be included if you have Gridlines checked in Page Setup when you copy the Excel content. Alternatively, in Excel you can hold Shift while you open the Edit menu, select Copy Picture & choose the As shown on screen option in the little dialog that pops up on screen.