I don't know if I am missing something, but I'm confused about your reference to cell A3? But as for your automatic print, you can set up a print area. Simply activate all areas you want to default the printing (select Sheet 1 - (A1:N278)>holding control>select Sheet 5 (A1:A57)>select Sheet 5 (AA1:DA57) go to the Page Layout tab select Print Area>Set Print Area. 

Thank you so much for Your respose.

I mean A3 Sheet is also Fine. 

My problem is the selected  sheet for Printing is huge data, My query is how can I fit that into one A3 Sheet.?

Sheet 1 - in One A3 sheet

Sheet 2 - in One A3 sheet

Hello,

As you surely knows, the result all depends on what margin widths you choose, what row and column widths and heigths you have and so forth.
I have put togheter some examples showing how many rows and columns that fits in an A3 sheet.

For your sheet 1 it is no problem regarding the width, it fits, but not the number of rows, unless you choose to shrink so all rows fit within one sheet, but then I assume it will not be readable without a magnifying glass. The best option here would be to set print titles so that the header row(s) are to be repeated for each sheet.

For sheet 3 you need to set A1:DA57 as your print area and then hide columns B to Z in order to get correct printout. See example files.
The same issue here regarding fitting all columns to one sheet, it would not be readable.

In order to automate this you would need to create a macro. You don't need to be good at writing the VBA code, Excel can do it for you if you record your actions. In order to do such recording you need the Developer tab.

I hope this gives you some guidance.

Br,
Anders

Hello Anders, 

Thank You so much for the Valuable Solutions its really helps me alot. 

It really gives me an idea for my problem.