Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel
A 3-page worksheet only dsplays 2 pgs; shows 2 pgs in print preview, and
prints only two pages on a b&w printer. It prints all pages(3) in color. I need to edit data on page 3, ..Please Help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel
Maybe.........
Format Sheet Unhide Vaya con Dios, Chuck, CABGx3 "conroe76" wrote: A 3-page worksheet only dsplays 2 pgs; shows 2 pgs in print preview, and prints only two pages on a b&w printer. It prints all pages(3) in color. I need to edit data on page 3, ..Please Help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel
Thanks, I've tried that...could it have something to do with the print area?
It does not show page 3 on the print preview....? "CLR" wrote: Maybe......... Format Sheet Unhide Vaya con Dios, Chuck, CABGx3 "conroe76" wrote: A 3-page worksheet only dsplays 2 pgs; shows 2 pgs in print preview, and prints only two pages on a b&w printer. It prints all pages(3) in color. I need to edit data on page 3, ..Please Help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel
Sorry, my bad..........you clearly said " 3-page worksheet".............try
looking down the left side row numbers, probably at the end of the second page you will find some hidden rows, or across the column tops to find hidden columns. These are no-doubt manipulated in and out of the PrintArea by print macros.......... Vaya con Dios, Chuck, CABGx3 "conroe76" wrote: Thanks, I've tried that...could it have something to do with the print area? It does not show page 3 on the print preview....? "CLR" wrote: Maybe......... Format Sheet Unhide Vaya con Dios, Chuck, CABGx3 "conroe76" wrote: A 3-page worksheet only dsplays 2 pgs; shows 2 pgs in print preview, and prints only two pages on a b&w printer. It prints all pages(3) in color. I need to edit data on page 3, ..Please Help! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel
How do I fix this? -- Jaren12 ------------------------------------------------------------------------ Jaren12's Profile: http://www.excelforum.com/member.php...o&userid=29528 View this thread: http://www.excelforum.com/showthread...hreadid=492256 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel
If you've found hidden rows, and they show something like"
1 2 3 50 51 52 Then the rows numbered 4 through 49 are hidden. Highlight the row numbers on both sides of the split ( 3 and 50 here) and then right-click Unhide Vaya con Dios, Chuck, CABGx3 "Jaren12" wrote: How do I fix this? -- Jaren12 ------------------------------------------------------------------------ Jaren12's Profile: http://www.excelforum.com/member.php...o&userid=29528 View this thread: http://www.excelforum.com/showthread...hreadid=492256 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel
No hidden rows...
"CLR" wrote: If you've found hidden rows, and they show something like" 1 2 3 50 51 52 Then the rows numbered 4 through 49 are hidden. Highlight the row numbers on both sides of the split ( 3 and 50 here) and then right-click Unhide Vaya con Dios, Chuck, CABGx3 "Jaren12" wrote: How do I fix this? -- Jaren12 ------------------------------------------------------------------------ Jaren12's Profile: http://www.excelforum.com/member.php...o&userid=29528 View this thread: http://www.excelforum.com/showthread...hreadid=492256 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel
There are no hidden rows...? -- Jaren12 ------------------------------------------------------------------------ Jaren12's Profile: http://www.excelforum.com/member.php...o&userid=29528 View this thread: http://www.excelforum.com/showthread...hreadid=492256 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel
I dunno...........pretty hard to do this one by remote
control..............if the data is not confidential, you might send the file to my home addy and I'll take a look at it tonight. croberts at tampabay dot rr dot com Vaya con Dios, Chuck, CABGx3 "conroe76" wrote: No hidden rows... "CLR" wrote: If you've found hidden rows, and they show something like" 1 2 3 50 51 52 Then the rows numbered 4 through 49 are hidden. Highlight the row numbers on both sides of the split ( 3 and 50 here) and then right-click Unhide Vaya con Dios, Chuck, CABGx3 "Jaren12" wrote: How do I fix this? -- Jaren12 ------------------------------------------------------------------------ Jaren12's Profile: http://www.excelforum.com/member.php...o&userid=29528 View this thread: http://www.excelforum.com/showthread...hreadid=492256 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel
Have you checked across the top to see if there are hidden columns? Chris -- chrisnelsonusa1 ------------------------------------------------------------------------ chrisnelsonusa1's Profile: http://www.excelforum.com/member.php...o&userid=29526 View this thread: http://www.excelforum.com/showthread...hreadid=492256 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel
Thanks for all your replies. Since it does print all three pages in color, I will just scan the color pages and email it that way. Thanks All & Have a Great Weekend! -- Jaren12 ------------------------------------------------------------------------ Jaren12's Profile: http://www.excelforum.com/member.php...o&userid=29528 View this thread: http://www.excelforum.com/showthread...hreadid=492256 |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel
Soooo helpful. Got to highlight the two rows or columns which identify the
"missing/hidden" data range; and then "Unfreeze" from a right click or the Windows drop menu. After 3 hours CLR came to the rescue. No help from Excel Help. " CLR" wrote: If you've found hidden rows, and they show something like" 1 2 3 50 51 52 Then the rows numbered 4 through 49 are hidden. Highlight the row numbers on both sides of the split ( 3 and 50 here) and then right-click Unhide Vaya con Dios, Chuck, CABGx3 "Jaren12" wrote: How do I fix this? -- Jaren12 ------------------------------------------------------------------------ Jaren12's Profile: http://www.excelforum.com/member.php...o&userid=29528 View this thread: http://www.excelforum.com/showthread...hreadid=492256 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Installing: Microsoft Excel Feature | Excel Discussion (Misc queries) | |||
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
Microsoft Excel is waiting for another application to complete an OLE action | Excel Discussion (Misc queries) | |||
Excel instance used with "Export to Microsoft Excel" option in Internet Explorer | Excel Discussion (Misc queries) | |||
Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel |