Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default how do you print the contents of only one cell

Using Excell 2007 and can not figure out how to print the contents of only
one cell at time?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 506
Default how do you print the contents of only one cell

For 2003 & 2007

Press Alt+V+P now you can see some Blue lines just Drag it to the cell which
you want to set for Printing. Now you can notice that cell will have the
White Background and the remaining cells will be in Grey Colour.

To return to Normal View Press Alt+V+N

Another Method in 2003 just place the cursor in the cell which you want to
print (if you want to define 2 or 3 cells then select the cell range) and
select FilePrint AreaSet Print Area. Now give Alt+V+P, now you can notice
that the selected cells has been marked covered with blue line with the white
back ground.

To return to Normal View Press Alt+V+N

Now press

Alt+F+V for 2003 and select SetupPageScalingAdjust to and increase the
Zoom Percentage as per your wish.

Alt+F+W+V for 2007 and select SetupPageScalingAdjust to and increase the
Zoom Percentage as per your wish.

Before doing all these just increase the cell size and apply Wrap Text also
if required.

Wrap Text Can be done
Place the cursor in the printing cell and do right click from your mouse and
select Format CellsAlignmentText Control Check the Wrap Text option.

I think I have explained it correctly.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"kh2533" wrote:

Using Excell 2007 and can not figure out how to print the contents of only
one cell at time?

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
How can I print a LIST of cell contents? Yayo Excel Discussion (Misc queries) 3 June 16th 09 03:00 PM
How do I print only cell contents of a Excel 2007 spreadsheet? Johnny Page Excel Discussion (Misc queries) 1 May 19th 09 06:00 PM
how do I print the contents of a cell that is over the max limit? az_camaro Excel Discussion (Misc queries) 2 September 13th 07 12:32 AM
print cell contents delmac Excel Discussion (Misc queries) 1 February 14th 07 02:20 PM
Check cell contents before print nobbyknownowt Setting up and Configuration of Excel 3 May 26th 06 11:48 PM


All times are GMT +1. The time now is 10:22 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"