Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
tikchye_oldLearner57
 
Posts: n/a
Default print 4 alternate columns

hello community

yesterday, 29th, a helpful person assisted me in solving - printing a column
and a selected area - that was fine and successful.

now, what happen when I wanted to print alternate columns only - i tried
ctrl+selection on alternate columns & use the Print Option - Print Selection
- but I not able to view it in 1 page & I also used the Print Option (At the
Sheet Tab area) - selected the "Repeated Columns on Left" - and use the Print
Area command - yet not able to get the alternate columns to view as 1 page to
print out.

can any body assist me on this ?

thanks for all assistance given :)

oldLearner57
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Paul
 
Posts: n/a
Default print 4 alternate columns

Only way I can see is to highlight the columns you don't want printing then
right click the mouse and choose hide. If you now select print command it
will print wysiwyg. To un-hide the columns select all the columns and right
click then un-hide. A bit fiddly but, hey. Unless someone knows a slicker
way.

"tikchye_oldLearner57" wrote:

hello community

yesterday, 29th, a helpful person assisted me in solving - printing a column
and a selected area - that was fine and successful.

now, what happen when I wanted to print alternate columns only - i tried
ctrl+selection on alternate columns & use the Print Option - Print Selection
- but I not able to view it in 1 page & I also used the Print Option (At the
Sheet Tab area) - selected the "Repeated Columns on Left" - and use the Print
Area command - yet not able to get the alternate columns to view as 1 page to
print out.

can any body assist me on this ?

thanks for all assistance given :)

oldLearner57

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extra Row in Defined Print Area Harry Gordon Excel Discussion (Misc queries) 3 November 14th 05 03:06 AM
Macro to open print window and set to print entire workbook retseort Excel Discussion (Misc queries) 1 October 27th 05 11:00 PM
Print few rows with many colums so that rows wrap on printed pages usfgradstudent31 Excel Discussion (Misc queries) 1 October 20th 05 02:39 PM
How to print multiple columns on same page ocpsduke Excel Discussion (Misc queries) 2 October 8th 05 06:19 PM
Columns FemIce Excel Discussion (Misc queries) 1 September 28th 05 09:29 AM


All times are GMT +1. The time now is 03:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"