Copying and pasting Hidden columns - Excel 2007

[slay0r]

Hi All,

I'm using Excel 2007 for the first time in a while since switching jobs, I hide columns and try and copy what I can see but it's copying the whole line into the new spreadsheet. Annoyingly it doesn't do it on my colleagues spreadsheets only mine?! I've tried saving as different formats and a couple of quick fixes but it still seems to be doing it, any ideas I'm going *******s!

Kind Regards
Jonathan

 

[Fluff]

The default is to copy all cells regardless.
One work round, is select the range you want to copy > Alt ; > Ctrl C > Goto your paste range > Ctrl V