i'm working on a report that is 2 pages on 1 sheet. before printing, i want to hide a column on the first page, without affecting that same column on the 2nd page. is it possible to do this without putting the 2 pages on separate sheets?
Good question, I don't think you can. Can't you just cut the information you need to show in the column that you want to hide for the 2nd page to a different column? I mean since you want to do this, your headings aren't going to line up anyway (if I am understanding your problem correctly) so does it really matter?
basically, i want to hide Column E on the first page, without hiding Column E on the 2nd page. i can just cut Column E and paste it elsewhere, but i need the values in E every month to make other calculations. still, that just leaves a blank column.
Cntrl-click to select all the data you want to print except the cells in question. Than select File-Print and hit the "print selection" radio button. I think that will work but I did not try it.
thanks, but that's not what i'm looking for. i send this out to several people and they need to be able to print it without having to do any changes. all they should need to do is click print.
I'm not understanding why you can't just move this column off the printable page. Does its placement on the computer monitor matter? You can add a column adjacent to the one you want to hide and make it very narrow. Move the stuff you want to hide into that narrow column and leave the rest. On the screen, you'll be able to see the column because it'll spill over into the next column which is now blank. But, you can easily hide the column when you want to print. Or, you can change the font of the thing you don't want printing to white.
Only way you can do what you want to do is via a macro. Try doing what I said above, only record the whole thing (all the way through print selection) as a macro. Than make a button on the sheet linked to that macro called "Print". That's about the best I can come up with.
Thanks! that work perfectly. i just never thought about that. i tried that. the new column will just line up with the same column on the 2nd page. when i narrow the new column on page 1, it'll narrow the column on page 2 as well.
macalu, Try playing with your page breaks - you might get this to work if you adjust the page breaks to be the way you want them.
an easy way to do it would be to just highlight all the cells in that column on page one and make the font white. It may not be formatted all that great, but should work. Or do something along the lines of what Juan is saying. On the second table, effectively move everything in columns to the right of E out one column. Column F becomes column G, G to H, H to I, etc. Then you should have a blank column F. Make this column the exact same as column E, then hide/group column E. Now on your first table E is completely gone, on your second table, E is gone, but F is still there and F is the same as E.... kinda of confusing, but does that make sense?
