Sunday 22 December 2013

List of methods (function) of a cell

List of methods (function) of a cell, a block of cells (they are having same methods):
1. Activate
2. AddComment
3. AdvancedFilter
4. ApplyNames
5. ApplyOutlineStyles
6. AutoComplete
7. AutoFill
8. AutoFilter
9. AutoFit
10. AutoOutline
11. BorderAround
12. Calculate
13. CalculateRowMajorOrder
14. CheckSpelling
15. Clear
16. ClearComments
17. ClearContents
18. ClearFormats
19. ClearNotes
20. ClearOutline
21. ColumnDifferences
22. Consolidate
23. Copy
24. CopyFromRecordSet
25. CopyPicture
26. CreateNames
27. Cut
28. DataSeries
29. Delete
30. DialogBox
31. Dirty
32. EditionOptions
33. ExportAsFixedFormat
34. FillDown
35. FillLeft
36. FillRight
37. FillUp
38. Find
39. FindNext
40. FindPrevious
41. FunctionWizard
42. Group
43. Insert
44. InsertIndent
45. Justify
46. ListNames
47. Merge
48. NavigateArrow
49. NoteText
50. Parse
51. PasteSpecial
52. PrintOut
53. PrintPreview
54. RemoveDuplicates
55. RemoveSubtotals
56. Replace
57. RowDifferences
58. Run
59. Select
60. SetPhonetic
61. Show
62. ShowDependents
63. ShowErrors
64. ShowPrecedents
65. Sort
66. SortSpecial
67. Speak
68. SpecialCells
69. SubscribeTo
70. SubTotal
71. Table
72. TextToColumns
73. Ungroup
74. Unmerge

No comments:

Post a Comment