Categories Excel. See also:

Excel-Tips-EN

Content of this category:
MS-Excel

~~Excel~~ Addition mistakes with monetary format w ith Excel 7.0/8.0: Zusatzl. command ROUNDS (A1-2) uses
Source: PCWelt 98/05 page 278, last update 12.02.2006
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Addit00390 |forward as email

~~Excel~~ It orders of a call word to the opening of a work folder: if you produce a call word, you should write it down and at a sure place should store.
If the call word gets lost, you can neither open the call word-protected work folder, still on the data contained in it grabs.
* click you in the menu file at storages under.
* click you in the menu extras on general options.
* Inputs you in the field Lese-/Schreibkennwort a call word, and then clicks you on O.K..
* eights you on the Groß-/Kleinschreibung.
Give the call word exactly in the notation one, that later should be used, including Groß and lower-case letters.
* gives you to call word input about opening in the field repeats the call word again in one, and then clicks you on O.K..
* Click you at storages.
* click you if necessary on yes, in order to replace the existing work folder with the opened work folder.
Comment if you add a file a call word-protected work folder adds, the call word protection is canceled.
You/they become with the admittedly adds the work folder asked to the file to the input of the call word, however, the protection is canceled if the work folder turns into a section in the file.
Source: Claude's Tipps, last update 17.12.2005
Program or Website language: german
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Anfor05966 |forward as email

~~Excel~~ Auto filter with protected spreadsheet: after the password protection for a spreadsheet, the autofilter works no more. Solution only with VBA-Code:
sub blattschutz() activesheet.EnableAutoFilter= True activesheet.Protect "passwort", userinterfaceonly:=True End Sub
tested with Excel2000
Source: Claude's Tipps, last update 18.08.2005
[Original-Text = german DE] [french translation exist FR]
Systemnumber for request: Auto005833 |forward as email

~~Excel~~ Processes, declining in Excel 2000. Excel 2000 lets only 16 actions canceled. over a Registry-Eintrag, the number can be increased.' HKey_Current_User\Software\Microsoft\Office\9.0\Excel\OPtions' of new DWORD-Wert' UndoHistory' adds adds, as decimal value
Source: PCWelt 00/12 page 356, last update 15.08.2001
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Bearb02396 |forward as email

~~Excel~~ Drop-down list produces validity' over menu': step 1, list of the values produces, FOR EXAMPLE in a hidden area of the table step 2, field of marking, in which the drop-down list should appear, FOR EXAMPLE B2, step 3, menu < Daten><Gültigkeit > selects st
Source: Claude's Tipps 02/08, last update 26.08.2002
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Dropd02979 |forward as email

~~Excel~~ Excel 2000 and auto correction : problem: all entries beginning with" http" or" www" or"... @..." is altered with the auto correction of hyper link. to avoid about this, a high comma can be placed before the cell content (for example' http://abcde.fg). the
System: Win98 Win2000 WinNT
Source: PCWelt 00/04 page 263, last update 28.08.2000
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Excel01718 |forward as email

~~Excel~~ Excel 7.0: example with function ISTTEXT (, ... tests line on text or date or number
System: Win95 Win98 WinNT
Source: PCWelt 97/05 page 300, last update 07.06.1997
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Excel00044 |forward as email

~~Excel~~ Excel 97/2000: individual standard attitude store s: file as model presentation with name" Sheet" in the table \ Microsoft Office\Office\xlstart stores, they then reach this presentation over Datei/neu/sheet. tip: records as macros and a button assigns.
Source: PCWelt 00/02 page 192, last update 05.03.2000
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Excel01237 |forward as email

~~Excel~~ Excel, Office tools: Biorhythmus EPTZoomControl infinite zoomen, Viewer, calendars, passport word input field, date assistant, Speeling, grammar examination, checks X-Bar Add-in, XY Chart Labeln easier Beschriftung/Diagramme
System: Win95 WinNT
Source: PCWelt 98/11 page 131, last update 26.10.1999
On CD/DVD Software-type: fullversion
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Excel00946 |forward as email

~~Excel~~ Excel95: replaces from special charac ters: special characters doubly inputs, for example" ~ ~", also for lookups,
Source: PCWelt 99/02 page 251, last update 02.08.1999
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Excel00980 |forward as email

~~Excel~~ Excel97 (8.0): automatic storage must b e after-installed over Add-Ins of the CD.
System: Win95 Win98 WinNT
Source: Pannenhelfer 98/09 page TF111, last update 25.05.1999
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Excel00597 |forward as email

~~Excel~~ Excel97: bug with the adds from numbers between 1900 and 9999 with decimal position if is existing already in another field one of the numbers. bug fix = SR1 for Office 97
Source: PCWelt 98/07 page 13, last update 09.09.2001
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Excel00614 |forward as email

~~Excel~~ Excel-Viewer for data files of Excel95
System: Win95
Source: PCWelt 97/07 page 96, last update 02.11.1997
On CD/DVD Software-type: fullversion
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Excel00076 |forward as email

~~Excel~~ Formulas: all formulas in the table leaf (Excel97,2000) shows: with the touch-tone combination < Strg > < #> is shown the formulas in all cells. if you input the touch-tone combination again, the values appear again.
Source: PCWelt 01/06 page 280, last update 17.07.2005
Program or Website language: german
[Original-Text = german DE] [french translation exist FR]
Systemnumber for request: Forme02845 |forward as email

~~Excel~~ Released work folders in the networ k (EXCEL from 97): step by step instruction in the PC-MAGAZIN
Source: PCWelt 01/12 page 328, last update 07.09.2002
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Freig03011 |forward as email

~~Excel~~ Gif-Grafiken insert: GIFIMP 32.FLT from Office 97-CD
System: Win95 WinNT
Source: PCWelt 98/02 page 242, last update 02.05.1998
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Gif0G00332 |forward as email

~~Excel~~ Border awls, indexes, interpretations with Excel (from Excel 97), different ideas to the accentuates from limiting value numbers: traffic lights,...
Source: Redmond's Inside 00/02 page 501, last update 31.05.2000
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Grenz01462 |forward as email

~~Excel~~ CALENDAR WEEK: this function delivers the week number. however, the statement is not right in agreement, (caution), with the DIN1355
Source: PCWelt 98/05 page 92, last update 30.08.1998
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: KALEN00439 |forward as email

~~Excel~~ KGRÖSSTE: this function delivers B2 the K-grössten value of a data series (FB KGRÖSSTER); Q2; 2 = 2.-biggest. co = sum (Kgrösster) B2; Q2; 1,; KGRÖSSTER, B2; Q2; 2, the 2 pointed values of a data series are added.
System: Win95 WinNT
Source: PCWelt 98/06 page 24415, last update 30.08.1998
Software-type: fullversion
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: KGR0S00432 |forward as email

~~Excel~~ Commentaries (Excel 97/ 2000) format: commentaries has formatted itself like normal text fields!
System: Win95 Win98 Win2000 WinNT
Source: PCWelt 00/06 page 254, last update 01.06.2000
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Komme01465 |forward as email

~~Excel~~ Commentaries: grabs Excel-Commentaries and show the commentary at other place. The function with the call, for example, =Kommentar(Tabelle1!A3):
Public Function Kommentar(Bezug As Range) As String Kommentar = Bezug.Comment.Text End Function
Source: Internet, last update 09.12.2005
[Original-Text = german DE] [french translation exist FR]
Systemnumber for request: Komme05958 |forward as email

~~Excel~~ Pictures in Excel-commentaries, (EXCEL 97-2003), shows a little known possibility to show pictures in the commentary field:
--commentary aims.
--rights Maustaste, with it exactly on the marked edge clicks.
--' Commentary formats' selects
--sub' color and lines' picks you color
--then' filling effects',' graphics, graphics selects' It unlike graphics format is admitted.
Source: PCWelt 06/11 page 193, last update 23.10.2007
Program or Website language: german
[Original-Text = german DE] [french translation exist FR]
Systemnumber for request: Komme07589 |forward as email

~~Excel~~ Commentaries: texts in commentaries (1) changes: simple macros, is valid only for cell A1 and the content of the cell is deleted:
Sub Test() Dim Kommentar$ Cells(1, 1).Select Kommentar = Cells(1, 1).text Selection.ClearContents Cells(1, 1).ClearComments Cells(1, 1).AddComment.text Kommentar End Sub
With a loop you could write the cell content from other cells in the commentary field one.
Source: Internet, last update 09.12.2005
Program or Website language: german
[Original-Text = german DE] [french translation exist FR]
Systemnumber for request: Komme05954 |forward as email

~~Excel~~ Commentaries: texts in commentaries (2) changes: Sub Makro1() ActiveCell.AddComment ActiveCell.Comment.Visible = False ActiveCell.Comment.Text Text:=ActiveCell & Chr(10) & "" ActiveCell.Select ActiveWindow.SmallScroll Down:=-9 End Sub
Source: Internet, last update 09.12.2005
[Original-Text = german DE] [french translation exist FR]
Systemnumber for request: Komme05955 |forward as email

~~Excel~~ Model presentations for folders and tables: in the steward XLSTART, MAPPE.XCT and TABELLE.XLT
Source: PCWelt 98/04 page 339, last update 06.11.1998
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Muste00479 |forward as email

~~Excel~~ pcwBreaker.bas from PC-Welt. these macros deactivates the password protection of an Excel-Mappe. for Excel 2000 and XP
Source: PCWelt 04/05 page 234, last update 24.10.2004
On CD/DVD Software-type: Freeware
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: pcwBr05509 |forward as email

~~Excel~~ Per touch-tone combination (all versions) jumps. goal: if a certain cell is marked, one should jump with a touch-tone combination into another table. a work (filling of an Excelliste) should enable this without mouse. example:
* * Code start * * Public Sub SKUeb_Berechnen (,' * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Select Case ActiveSheet.Name Case" Tabelle1" Select Case ActiveCell.Address Case" $B$9": Worksheets (" Berech. B1". Activate:
Worksheets (" Tabelle10". Cells(9 4. Select Case" $B$10": Worksheets (" Berech. B1". Activate: Worksheets (" Tabelle10". Cells(19 4.
Select End of Select End Select End sub * * code end * * this routine another touch-tone combination assigns., extra, macros, macros (options)
Source: Claude's Tipps 09/10, last update 04.10.2009
[Original-Text = german DE] [french translation exist FR]
Systemnumber for request: Per0T08753 |forward as email

~~Excel~~ Problem: connections updates, although non e exist in the spreadsheet. solution: inclusion names fixes, corresponding entries delete
Source: Claude's Tipps 98/04 page --, last update 09.09.2001
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Probl00284 |forward as email

~~Excel~~ Rounds with function OBERGRENZE , for example 13,76 on 13,75: = HEAD BORDER, A1-0,025; 0,05, 13,76 on 13,80: = HEAD BORDER, A1-0,05; 0,01, 13,76 on 15,00: = HEAD BORDER, A1-2,5; 5,
Source: PCWelt 97/12 page 370, last update 16.08.1998
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Runde00373 |forward as email

~~Excel~~ Side numbers with offset: if your printout should begin with side 20you input following in the head or footer: & [Seite]+19 important to it that exists before and after 2 blank characters each is.
1 blank characters each function as invisible clamp.
Source: Claude's Tipps 07/09, last update 27.10.2008
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Seite07802 |forward as email

~~Excel~~ Table data departure : in Excel area copies on desktop with right mouse click, context" inserts". this entry or table area per Drag And Drop into another application or Excel-sheet insert, goes also with WORD,
System: Win95
Source: PCWelt 98/05 page 90, last update 10.05.2000
Software-type: fullversion
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Tabel00438 |forward as email

~~Excel~~ Values joined worth through static replaces: if a part of an Excel folder will pass on, there is the problem on occasion, that values won't show, since these connections are to the rest of the folder. solution:
* Marks you the area of the connections contains * [Strg][C] (copying) * menu" of processing, contents insert" *" values" selects * [OK] instead of the connections is statically the values in the Excel-sheet contained now.
Source: Claude's Tipps 09/10, last update 04.10.2009
[Original-Text = german DE] [french translation exist FR]
Systemnumber for request: Verkn08754 |forward as email

~~Excel~~ Cells size: number of the signs in a cell is restricted on 255 signs, in commentaries, however, 4096 signs are possible
Source: Internet, last update 09.12.2005
[Original-Text = german DE] [french translation exist FR]
Systemnumber for request: Zelle05956 |forward as email

~~Excel~~ Cells with certain background colors add up, 2 mod ules to the types out in the PC-MAGAZIN
Source: PCWelt 97/10 page 341, last update 29.01.1998
[Original-Text = german DE] [french translation exist FR] [this Text is translated with a programm]
Systemnumber for request: Zelle00243 |forward as email

Other entries in other categories:
Passwort: Accent EXCEL Password Recovery:
Datenbank_Access: Access in Office 97:
Datenbank_Access: DDE from Access:
Datenbank_Access:
Datenbank_Access: Excel: data of Access transfers, (AC 97-
Datenbank_Access: Excel: bind tables
Datenbank_Access:
Datenbank_Access: Excel-Daten more effectively (AC97-
Datenbank_Access: Excel-Export without data record limitation
Datenbank_Access: Excel-Tabellen (AC97-2002
Datenbank_Access:
Datenbank_Access: Teamwork with Excel and Access
ProgrammSprache: VBA for Excel more simply learns, Tutorial of Hans W.Herber,
Datenbank_Access: VBA-Bibliothek: Excel-Export-Dialog for users: (AC97-20
Datenbank_Access: Pays export after Excel:,

Claude's PC-Tipps (Home) load ... if this page was loaded alone.