Print functions

Top  Previous  Next

Set Selected Range as Print Range. This saves you quite a few key-strokes. Select the range you want as the print range then use this utility to mark this as the default print area for that sheet.

 

Delete print area in selected sheet                This will delete the print range set for the sheet. Will be available in Next version. Contact the author.

Range - Copy Formulas without change of reference                "With this program you can copy a range of formulas to another place without changing the cell reference. Suppose you have put a formula in cell ""A12 "" which is ""=sum(a1..a11)"" then you can use this program to copy the formula to say cell a15 and it would still have the same formula. You can copy a range of formula but the destination select the upper left top corner. Will be available in Next version. Contact the author."

Range - Join Cells with                "This again would be within the top 10 program. With this program you can join multiple column of data with a specified character in middle, all the joined character would now appear in the extreme left column."

 

Delete Print Area in Selected Sheet. Use this util to blank out the selected print range so that Excel can select the print range automatically.

 

Delete Print Area in all Sheets in Current Workbook. Use this util to blank out the selected print range in all the worksheets in the current file so that Excel can select the print range automatically.