ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   printing with freeze panes (https://www.excelbanter.com/excel-discussion-misc-queries/252637-printing-freeze-panes.html)

jenn

printing with freeze panes
 
I have columns A through AA with data.
if I have a freeze on column be and slide to the right I can see columns A,
B and AW, AX, AY, AZ

how can I print what I am seeing - instead of hiding the columns B thru AU?

Dave Peterson

printing with freeze panes
 
If the range to print were contiguous (no gaps), then you could select the range
and print the selected area.

But since you have two areas, I think you'll have to hide those columns.

If you have to do it lots of times, record a macro when you:
hide the columns
print
unhide the columns

Then you can rerun the macro whenever you want to do it again.

jenn wrote:

I have columns A through AA with data.
if I have a freeze on column be and slide to the right I can see columns A,
B and AW, AX, AY, AZ

how can I print what I am seeing - instead of hiding the columns B thru AU?


--

Dave Peterson


All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com