Printing Question

[Guest]

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

 

[Guest]

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:

 

[oldchippy]

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

My question is this: Can I print a part of the payperiods, ie the las
3
paychecks of the year (columns Y, Z, AA) along with column A (to sho
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 :

 

[Guest]

Thanks, that worked

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:

 

[Guest]

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