Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I print a LIST of cell contents? | Excel Discussion (Misc queries) | |||
How do I print only cell contents of a Excel 2007 spreadsheet? | Excel Discussion (Misc queries) | |||
how do I print the contents of a cell that is over the max limit? | Excel Discussion (Misc queries) | |||
print cell contents | Excel Discussion (Misc queries) | |||
Check cell contents before print | Setting up and Configuration of Excel |