Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a lengthy, but somewhat narrow, spreadsheet which I would like to
print side-by-side, and then down (so I won't use as much paper). I see the Over, then down feature under page setup, but it does not seem to do anything. Does anyone know how to use that feature? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
David McRitchie has a macro that will "snake" the columns.
http://www.mvps.org/dmcritchie/excel/snakecol.htm Personally, I'd copy into MSWord (maybe hitting NotePad if MSWord slows down when I paste). Then use MSWord's Format|Column to make life easy. kkw wrote: I have a lengthy, but somewhat narrow, spreadsheet which I would like to print side-by-side, and then down (so I won't use as much paper). I see the Over, then down feature under page setup, but it does not seem to do anything. Does anyone know how to use that feature? -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dave,
If the Logo is to be a Header, you can always just paste it in the Header (View -- Header/Footer). Highlighting all the needed worksheets, by clicking on the first and holding CTRL and clicking on the others, then pasting the logo where you need it will also paste it on all the pages. **Make sure you unhighlight all your worksheets afterwards, or whatever changes you make on one worksheet will apear on all the others.** Jan |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Oops. Wrong thread???
JBarr wrote: Dave, If the Logo is to be a Header, you can always just paste it in the Header (View -- Header/Footer). Highlighting all the needed worksheets, by clicking on the first and holding CTRL and clicking on the others, then pasting the logo where you need it will also paste it on all the pages. **Make sure you unhighlight all your worksheets afterwards, or whatever changes you make on one worksheet will apear on all the others.** Jan -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem organizing text data into new excel page | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Save Excel as web page | Excel Discussion (Misc queries) | |||
export excel to Front Page | Excel Discussion (Misc queries) | |||
purchase order counter in excel purchase order template | Excel Worksheet Functions |