Get started for free
Developer Tools and Languages
Visual Studio 2012
Office Development in Visual Studio
Create Add-ins and Customizations for Office by using Visual Studio
Managed Reference (Office Development in Visual Studio)
Microsoft.Office.Tools.Excel
WorksheetBase Class
WorksheetBase Methods
Activate Method
Arcs Method
BeginInit Method
EntryPoint.BeginInit Method
Buttons Method
CalculateMethod Method
ChartObjects Method
CheckBoxes Method
CheckSpelling Method
CircleInvalid Method
ClearArrows Method
ClearCircles Method
Copy Method
Delete Method
Dispose Method
DrawingObjects Method
Drawings Method
DropDowns Method
EndInit Method
EntryPoint.EndInit Method
Evaluate Method
ExportAsFixedFormat Method
FinishInitialization Method
EntryPoint.FinishInitialization Method
get_Range Method
GetAutomationObject Method
IWorksheetExtension.GetAutomationObject Method
GroupBoxes Method
GroupObjects Method
Initialize Method
EntryPoint.Initialize Method
InitializeDataBindings Method
EntryPoint.InitializeDataBindings Method
Labels Method
Lines Method
ListBoxes Method
Move Method
OLEObjects Method
EntryPoint.OnShutdown Method
OnShutdown Method
EntryPoint.OnStartup Method
OnStartup Method
OptionButtons Method
Ovals Method
Paste Method
PasteSpecial Method
Pictures Method
PivotTables Method
PivotTableWizard Method
PrintOut Method
PrintOutEx Method
PrintPreview Method
Protect Method
Rectangles Method
ResetAllPageBreaks Method
SaveAs Method
Scenarios Method
ScrollBars Method
Select Method
SetBackgroundPicture Method
ShowAllData Method
ShowDataForm Method
Spinners Method
TextBoxes Method
Unprotect Method
XmlDataQuery Method
XmlMapQuery Method
Expand Minimize
This topic has not yet been rated - Rate this topic

WorksheetBase.ShowAllData Method

Visual Studio 2012

Makes all rows of the currently filtered list visible. If AutoFilter is in use, this method changes the arrows to "All."

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
C#
VB
Copy 
public void ShowAllData()
Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.