Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
Wonder if anyone can help with this, have looked in previous threads but to no avail I have on sheet, with data in the first say 6 columns and then in the seventh column and say the 5th row down, have selected freeze frame. The next colums have data in them, say up to column AA, but will increase the colums as more data is added Q. how can I set this sheet up ,in order that the operator can print the actual cells that are visible on the screen, and not print those that are hidden owing to scrolling along the columns. I am aware of the edit/goto/special/visible cells only, but looking for quicker/foolproof. Is there a macro that can take care of the moving parameters? Hope i have explained enough and thanks in advance regards -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
how do I freeze my column labels so that they print every page? | Excel Discussion (Misc queries) | |||
How can I print the column headers in a freeze pane on all pag | Excel Discussion (Misc queries) | |||
Freeze frame printing | Excel Worksheet Functions | |||
How to attach legend frame to chart frame? | Charts and Charting in Excel |