Office Guru


A blogban használt címkék: & OPERATOR .Files.Count .FormulaHidden .LEFT .Locked .TOP .vbs /resetnavpane 1900 date system 1904 date system 2-D line 3-D FORMAT 3-D ROTATION 400 ERROR A1 ABS ACCESS Action Settings Action with objects ACTIVE-X CONTROLS ActiveCell ACTIVECELL ActiveChart ACTIVECHART ActiveChart.SeriesCollection(1).Points.Count ActiveDocument.Close ActiveDocument.SaveAs ACTIVESHEET ActiveSheet ActiveSheet.Cells ActiveSheet.Shapes.Range Activesheet.Shapes.Range ActiveSheet.TextBoxes ACTIVEWINDOW.VISIBLERANGE ActiveWorkbook Activeworkbook.SaveAs ActiveWorkbook.Sheets ActiveWorkbook.Worksheets ADD-INS ADDRESS ADD TO SELECTION adLockReadOnly ADODB.CONNECTION ADODB.RECORDSET adOpenStatic AGGREGATE Allow this information to be saved in your file All except borders All merging conditional formats ANCHOR AND ANIMATION Animations Animation Delay Animation Pane app.xml Application.ActiveSheet.Range Application.Calculate Application.Calculation Application.CommandBars("Cell") Application.CutCopyMode Application.EnableEvents Application.GetOpenFilename Application.MacroOptions APPLICATION.ONTIME Application.Quit Application.Run Application.ScreenUpdating APPLICATION.TRANSPOSE Application.Undo Application.Volatile Application.Wait Application.WorksheetFunction Apply Names APPS BAR Area Chart Array formula ASCENDING SORT ASCII Aspect Ratio As shown when printed ATTACHMENT AUTOCORRECT AutoCorrect AUTOFILL AUTOFILTERMODE Automatic Calculation Autosave AVERAGE AVERAGEIF AVERAGEIFS AXIS OPTIONS Axis Options B1 BACKGROUND REMOVAL BAHTTEXT BARCODE BARS BAR CHART BeforeDoubleClick Billentyűkombinációk Binary BINARY SEARCH BOOKMARK Boolean BOOLEAN Border Bridge Chart BUG BuiltInDocumentProperties Burn down chart ByVal ByVal hwnd ByVal Target as Range CALCULATE CalculateBeforeSave Calculated Column Calculated Field CALCULATED FIELD Calculation Options CALENDAR CALENDAR CONTROL CALL CAMERA CAMERA TOOL Cancel Caption cButtons CELL CellColor CELLS CELLS() CELLS(ROW and COLUMN) CELLS.FIND Cells.Value CELL FORMAT CELL TYPE CHANGE DATA SOURCE CHANGE VIEW Changing Sheet name CHAR CHARFORMAT CHART Chart ChartObjects ChartObjects.Count CHARTS Charts ChDrive CHOOSE CHR Christmas Chrome CIRCULAR REFERENCE ClearClipBoard ClearContents Clear All CLEAR FORMATS Click here to view more on Microsoft Exchange Clipboard CLOCK Close Clustered Bar Clustered Column CmD CMD Collapse COLUMN COLUMNS.COUNT COLUMN CHART COLUMN NUMBER Combining Diacritical Marks Combining Overline CommandBar CommandButton.BackColor CommandButton.Enabled Command Button COMMENTS IN WORD Compact Navigation Compare COM ADD-INS CONCAT CONCATENATE Conditional Formatting Connect data points with line Consolidate Const CONST CONTENT.SELECT Content Types.xml Controls.Add Convert CONVERT TO TEXT Copy CopyFile CopyFromRecordset Copy as Picture COPY PASTE core.xml COUNT COUNTA CountA COUNTIF COUNTIFS Co Authoring CreateItem CreateItem(olMailItem) CreateObject CREATEOBJECT CreateObject("Excel.Application") CreateObject("Outlook.Application") CreateObject("Scripting.FileSystemObject") CreateObject("WScript.Network") Crop CROSS-REFERENCE CROSS-SHEETS FORMULAS CTLR+V CTLR SHIFT ENTER CTRL+C CTRL+J CTRL+SHIFT+ENTER Custom Customize CUSTOM AUTOFILTER Custom Data Validation Custom dic CUSTOM ICONS Custom number format CUSTOM NUMBER FORMAT Custom Path CUSTOM UDF Custom UI Editor Custom Views Dashboard DASHBOARD DATA Database Data Model DATA VALIDATION DATA VALIDATION LIST DATE DATEDIF Datedif Date and Time DATE AXIS Declare DECLINE A MEETING DEFAULT COUNT Default Reminder Time DEFAULT SUM Define a name Define More Criteria DELEGATE DELETE MARK DELETE SEGMENT DELIMITERS Delta DEPENDENT DROPDOWNS DESIGN DEVELOPER Dia Diagram DIAGRAM DIM Dim DisplayAlerts dll Do...Loop docProps Document.Write document.xml Documents.Open Document Inspect Document Inspection DOCUMENT LOCATION DOCUMENT MAP DOCUMENT PROPERTY Document Specific Settings docx docx to zip Do Until DRAG AND DROP Drawing DRAWING TOOLS DSUM dwExtraInfo dwFlags DYNAMIC PIVOT RANGE Dynamic Range E-mail E-MAIL E-MAIL SENDING Editing EDIT INTERACTIONS EDIT MESSAGE EDIT POINTS EDIT SHAPE Egyéb EGYÉB ELBOW CONNECTOR ELSE EMAIL embeddings EMBEDDINGS Emoticon Emphasis ENCODEURL END End End(xlUp).Row END IF End If End Sub EntireRow.Delete Entrance EQ Error.type Errorcatch Errortrap ERROR 400 Error Alert EVALUATE EXCEL Excel EXCEL 2013 Excel Custom Ribbon Excel Custom Tab Excel Options Excel Ribbon Excel to PowerPoint EXIT SUB Export all customizations EXTENDED RANGE EXTEND SELECTION F4 F8 Facebook Fade Fading map FALSE FEJTÖRŐ FIELDS Field Codes FIELD LIST File.Name File.Path FileExists FileLen FileName FILESYSTEMOBJECT Fill FILL Fill.Forecolor.RGB Fill Left Fill Right FILTER Filter FILTERXML FILTER FOR LENGTH FIND Finding the neccessary sum from numbers FLAG STATUS FLASH FILL fmMousePointer Focus Focus on city Footer Footnote Footprints FOR...EACH FOR...NEXT Forecolor.ObjectThemeColor Forecolor.RGB Forgotten functions FORMAT Format(Now) FORMAT AXIS Format Cells FORMAT CELLS Format Cells Number FORMAT DATA SERIES Format Data Series Format only top or bottom ranked values FORMAT PAINTER FORMAT SHAPE FORMAT SHAPES Forms.TextBox Formula FORMULA Formulas FORMULATEXT FORMULA BAR FOR EACH NEXT FOR NEXT Fragment FreeFile FREEZE FREEZE PANES Free Writing FREQUENCY FRIENDLY NAME From Other Sources From Table/Range From Web FSO.GetFolder FUNCTION Function GANTT GANTT-CHART GAP WIDTH GESTEP Get GETFOLDER Get and Transform Get External Data GET EXTERNAL DATA Glass ball Gondolkodjunk! Google Chrome GRADIENT FILL GRIDLINES Group GROUP Grouping by Days Grow/Shrink Handwriting Harvey Balls Header Headings Heading 1 Heading 2 Heading 3 Height HEIGHT Hidden Hidden Text HIDE Horizontal HTML hwnd HYPERLINK HYPERLINKS.ADD Icon Style IDEAS Idegesítő funkciók Excelben IEEE IEEE floating point IF If IF...END IF IFERROR Illustrations ILLUSTRATIONS Immediate Window Import customization file INCLUDETEXT FIELD Incorrect calculation IncrementLeft INDEX INDIRECT Indirect Info INFOGRAFIKA InfoPath InfoPath Submit Button Insert INSERT InsertFile INSERT BAR CHART Insert Caption INSERT CUT CELLS INSERT MERGE FIELD INSERT SHAPES Insert Shapes INSTR INT INTEGER Integer INTERESTING FACTS INTERESTING STUFF Interior.ColorIndex INTERIOR.COLORINDEX InternetExplorer.Application Intersect Intersect(Target IN CELL CHART ISBLANK ISDATE ISERROR ISNA ISNUM ISNUMBER ITERATION JoyPlot Karácsony Keep Text Only Keyboard Shortcuts Kirakós Label Label BackTyle Label Caption Lábnyomok LARGE LAST() Last Save Time LBOUND LCase LEFT Left Outer Join Legend Entries LEN Lib LINEAR REGRESSION LINEAR SEARCH LINE BREAK Link LINKED CELL ListBox ListBox.AddItem Listbox.List ListBox.ListCount LISTOBJECTS Load To Locked Long LOOKUP Lorem Ipsum LOTUS Macro MAILINGS MAKRÓ MANAGE APPS Manual calculation MARK AREAS TO KEEP MARK AREAS TO REMOVE MATCH MAX ME media MERGEBARCODE MERGEFORMAT MERGE & CENTER Merge Columns Merge Queries Merge Shapes metadata Microsoft.ACE.OLEDB.12.0 Microsoft Exchange Server MICROSOFT QUERY Microsoft Web Browser MID milyenferi. MIN Mod MOD MODE MODE.MULT MODE.SNGL More Controls More Motion Paths MOUSEEVENTF LEFTDOWN MOUSEEVENTF LEFTUP MOUSEEVENTF WHEEL MouseIcon MouseMove MousePointer Mouse Click mouse event MSGBOX MsgBox msoControlButton msoControlButton ID NA() Name Box Name Manager NAME MANAGER Navigate Navigation options New Column New Formatting Rule - Use a formula New Rule Normal template in WORD NOT NOW Now No Border No Line NUMBER Number Format Object Office Guru OFFSET OLEObject OLEObjects OLEObjects.Verb ONENOTE ONENOTE TIPS Only Create Connection OnSlideShowPageChange ON ERROR GOTO On Error Resume Next ON ERROR RESUME NEXT Open Open For Append As Open For Binary As Open For Output As OPERATOR OptionButton OptionButton Click OR Orientation OUTLOOK Outlook OUTLOOK.APPLICATION Outlook.Application OUTLOOK 2013 Outlook 2016 OUTLOOK OPTIONS Out of office OVAL Page Break Page Layout Page Numbering Password Paste Paste Formats Paste Special PDF PERCENTAGE PICK UP WHERE YOU LEFT OFF PICTURE LAYOUT Picture Tools Pie Chart Pie of Pie Pivot PIVOT PIVOT-TÁBLA PIVOT TABLE PowerBI PowerPivot Powerpoint POWERPOINT PowerPoint Powerpoint.Application POWERPOINT VBA PowerQuery POWER BI Power BI Power BI Desktop Precision as displayed PRESENTATION Presentation.Slides.Add Presentations Presentations.Add Preserve cell formatting on update Prezentáció Primszam Print PrintScreen Private Private Appointment ProgID Property Sheet Protect Sheet Protect Workbook Public QAT Queries and Connections Query Editor QUERY WIZARD QUICK ACCESS TOOLBAR Quick Analysis QUICK PARTS QUICK PRINT R1C1 RAND RAND() RAND.OLD() RANDARRAY RANDBETWEEN RANDOMIZE Range RANGE Range.Collapse RANGE.FIND Range.InsertFile RANGE.RESIZE RANK RANK.AVG RANK.EQ READING LOCATIONS Recurrence REFRESH Refresh REGEDIT RELATED REMOVE BACKGROUND Remove personal information REPEATED TASK GANTT REPLACE Replace Replace text as you type Report Layout REPT RESET VIEW RESIZE Return Data to Microsoft Excel RGB RIBBON Ribbon Customization RIGHT RND Robocopy ROMAN ROUND Rounded Bar Chart Rounded Column Chart ROUNDED RECTANGLE ROUTE ROW ROWS ROWS.COUNT Rows.Count Row Labels ROW NUMBER SAVE AS OTHER FORMAT SCATTER Scatter SCRIPTING.FILESYSTEMOBJECT Scripting.Folder Search SEARCH SECONDARY AXIS Segoe UI Symbol Font SELECT Select..Case Selection SELECTION.CELLS(1).VALUE SELECTION.CLEAR SELECTION.COPY Selection.Find Selection.Find.Replacement.Text Selection.Find.Text SELECTION.MERGE SELECTION.WRAPTEXT Select Data Select locked cells Select text with similar formatting SEND TO BACK SEND TO MAIL RECIPIENT Send to Microsoft PowerPoint Sensitivity SEQUENCE SERIES Series SeriesCollection(1) SERIES OVERLAP Set set SET SetCursorPos Set precision as displayed Shapes SHAPES Shapes.Count Shapes.PasteSpecial Shape Fill SHAPE FILL SHAPE OUTLINE SHAPE STYLES Share Shared Calendar Sharepoint SharePoint Sharepoint Lists Share Workbook Share Workbook (Legacy) Sheet SHEETS Sheets Sheets.Add SheetSelectionChange Sheet Merge Shell SHIFT F8 Shockwave Flash Object SHORT SHORT&FILTER Shortcut SHOW Show As Show Report Filter Pages Simplex LP SINGLE Size Slicer SLICER SLICER SETTINGS Slide Slides.Add SlideShowWindow SLIDE EXAMPLES SMALL Smiley Snipping Tool SOLVER Sort SORT SORTBY SORT AS NUMBER Sort Largest to Smallest Space SpecialCells Speedometer SPELLING SPIKE Spill Range Spill Reference Spin Button Split Column SQL SQL IN SQL Statement SQRTPI Stacked Bar STACKED BAR Stacked Column START MAIL MERGE START UP OPTIONS Step 2 STICKY NOTES STRING String Sub SUB SUBADDRESS SUBJECT POPUP SUBSTITUTE SUBTOTAL Subtraction SUM SUMIF SUMPRODUCT Symbol Symbols Table TABLE Target.Address Target.Columnb Target.Offset Target.PivotField Target.Validation.Type Target.Value Task List Teardrop TEXT TEXTBOX TextBox TEXTJOIN TEXTTODISPLAY Text Format TEXT TO COLUMNS Thermometer ThisWorkbook. ThisWorkbook.FollowHyperlink TIME TIMESERIAL TIMEVALUE TIME AND DATE PICKER Tippek Tips Title TO-DO BAR TODAY Toggle Field Codes Tömbfüggvény Tömbképlet Toolbar TopLeftCell TOUCH/MOUSE MODE Transpose TRENDLINE TRIM TRIMMEAN TRUE TYPE TYPEEXTRA UBOUND UDF Undo UNHIDE Union UNIQUE Unprotect Sheet UNREAD MESSAGES Unshare Unshare Workbook UPPER Urbanista Business Punk UsedRange user32 userform UserForm UserInterFaceOnly USE AN EXISTING LIST ÚT Üveggolyó VALUE Value Value Filters Variant VBA VBA editor vbOKOnly VBScript VERB Verseny Vertical Alignment VERY HIDDEN View.CurrentShowPosition View on Server VIEW SETTINGS VISIBLE VISIBLE PROPERTY Visio Visualizations VISUALS VLOOKUP Vonaldiagram Waterfall Chart wdCollapseEnd wdReplaceAll WebBrowser WebBrowser.Refresh WEBSERVICE WEEKNUM Wheel WIDTH Windows WITH With WITH END WITH WITH SELECTION Word word WORD Word.Application WORD 2007 WORD 2013 WORKSHEET WORKSHEETFUNCTION.AVERAGE WORKSHEETFUNCTION.SUM WORKSHEETFUNCTION.TRIMMEAN Worksheets Worksheets.count WORKSHEETS.COUNT Worksheets.Range.Value Worksheet BeforeDoubleClick Worksheet change Worksheet Change WORKSHEET SELECTIONCHANGE WORK OFFLINE xlAutomatic xlCellTypeVisible xlManual xlPrevious xlROWS XLSB xlSemiautomatic xlSheetHidden xlSheetVisible XLSX xlValues XML XOR XPATH XValues YouTube Zigzag ZOOM rels
süti beállítások módosítása