ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 1997 (https://www.excelbanter.com/excel-discussion-misc-queries/17460-excel-1997-a.html)

mtboy12983

Excel 1997
 
I know, I know......
It's time to upgrade my microsoft office software, but right now I can't
afford it. So I'm stuck still using my Office '97 edition. Anyway, I was
wondering if there was any way to hide the contents of a specific cell so
that when I printed the page the contents would not be seen.
Does anyone know how I might go about doing that?
Thx.

Ken Russell

You could change the colour of the characters in that cell to white, but
don't forget to change it back or you will never see it on screen.

--
Ken Russell


Remove yourhat to reply by e-mail
..

"mtboy12983" wrote in message
...
I know, I know......
It's time to upgrade my microsoft office software, but right now I can't
afford it. So I'm stuck still using my Office '97 edition. Anyway, I was
wondering if there was any way to hide the contents of a specific cell so
that when I printed the page the contents would not be seen.
Does anyone know how I might go about doing that?
Thx.




Earl Kiosterud

Excel 97 is quite powerful enough for many users. Unless there's something
in a later release you need, you'll be fine with it. The files for XL97
through XL2003 are all compatible both ways.

As for not printing stuff, there are some things. You can set a print area
(a single range that prints, excluding the cells outside that range). Other
than that, Excel prints the sheet as is. Before you print, you can hide
columns or rows, or format cells the same color as the background, rendering
them invisible. But then you have to set all that stuff back if you want to
see it on the screen.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"mtboy12983" wrote in message
...
I know, I know......
It's time to upgrade my microsoft office software, but right now I can't
afford it. So I'm stuck still using my Office '97 edition. Anyway, I was
wondering if there was any way to hide the contents of a specific cell so
that when I printed the page the contents would not be seen.
Does anyone know how I might go about doing that?
Thx.




mtboy12983

Good thinking Ken. Thanks for the advice. I'll definitely use that. It's so
simple, I'm not so sure why I never thought of it.
Both you and Earl have some very good thoughts on the situation.
Thanks again.


"Ken Russell" wrote:

You could change the colour of the characters in that cell to white, but
don't forget to change it back or you will never see it on screen.

--
Ken Russell


Remove yourhat to reply by e-mail
..

"mtboy12983" wrote in message
...
I know, I know......
It's time to upgrade my microsoft office software, but right now I can't
afford it. So I'm stuck still using my Office '97 edition. Anyway, I was
wondering if there was any way to hide the contents of a specific cell so
that when I printed the page the contents would not be seen.
Does anyone know how I might go about doing that?
Thx.






All times are GMT +1. The time now is 05:59 PM.

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