#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Printing Objects

How do I print objects with the rest of the worksheet? Currently when I
print the worksheet, the object is just left off the printed page. Thanks.

~J
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Printing Objects

Try rightclicking on the object (you may have to be in design mode for some of
them).

Choose Format Control (or format autoshape or format something)
On the Properties tab, check the Print option.

If this doesn't work, what is the object that you're using.



soldier1981 wrote:

How do I print objects with the rest of the worksheet? Currently when I
print the worksheet, the object is just left off the printed page. Thanks.

~J


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Printing Objects

In Options elect to print Objects

soldier1981 wrote:

How do I print objects with the rest of the worksheet? Currently when I
print the worksheet, the object is just left off the printed page. Thanks.

~J


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Printing Objects

It's actually an banner I got from autoshapes. Instead of linking a
powerpoint object I just used an autoshape cuz I wanted a different color
pattern that was not available when just normally filling in cells. Is that
different if its an autoshape??
~J

"Dave Peterson" wrote:

Try rightclicking on the object (you may have to be in design mode for some of
them).

Choose Format Control (or format autoshape or format something)
On the Properties tab, check the Print option.

If this doesn't work, what is the object that you're using.



soldier1981 wrote:

How do I print objects with the rest of the worksheet? Currently when I
print the worksheet, the object is just left off the printed page. Thanks.

~J


--

Dave Peterson

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Printing Objects

The menu option for autoshapes says: Format Autoshape

Did it work when you tried it?

soldier1981 wrote:

It's actually an banner I got from autoshapes. Instead of linking a
powerpoint object I just used an autoshape cuz I wanted a different color
pattern that was not available when just normally filling in cells. Is that
different if its an autoshape??
~J

"Dave Peterson" wrote:

Try rightclicking on the object (you may have to be in design mode for some of
them).

Choose Format Control (or format autoshape or format something)
On the Properties tab, check the Print option.

If this doesn't work, what is the object that you're using.



soldier1981 wrote:

How do I print objects with the rest of the worksheet? Currently when I
print the worksheet, the object is just left off the printed page. Thanks.

~J


--

Dave Peterson


--

Dave Peterson


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Printing Objects

It works. Thanks so very much for the help!! ~J

"Dave Peterson" wrote:

The menu option for autoshapes says: Format Autoshape

Did it work when you tried it?

soldier1981 wrote:

It's actually an banner I got from autoshapes. Instead of linking a
powerpoint object I just used an autoshape cuz I wanted a different color
pattern that was not available when just normally filling in cells. Is that
different if its an autoshape??
~J

"Dave Peterson" wrote:

Try rightclicking on the object (you may have to be in design mode for some of
them).

Choose Format Control (or format autoshape or format something)
On the Properties tab, check the Print option.

If this doesn't work, what is the object that you're using.



soldier1981 wrote:

How do I print objects with the rest of the worksheet? Currently when I
print the worksheet, the object is just left off the printed page. Thanks.

~J

--

Dave Peterson


--

Dave Peterson

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Printing Objects

Okay, I'm an idiot. I was a little premature when I said it worked. I
should have said I found the spot where I can print the object, but I need it
printed BELOW the cells on the sheet. Whenever I print, it comes on top of
the sheet & blocks out the words under it. Can you still help with this??
Thanks. ~J

"Dave Peterson" wrote:

The menu option for autoshapes says: Format Autoshape

Did it work when you tried it?

soldier1981 wrote:

It's actually an banner I got from autoshapes. Instead of linking a
powerpoint object I just used an autoshape cuz I wanted a different color
pattern that was not available when just normally filling in cells. Is that
different if its an autoshape??
~J

"Dave Peterson" wrote:

Try rightclicking on the object (you may have to be in design mode for some of
them).

Choose Format Control (or format autoshape or format something)
On the Properties tab, check the Print option.

If this doesn't work, what is the object that you're using.



soldier1981 wrote:

How do I print objects with the rest of the worksheet? Currently when I
print the worksheet, the object is just left off the printed page. Thanks.

~J

--

Dave Peterson


--

Dave Peterson

  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Printing Objects

When I've printed objects like this, it always appears where I put it. So I
think you'll have to put it at the bottom -- or put another one at the bottom,
but only print that one.

soldier1981 wrote:

Okay, I'm an idiot. I was a little premature when I said it worked. I
should have said I found the spot where I can print the object, but I need it
printed BELOW the cells on the sheet. Whenever I print, it comes on top of
the sheet & blocks out the words under it. Can you still help with this??
Thanks. ~J

"Dave Peterson" wrote:

The menu option for autoshapes says: Format Autoshape

Did it work when you tried it?

soldier1981 wrote:

It's actually an banner I got from autoshapes. Instead of linking a
powerpoint object I just used an autoshape cuz I wanted a different color
pattern that was not available when just normally filling in cells. Is that
different if its an autoshape??
~J

"Dave Peterson" wrote:

Try rightclicking on the object (you may have to be in design mode for some of
them).

Choose Format Control (or format autoshape or format something)
On the Properties tab, check the Print option.

If this doesn't work, what is the object that you're using.



soldier1981 wrote:

How do I print objects with the rest of the worksheet? Currently when I
print the worksheet, the object is just left off the printed page. Thanks.

~J

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
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
Printing Photos and Objects in Excel 2007 R.G. Lowe Excel Discussion (Misc queries) 0 January 13th 07 03:03 PM
Non-Printing Objects Canoehead Excel Discussion (Misc queries) 2 July 19th 06 02:25 PM
Printing inserted objects AgileDarrell Charts and Charting in Excel 0 August 5th 05 09:07 PM
Printing objects on a worksheet Les Gordon Excel Discussion (Misc queries) 3 May 15th 05 09:49 AM
Enable Double sided printing contiuously when printing multiple s. Lee Excel Discussion (Misc queries) 1 November 27th 04 01:58 AM


All times are GMT +1. The time now is 06:35 AM.

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

About Us

"It's about Microsoft Excel"