Page 1 of 2 12 LastLast
Results 1 to 25 of 35

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User jordanp's Avatar
    Join Date: Sep:2008
    Location: Greece
    Posts: 95

    Excel

    ? ctrl+shift+space ( Word) .

  2. #2
    Hardcore atheist rado84's Avatar
    Join Date: Jan:2007
    Location:
    Posts: 938
    " "? - , .
    AsRock B85M Pro4, Core i7-4770, Palit GTX 1660 Ti 6GB, Corsair CX750 PSU, Corsair 32GB DDR3-1600, Storages 6.1TB, Arch Cinnamon

  3. #3
    Registered User
    Join Date: May:2005
    Location:
    Posts: 933
    google CHAR(160) , .


    , " " = No-break space

    No-break space. This character, accessed in Word via Ctrl-Shift-Space, looks like a space but is treated as a normal "letter". A word that contains a no-break space wont be split over the end of a line, e.g. "Dr Blob" will stay together without "Dr" being at the end of one line and "Blob" at the start of another. Useful for titles, dates (e.g. "7 June 1997") or numbers with spaces in them (e.g. "R 2 000.00"). The other useful property of the no-break space is that it will retain the same width in a justified paragraph, so if you have to use spaces to align text (e.g. within a column in a table) then the no-break space is the thing to use.

  4. #4
    Registered User
    Join Date: Nov:2006
    Location: BG
    Posts: 530
    Quote Originally Posted by Miro85 View Post
    google CHAR(160) , .
    - Alt 0160 - Excel-
    "" -
    , ...

  5. #5
    Registered User jordanp's Avatar
    Join Date: Sep:2008
    Location: Greece
    Posts: 95
    , , .. , .
    : .( )


    Alt 0160 - Excel-
    .

  6. #6
    Registered User G@nius's Avatar
    Join Date: Feb:2010
    Location: Noob corner
    Posts: 137
    Quote Originally Posted by jordanp View Post
    , , .. , .
    : .( )



    .
    , , , ( )?
    Excel 2007 .
    GIGABYTE 890GPA-UD3H | AMD Phenom II X4 925 2.8GHz / CM HYPER TX3 | 2 x 2GB SUPER TALENT DDR III 1333 CL9 | Sapphire HD5770 Vapor-X 1GB GDDR5 | WD 500GB SATA II Black | CM GX 650W | LG W2361V-PF, 23", 1920x1080 | Windows 7 Ultimate x64

  7. #7
    Registered User VAISHO's Avatar
    Join Date: Jun:2006
    Location:
    Posts: 163


    , . excel , hotkey.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Nonbreaking Space.png‎ 
Views:	330 
Size:	72.0 KB 
ID:	38272  
    Last edited by VAISHO; 5th April 2011 at 21:09.

  8. #8
    Registered User jordanp's Avatar
    Join Date: Sep:2008
    Location: Greece
    Posts: 95
    Quote Originally Posted by G@nius View Post
    , , , ( )?
    Excel 2007 .
    , .
    insert/symbol , , .
    word customize.

  9. #9
    XaMaB's Avatar
    Join Date: Nov:2001
    Location:
    Posts: 20,392
    : XaMaB; . 0.42

    In God we Trust (all others must submit a X.509 certificate). , ()

  10. #10
    Registered User jordanp's Avatar
    Join Date: Sep:2008
    Location: Greece
    Posts: 95
    Quote Originally Posted by XaMaB View Post
    .

  11. #11
    Registered User
    Join Date: May:2005
    Location:
    Posts: 933
    2 :
    1. Fn + "" : 7, 8, 9, U, I, O, J, I, K, L, M. , .

    2. 15 USB . .

  12. #12
    Registered User PepiX's Avatar
    Join Date: Sep:2004
    Location:
    Posts: 13,376
    AutoHotKey ( ) Ctrl+Shift+Space . ( , ..)
    ███████ ( Ilko)
    ███████-, ? ( )
    ███████

  13. #13
    Registered User G@nius's Avatar
    Join Date: Feb:2010
    Location: Noob corner
    Posts: 137
    , Excel Word . Excel ( .. ).

    - ( Insert Symbol Fn+NmLk) , (. ""), Replace . :

    Code:
    Sub Nonbreaking_space()
    '
    ' Nonbreaking_space Macro
    '
    ' Keyboard Shortcut: Ctrl+s
    '
        Cells.Replace What:="", Replacement:="*", LookAt:=xlPart, SearchOrder _
            :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
    End Sub
    * - Alt+0160
    GIGABYTE 890GPA-UD3H | AMD Phenom II X4 925 2.8GHz / CM HYPER TX3 | 2 x 2GB SUPER TALENT DDR III 1333 CL9 | Sapphire HD5770 Vapor-X 1GB GDDR5 | WD 500GB SATA II Black | CM GX 650W | LG W2361V-PF, 23", 1920x1080 | Windows 7 Ultimate x64

  14. #14
    Registered User PepiX's Avatar
    Join Date: Sep:2004
    Location:
    Posts: 13,376
    Quote Originally Posted by G@nius View Post
    , Excel Word . Excel ( .. ).
    Windows, .. .. .
    ███████ ( Ilko)
    ███████-, ? ( )
    ███████

  15. #15
    Registered User G@nius's Avatar
    Join Date: Feb:2010
    Location: Noob corner
    Posts: 137
    Quote Originally Posted by PepiX View Post
    Windows, .. .. .
    Quote Originally Posted by PepiX View Post
    AutoHotKey ( ) Ctrl+Shift+Space . ( , ..)
    .


    Code:
    ^+space::SendInput {Alt Down}{Numpad0}{Numpad1}{Numpad6}{Numpad0}{Alt Up}
    . .
    , "", .
    GIGABYTE 890GPA-UD3H | AMD Phenom II X4 925 2.8GHz / CM HYPER TX3 | 2 x 2GB SUPER TALENT DDR III 1333 CL9 | Sapphire HD5770 Vapor-X 1GB GDDR5 | WD 500GB SATA II Black | CM GX 650W | LG W2361V-PF, 23", 1920x1080 | Windows 7 Ultimate x64

  16. #16
    Registered User PepiX's Avatar
    Join Date: Sep:2004
    Location:
    Posts: 13,376
    Quote Originally Posted by G@nius View Post
    , "", .
    EXE
    ███████ ( Ilko)
    ███████-, ? ( )
    ███████

  17. #17
    Registered User jordanp's Avatar
    Join Date: Sep:2008
    Location: Greece
    Posts: 95
    :
    , ?
    Last edited by jordanp; 13th April 2011 at 11:42.

  18. #18
    Registered User PepiX's Avatar
    Join Date: Sep:2004
    Location:
    Posts: 13,376
    - , Autohotkey..?
    ███████ ( Ilko)
    ███████-, ? ( )
    ███████

  19. #19
    Registered User jordanp's Avatar
    Join Date: Sep:2008
    Location: Greece
    Posts: 95
    " Excel", , . , .

  20. #20
    Registered User PepiX's Avatar
    Join Date: Sep:2004
    Location:
    Posts: 13,376
    ..

    Alt+F11 VB . . ( Insert/Module VB )

    ( , .. - .. .)
    ███████ ( Ilko)
    ███████-, ? ( )
    ███████

  21. #21
    Registered User jordanp's Avatar
    Join Date: Sep:2008
    Location: Greece
    Posts: 95
    ?

  22. #22
    Registered User PepiX's Avatar
    Join Date: Sep:2004
    Location:
    Posts: 13,376
    , :

    -
    - toolbar- customize
    - Commands
    - -- Macros
    - Custom Button ( ..)
    - Change Button Image
    - Assign Macro

    .
    ███████ ( Ilko)
    ███████-, ? ( )
    ███████

  23. #23
    Registered User jordanp's Avatar
    Join Date: Sep:2008
    Location: Greece
    Posts: 95


    ---------- 14:21 ---------- 13:15 ----------

    Quote Originally Posted by PepiX View Post
    ..

    Alt+F11 VB . . ( Insert/Module VB )

    ( , .. - .. .)
    , , "Cannot edit a macro on a hidden workbook. "Unhide the workbook using the Unhide command", ?

  24. #24
    Registered User PepiX's Avatar
    Join Date: Sep:2004
    Location:
    Posts: 13,376
    Quote Originally Posted by jordanp View Post
    .
    ███████ ( Ilko)
    ███████-, ? ( )
    ███████

  25. #25
    Registered User jordanp's Avatar
    Join Date: Sep:2008
    Location: Greece
    Posts: 95
    :



    - VB , ALT+F11
    - VBA Project, module1, module2 ... .
    - () export file import file
    - . bas, ,
    - , , "XLSTART", C:\Documents and Settings\User\Application Data\Microsoft\Excel\XLSTART .

    "Unhide the workbook using the Unhide command"
    Window/View>Unhide

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |