View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
WLMPilot WLMPilot is offline
external usenet poster
 
Posts: 470
Default In freezed panes how do i print rows a-d and l-k together on 1 pg?

Click on FilePage SetupSheet. In the "Columns to repeat at left", type
$A:$D

From this point on, you can highlight any columns you wish to print, ie L-N,
and set as the print area, then print.



"Excel questions about printing" wrote:

I have a freeze pane for taking inventory. How can I print rows A-D(my
products) and rows L-N(my dates) together side by side on 1 page ??