Log In
Register
Home
May 13, 2021
Offline
I have a Big Data in Excel (In which it contains 6 Sheets)
I want to Print Automatically Sheet (1,5,6)
Sheet 1 - (A1:N278) I Want to print it fully and it should be in Readable (Visible)
Sheet 5 - (A1:DA57) but I want to print only (A1:A57) and (AA1:DA57)
It could be so helpful if someone find the way for automatic print with Readable. It can be in A3
See Answer
Trusted Members
February 13, 2021
Offline
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.
May 13, 2021
Offline
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
VIP
Trusted Members
December 7, 2016
Offline
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
Answers Post
1 Guest(s)
