#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default Neat Trick

I have a spreadsheet that I found online. It has an interesting feature that
I would like to integrate with my work. There is no VBA (that I can find).
There are no images in the file/tab (again, that I can find). It is kind of
like a watermark.

When viewing the spreadsheet, all of the cells are white background, maybe a
few cells of color here and there.

If you zoom out of the spreadsheet to show 50% it looks like a spreadsheet,
same at 30%. If you zoom out below 30%, a watermark appears on the sheet with
a name. This is totally cool. Does anyone know how to do this?

Thanks and Have a Great Day.

Frank Pytel
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default Neat Trick

Are you perhaps in the "Page Break" view?


--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Frank Pytel" wrote in message
...
I have a spreadsheet that I found online. It has an interesting feature
that
I would like to integrate with my work. There is no VBA (that I can find).
There are no images in the file/tab (again, that I can find). It is kind
of
like a watermark.

When viewing the spreadsheet, all of the cells are white background, maybe
a
few cells of color here and there.

If you zoom out of the spreadsheet to show 50% it looks like a
spreadsheet,
same at 30%. If you zoom out below 30%, a watermark appears on the sheet
with
a name. This is totally cool. Does anyone know how to do this?

Thanks and Have a Great Day.

Frank Pytel



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default Neat Trick

RagDyer;

No, I don't think I was. I might have been. It said 'talley' vertically on
the page. It was there just as plain as day. The letters of the word changed
the cell background color to gray.

I may have been in print preview, but I don't think so. Is it possible to do
this in print preview? Change the Page 1, Page 2 etc. Is this done in the
back. Is there a watermark feature to Excel?

Thanks RagDyer.

Frank Pytel

"RagDyer" wrote:

Are you perhaps in the "Page Break" view?


--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Frank Pytel" wrote in message
...
I have a spreadsheet that I found online. It has an interesting feature
that
I would like to integrate with my work. There is no VBA (that I can find).
There are no images in the file/tab (again, that I can find). It is kind
of
like a watermark.

When viewing the spreadsheet, all of the cells are white background, maybe
a
few cells of color here and there.

If you zoom out of the spreadsheet to show 50% it looks like a
spreadsheet,
same at 30%. If you zoom out below 30%, a watermark appears on the sheet
with
a name. This is totally cool. Does anyone know how to do this?

Thanks and Have a Great Day.

Frank Pytel




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default Neat Trick

It's just "names view" I think. When zoom gets to 39% or less any range
names appear visibly. Of course the larger the range they cover the easier
it is to see them.

--
Jim
"Frank Pytel" wrote in message
...
| RagDyer;
|
| No, I don't think I was. I might have been. It said 'talley' vertically on
| the page. It was there just as plain as day. The letters of the word
changed
| the cell background color to gray.
|
| I may have been in print preview, but I don't think so. Is it possible to
do
| this in print preview? Change the Page 1, Page 2 etc. Is this done in the
| back. Is there a watermark feature to Excel?
|
| Thanks RagDyer.
|
| Frank Pytel
|
| "RagDyer" wrote:
|
| Are you perhaps in the "Page Break" view?
|
|
| --
| Regards,
|
| RD
|
|
---------------------------------------------------------------------------

| Please keep all correspondence within the NewsGroup, so all may benefit
!
|
---------------------------------------------------------------------------

| "Frank Pytel" wrote in message
| ...
| I have a spreadsheet that I found online. It has an interesting feature
| that
| I would like to integrate with my work. There is no VBA (that I can
find).
| There are no images in the file/tab (again, that I can find). It is
kind
| of
| like a watermark.
|
| When viewing the spreadsheet, all of the cells are white background,
maybe
| a
| few cells of color here and there.
|
| If you zoom out of the spreadsheet to show 50% it looks like a
| spreadsheet,
| same at 30%. If you zoom out below 30%, a watermark appears on the
sheet
| with
| a name. This is totally cool. Does anyone know how to do this?
|
| Thanks and Have a Great Day.
|
| Frank Pytel
|
|
|


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default Neat Trick

Jim;

Fascinating. I can't find the original spreadsheet, but that does seem to
work. I may have to work that into my apps for named ranges.

Cool.

Thank You Very Much.

Frank Pytel

"Frank Pytel" wrote:

RagDyer;

No, I don't think I was. I might have been. It said 'talley' vertically on
the page. It was there just as plain as day. The letters of the word changed
the cell background color to gray.

I may have been in print preview, but I don't think so. Is it possible to do
this in print preview? Change the Page 1, Page 2 etc. Is this done in the
back. Is there a watermark feature to Excel?

Thanks RagDyer.

Frank Pytel

"RagDyer" wrote:

Are you perhaps in the "Page Break" view?


--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Frank Pytel" wrote in message
...
I have a spreadsheet that I found online. It has an interesting feature
that
I would like to integrate with my work. There is no VBA (that I can find).
There are no images in the file/tab (again, that I can find). It is kind
of
like a watermark.

When viewing the spreadsheet, all of the cells are white background, maybe
a
few cells of color here and there.

If you zoom out of the spreadsheet to show 50% it looks like a
spreadsheet,
same at 30%. If you zoom out below 30%, a watermark appears on the sheet
with
a name. This is totally cool. Does anyone know how to do this?

Thanks and Have a Great Day.

Frank Pytel




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
This Guy shows a SEO trick to beat Pay Per Click egfryew9 Excel Discussion (Misc queries) 0 January 17th 08 03:20 AM
Excel - Dual Monitors - A trick that works Helen Excel Discussion (Misc queries) 3 August 10th 07 07:48 PM
Sharing a neat trick MartinW Excel Discussion (Misc queries) 6 July 9th 07 12:52 AM
How to trick a Dynamic Name to be Static when SOLVER is ON... rml Excel Worksheet Functions 7 November 11th 06 02:23 PM
CountBlank for all Names in a Column, and another trick SteveC Excel Discussion (Misc queries) 2 May 25th 06 10:06 PM


All times are GMT +1. The time now is 11:34 PM.

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"