Excel Freeze panel and then only copy what you see

[mdarsot]

Is there a way in excel you can copy freezed panel column and the column right next to it only nothing in between.

Right now when i copy it copies everything instead of what i see

for example

headings (row#1)
1
2
3
4

I have Row #1 Panel freeze.

now what if i am browsing at row #4 and i only want to copy the heading and column 4 nothing in between. is there a way to do it.

Currently when i select it, all row 1 to 4 gets selected.

 

[mdarsot]

Oh yeah and i know i can do it with Control key one by one. But what if i want to do multi select.

 

[GlennUK]

It sounds like you want to do screen capture and not just printing. Printing doesn't print what you see, it prints what exists in the print area regardless of what is in your viewing area. Do you really want to go down this route?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[xlbo]

There is no EASY way to do what you want

There may be a way to do so in VBA but not sure.

If you want to progress with a VBA solution, please re-post in forum707

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question