ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing problem (https://www.excelbanter.com/excel-discussion-misc-queries/54681-printing-problem.html)

TUNGANA KURMA RAJU

Printing problem
 
How can I print screen shot of my worksheet?
How can I print only formulas of my workbook at one go?
I have formatted my work sheet as tabular form ,user friendly query
type,can I print it the same way as it appesrs in the screen?

alokbist

Printing problem
 

How can I print screen shot of my worksheet?

paste it into any of the office suite... for example, after taking the
print screen shot (screen shot) paste it into the excel sheet (a new
one) and then trim accordingly... i hope i understood ur question
correctly :)

How can I print only formulas of my workbook at one go?

ALT+T+O - VIEW - tick the FORMULAS chk box under the WINDOW OPTIONS
-- it will work...

I have formatted my work sheet as tabular form ,user friendly query
type,can I print it the same way as it appesrs in the screen?

sorry, i didn't get u.. -- by my level of uderstanding just select the
range and then in printing section select the active sheet area only...


--
alokbist
------------------------------------------------------------------------
alokbist's Profile: http://www.excelforum.com/member.php...o&userid=28699
View this thread: http://www.excelforum.com/showthread...hreadid=483810


TUNGANA KURMA RAJU

Printing problem
 
It's ok but my worksheet contains a2:m60,all cells contains formulas,fromuals
wrapping by which I am not able to see full formula text and printing full
formula is not working.

"alokbist" wrote:


How can I print screen shot of my worksheet?

paste it into any of the office suite... for example, after taking the
print screen shot (screen shot) paste it into the excel sheet (a new
one) and then trim accordingly... i hope i understood ur question
correctly :)

How can I print only formulas of my workbook at one go?

ALT+T+O - VIEW - tick the FORMULAS chk box under the WINDOW OPTIONS
-- it will work...

I have formatted my work sheet as tabular form ,user friendly query
type,can I print it the same way as it appesrs in the screen?

sorry, i didn't get u.. -- by my level of uderstanding just select the
range and then in printing section select the active sheet area only...


--
alokbist
------------------------------------------------------------------------
alokbist's Profile: http://www.excelforum.com/member.php...o&userid=28699
View this thread: http://www.excelforum.com/showthread...hreadid=483810




All times are GMT +1. The time now is 09:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com