| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidden columns
I have hidden columns in my spreadsheet and do not want these to print when I
print the spreadsheet, how is this done? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hidden columns
Keep them hidden.
They won't print. Gord Dibben Excel MVP On Wed, 30 Nov 2005 12:57:11 -0800, "Amste" wrote: I have hidden columns in my spreadsheet and do not want these to print when I print the spreadsheet, how is this done? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hidden columns
Thanks for your response however I have tried that already and they do print.
Any other suggestions? "Gord Dibben" wrote: Keep them hidden. They won't print. Gord Dibben Excel MVP On Wed, 30 Nov 2005 12:57:11 -0800, "Amste" wrote: I have hidden columns in my spreadsheet and do not want these to print when I print the spreadsheet, how is this done? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hidden columns
If you change the foreground colour to the background colour for the
columns you do not want to see, then they should not appear on a printout. This does not really fix your problem, though. Pete |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hidden columns
Might not fix the problem but is a good suggestion, thanks!
"Pete" wrote: If you change the foreground colour to the background colour for the columns you do not want to see, then they should not appear on a printout. This does not really fix your problem, though. Pete |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hidden columns
Have no other suggestions because hidden columns normally do not print.
Gord On Wed, 30 Nov 2005 13:51:11 -0800, "Amste" wrote: Thanks for your response however I have tried that already and they do print. Any other suggestions? "Gord Dibben" wrote: Keep them hidden. They won't print. Gord Dibben Excel MVP On Wed, 30 Nov 2005 12:57:11 -0800, "Amste" wrote: I have hidden columns in my spreadsheet and do not want these to print when I print the spreadsheet, how is this done? Thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hidden columns
How are you hiding the columns? -- Richard9278 ------------------------------------------------------------------------ Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770 View this thread: http://www.excelforum.com/showthread...hreadid=489581 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hidden columns
by dragging them
"Richard9278" wrote: How are you hiding the columns? -- Richard9278 ------------------------------------------------------------------------ Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770 View this thread: http://www.excelforum.com/showthread...hreadid=489581 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hidden columns
Amste, Try right clicking on the column heading for the column you wish to hide and choosing "Hide" on the menu that appears. To unhide, highlight the two columns headings on either side, right click somewhere in the two column headings and choose "Unhide". Amste Wrote: by dragging them "Richard9278" wrote: How are you hiding the columns? -- Richard9278 ------------------------------------------------------------------------ Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770 View this thread: http://www.excelforum.com/showthread...hreadid=489581 -- Richard9278 ------------------------------------------------------------------------ Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770 View this thread: http://www.excelforum.com/showthread...hreadid=489581 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hidden columns
Hi there,
I tried this and it did work, thanks a lot for your help. "Richard9278" wrote: Amste, Try right clicking on the column heading for the column you wish to hide and choosing "Hide" on the menu that appears. To unhide, highlight the two columns headings on either side, right click somewhere in the two column headings and choose "Unhide". Amste Wrote: by dragging them "Richard9278" wrote: How are you hiding the columns? -- Richard9278 ------------------------------------------------------------------------ Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770 View this thread: http://www.excelforum.com/showthread...hreadid=489581 -- Richard9278 ------------------------------------------------------------------------ Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770 View this thread: http://www.excelforum.com/showthread...hreadid=489581 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hidden columns
Amste
How do you hide a column by dragging it? Drag to where? I might learn a new trick here<g Gord On Wed, 30 Nov 2005 16:35:02 -0800, "Amste" wrote: by dragging them "Richard9278" wrote: How are you hiding the columns? -- Richard9278 ------------------------------------------------------------------------ Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770 View this thread: http://www.excelforum.com/showthread...hreadid=489581 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hidden columns
Hi Gord,
The right way to hide columns so they won't print is by right clicking and choosing hide columns. I was highlighting the columns I wanted to hide and dragging them to the next column so they wouldn't appear however, they will print when you do this. Thanks for your help. "Gord Dibben" wrote: Amste How do you hide a column by dragging it? Drag to where? I might learn a new trick here<g Gord On Wed, 30 Nov 2005 16:35:02 -0800, "Amste" wrote: by dragging them "Richard9278" wrote: How are you hiding the columns? -- Richard9278 ------------------------------------------------------------------------ Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770 View this thread: http://www.excelforum.com/showthread...hreadid=489581 |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hidden columns
I was wondering if you just changed the width and did not actually hide them.
Now I know. Thanks, Gord On Fri, 2 Dec 2005 14:22:02 -0800, "Amste" wrote: Hi Gord, The right way to hide columns so they won't print is by right clicking and choosing hide columns. I was highlighting the columns I wanted to hide and dragging them to the next column so they wouldn't appear however, they will print when you do this. Thanks for your help. "Gord Dibben" wrote: Amste How do you hide a column by dragging it? Drag to where? I might learn a new trick here<g Gord On Wed, 30 Nov 2005 16:35:02 -0800, "Amste" wrote: by dragging them "Richard9278" wrote: How are you hiding the columns? -- Richard9278 ------------------------------------------------------------------------ Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770 View this thread: http://www.excelforum.com/showthread...hreadid=489581 |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hidden columns
Are you, by any chance, "hiding" them by letting them scroll off the screen and then setting Frames? Rick -- Richard9278 ------------------------------------------------------------------------ Richard9278's Profile: http://www.excelforum.com/member.php...o&userid=28770 View this thread: http://www.excelforum.com/showthread...hreadid=489581 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i copy formula down columns avoiding hidden cells | Excel Discussion (Misc queries) | |||
| PLEASE HELP - Pasting Cells to WrkSheet with Hidden Columns | Excel Worksheet Functions | |||
| Is there a maximum number of non-contiguous columns that can be h. | Excel Discussion (Misc queries) | |||
| How do I lock hidden columns? | Excel Worksheet Functions | |||
| How do I prevent hidden columns from being revealed by another use | Excel Discussion (Misc queries) | |||
Hybrid Mode
