Searching Excel

[rich 36]

How can Excel easilly be searched,

I need to find a duplicate Four digit number.

Does excel actually have its own
'Find'

Or where might I direct desktop search on a work networked PC?

[Jinx]

Ctrl + F not good enough?

[rich 36]

Is a.detailed search available,
The same four digits are likely used monthly,
Ctrl f only appaarently reveals this months though

Can it search by date in some way

[tigger1]

Ctrl+f lets you search the current worksheeet of the open workbook.

Are you *sure* that the figure appears again??

[flossythepig]

The Find popup keeps on searching by starting the next search from its current position. If "1234" appears three times Find Next finds the first followed by the second followed by the third followed by the first - and so.

Another option if the numbers appear in the same column is to turn on "AutoFilter" and filter by the number

[rich 36]

Autofilter????

[Piglet]

Sometimes the key to searching excel is to click on the "corner" cell (between A and 1) to ensure that the whole of the spreadsheet is selected.

I can't count how many times I've searched for data that I KNOW is there but it's only searching one one cell not the entire sheet!

[Jinx]

Hold down shift - select all of you sheet tabs i.e. group the sheets - select all (ctrl + a) use find (ctrl + f) and either find all (big list of occurances) or go to "next" one at a time. You can use the wild cards _ (for a single character variable) or * for (multi-character variables)

[rich 36]

Ta for advice all,

Now.

How do I create something I can hold a handful of handy numbers
always in my line of sight regardless of my position on the worksheet

I've seen what looks like Excels' own version of a 'sticky note'

but don't know how its created, or edited!

[Raify]

Why don't you put the useful numbers at the top and then either freeze pane or split the window so they're always visible? Both in the Window menu.

[rich 36]

The one I saw
was about the size of a couple of stamps,
pale yellow, and could be dragged back and forth across the worksheet,
I was wondering if anyone knew it,

but i'll look at FREEZE in the morning
cheers

[nickd01]

I thin you mean a "Comment" in Excel.

Right click on a cell and hit "Add Comment" These can be dragged around at will.

[rich 36]

what any cell at all,

I havn't got Excel at home please explain

[nickd01]

Yep, any cell. The comment "attaches" itself to the cell so when you're on it then it's shown.

But, once you've added a comment you can then right click on the cell again and select "Show/Hide Comment" to permanently have it on view.

[rich 36]

nickd01 said:

Yep, any cell. The comment "attaches" itself to the cell so when you're on it then it's shown.

But, once you've added a comment you can then right click on the cell again and select "Show/Hide Comment" to permanently have it on view.

[Miles_stylus]

Alternativly copy and paste link from a cell into a text box - this allows the "handy numbers" to be dynamic