3 replies
you can NOT paste copied cell(s) into custome headers/footers. However you could combine all the cells into one like
=TEXT(E1 & D1 &C1&B1&A1,"#")
then copy this cell and pasteSpecial-Values into a cell edit this cell select all and copy again. Now you can paste this into a costum header (SHIFT+INSERT).
Odd and cumbersome but it works.
by kwndleslie
by jbmccarthy69
Here is a better way.
Leave the couple of lines where they are.
In Page Setup, select the Sheet tab.
There is a little area called Print titles with values you can put in for 'Rows to repeat at top'. To the right of the entry field, almost in the entry field, is an icon. Click on it; your spreadsheet in now showing. Select the lines (rows) you want as a header. Click the icon in the small page setup dialog. It expands to its original size and shows cell reference.
Try the Print Preview.
You should now see your lines as the header of every page.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending