Results 1 to 25 of 35
Thread: Excel
Hybrid View
-
4th April 2011 10:44 #1
-
4th April 2011 13:57 #2
" "? - , .
AsRock B85M Pro4, Core i7-4770, Palit GTX 1660 Ti 6GB, Corsair CX750 PSU, Corsair 32GB DDR3-1600, Storages 6.1TB, Arch Cinnamon
-
4th April 2011 15:09 #3Registered 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.
-
4th April 2011 21:44 #4Registered User
Join Date: Nov:2006
Location: BG
Posts: 530
-
5th April 2011 11:20 #5
, , .. , .
: .( )
.Alt 0160 - Excel-
-
5th April 2011 17:40 #6
-
5th April 2011 18:05 #7
, . excel , hotkey.Last edited by VAISHO; 5th April 2011 at 21:09.
-
7th April 2011 10:32 #8
-
5th April 2011 11:52 #9: XaMaB; . 0.42
In God we Trust (all others must submit a X.509 certificate). , ()
-
5th April 2011 15:01 #10
-
7th April 2011 10:53 #11Registered 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 . .
-
7th April 2011 10:58 #12
-
7th April 2011 22:33 #13
, Excel Word . Excel ( .. ).
- ( Insert Symbol Fn+NmLk) , (. ""), Replace . :
* - Alt+0160Code: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 SubGIGABYTE 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
-
7th April 2011 23:49 #14
-
8th April 2011 23:49 #15GIGABYTE 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
-
9th April 2011 10:43 #16
-
13th April 2011 11:12 #17
:
, ?Last edited by jordanp; 13th April 2011 at 11:42.
-
13th April 2011 11:16 #18
-
13th April 2011 11:43 #19
-
13th April 2011 11:52 #20
-
13th April 2011 12:01 #21
-
13th April 2011 12:12 #22
-
13th April 2011 14:21 #23
-
13th April 2011 15:22 #24
-
14th April 2011 11:08 #25
:
- 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




Reply With Quote
- 
.

R9 280,
7th May 2023, 21:28 in