I have a spreadsheet that I enter each paycheck info into. The categories,
ie Reg Pay, OT Pay, Taxes, etc., are listed in Column A and each payperiod
figures are entered in columns B - AA. I have also freezed column A so that
the categories are always showing.

My question is this: Can I print a part of the payperiods, ie the last 3
paychecks of the year (columns Y, Z, AA) along with column A (to show the
categories) without printing the payperiods inbetween?

Thanks,
Les

hi,

you can use two ways to do that,

1 - hide the columns between the A and Y columns and print it,

2 - file | page setup | sheet
- print area (set the Y,Z and AA)
- Columns to repeat left A

Sorry if the text is a bit different from your excel menus, I'm working in a
Brazilian Portuguese Excel.


hth
regards from Brazil
May the force be with you
Marcelo
*******************


"WLMPilot" escreveu:

I have a spreadsheet that I enter each paycheck info into. The categories,
ie Reg Pay, OT Pay, Taxes, etc., are listed in Column A and each payperiod
figures are entered in columns B - AA. I have also freezed column A so that
the categories are always showing.

My question is this: Can I print a part of the payperiods, ie the last 3
paychecks of the year (columns Y, Z, AA) along with column A (to show the
categories) without printing the payperiods inbetween?

Thanks,
Les

WLMPilot Wrote:
I have a spreadsheet that I enter each paycheck info into. The
categories,
ie Reg Pay, OT Pay, Taxes, etc., are listed in Column A and each
payperiod
figures are entered in columns B - AA. I have also freezed column A so
that
the categories are always showing.

My question is this: Can I print a part of the payperiods, ie the last
3
paychecks of the year (columns Y, Z, AA) along with column A (to show
the
categories) without printing the payperiods inbetween?

Thanks,
Les
Hi Les,

Try this,

Select columns B to X, then Format Columns Hide

That should do it

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=572141

Thanks, that worked

Les



"Marcelo" wrote:

hi,

you can use two ways to do that,

1 - hide the columns between the A and Y columns and print it,

2 - file | page setup | sheet
- print area (set the Y,Z and AA)
- Columns to repeat left A

Sorry if the text is a bit different from your excel menus, I'm working in a
Brazilian Portuguese Excel.


hth
regards from Brazil
May the force be with you
Marcelo
*******************


"WLMPilot" escreveu:

I have a spreadsheet that I enter each paycheck info into. The categories,
ie Reg Pay, OT Pay, Taxes, etc., are listed in Column A and each payperiod
figures are entered in columns B - AA. I have also freezed column A so that
the categories are always showing.

My question is this: Can I print a part of the payperiods, ie the last 3
paychecks of the year (columns Y, Z, AA) along with column A (to show the
categories) without printing the payperiods inbetween?

Thanks,
Les

Thanks. I am sure that would work, but I think the other response I got
works better since I don't have to HIDE/UNHIDE constantly to view the
spreadsheet.

Thanks again,
Les

"oldchippy" wrote:


WLMPilot Wrote:
I have a spreadsheet that I enter each paycheck info into. The
categories,
ie Reg Pay, OT Pay, Taxes, etc., are listed in Column A and each
payperiod
figures are entered in columns B - AA. I have also freezed column A so
that
the categories are always showing.

My question is this: Can I print a part of the payperiods, ie the last
3
paychecks of the year (columns Y, Z, AA) along with column A (to show
the
categories) without printing the payperiods inbetween?

Thanks,
Les
Hi Les,

Try this,

Select columns B to X, then Format Columns Hide

That should do it

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=572141