Thanks for feeding back - glad it worked for you.
To disable the reduced menu feature, click on Tools | Customise |
Options and uncheck the option "Menus show recently used commands
first", then click Close.
Hope this helps.
Pete
On Sep 10, 10:48 pm, Astroboy <Astro...@discussions.microsoft.com>
wrote:
> Oh... Great and it works....!!1
>
> Thanks......
>
> P.S. do you know how to Disable the AUTO COLLAPSE on Menu (ex. On Edit,
> File,.. Etc) ?
>
>
>
> "Pete_UK" wrote:
> > Instead of doing <copy>, move to other sheet, <paste>, do <copy>, move
> > to other sheet, then Edit | Paste Special | Values (check) | OK then
> > <Esc>.
>
> > Hope this helps.
>
> > Pete
>
> > On Sep 10, 9:10 pm, Astroboy <Astro...@discussions.microsoft.com>
> > wrote:
> > > Hello all,
>
> > > In Worksheet #1
>
> > > -------A----------B--------------------------------------------------------*----C--D--E
> > > 1--- Text1------Data output 1 (from If function) Ex. 85
> > > 2--- Text2------Data output 2 (from If function) Ex. 90
> > > --
> > > --
> > > 20-- Text20-----Data output 20 (from If function) Ex. 150
>
> > > And when I copy from A1 to B20 and Paste on New worksheet, it only shows 0
> > > on B row
>
> > > How can I copy only Data output and paste on new worksheet without copying
> > > whole worksheet?
>
> > > Thank you- Hide quoted text -
>
> - Show quoted text -
Similar Threads
