First grade number of the day worksheet


Number of the Day - The Curriculum Corner 123

This collection of nine different number of the day worksheets will fit well into your daily number sense practice.

Providing students with number of the day practice is a great way to help children build their number sense skills.

This collection will provide you with a variety of options so you can find a fit for your students.

This is another free resource for teachers and homeschool families.

These free number of the day worksheets will give your students a daily dose of place value practice.

We think having a number of the day can be a great morning entry task that sets a daily routine in your classroom.

These pages might also be used at a math center.

Finding a fit for your students

We have made this activity easy for you to differentiate in your classroom. Choose the page that meets the needs of each student. You can also provide more than one number of the day for students ready for a challenge.

We have made this one easy to differentiate!

There are nine forms to choose the one that is just right for your students.

You will find forms that meet kindergarten through third grade standards.

Some options for using these daily number of the day worksheets include:

  • Morning entry task – students can complete as they enter the room each day
  • Math center – this could be a daily or weekly math center
  • Small group practice – for students who need guidance, a number of the day activity might be a part of your instruction in small groups

You know your students best! Number of the day activities can provide meaningful number sense practice for your students who need it. As students master skills, we like to phase out how often students complete this activity.

For some students, this type of activity might become busy work. This is always when we work to find something new that will fit their needs!

You might choose to give students a number or let students use the number cards we created.

You can download the Number of the Day Worksheets here:

Math Download

We have also created number cards you can place at a basket. Instead of assigning one number for the whole class, you can have students choose a number from the basket.

This is a large file with many pages. You will find all numbers from 0 through 1,009. There is also a blank page if you would like to write your own numbers. Be sure to only print the pages you need.

We like to print these cards on colorful cards tock and laminate for durability.

Download these number cards here:

Math Card Download


Looking for more number sense building activities? Start with our unit of study: 

Numbers, Counting & Ordering

You might also be interested in our set for upper grades:
Number of the Day for 456 


As with all of our resources, The Curriculum Corner creates these for free classroom use. Our products may not be sold. You may print and copy for your personal classroom use. These are also great for home school families!

You may not modify and resell in any form. Please let us know if you have any questions.

Number of the Day Worksheet

6 Shares

  • More

This number of the day worksheet and Google slides have children working on a hundreds chart, coloring in base ten blocks, filling in number lines, writing a number in expanded form, and more.

Place value! It is an essential part of every math curriculum. For children to be really successful in math they MUST understand this….or they will just be going through the motions.

Table of Contents

Motions that are not understood, and will be forgotten as they move on.

Number of the Day

There are many ways that you can teach place value, and doing small place value activities daily is important.

So today, I’m sharing with you a number of the day worksheet and Google slides that will help you develop place value skills every day.

You can also get a  Fractions of the Day, or a Decimals of the Day

Number of the Day Sheet: Base Ten Blocks

The first part of this sheet is to color in the base ten blocks that represent the number of the day and to also write how many hundreds, tens, and ones there are.

In this example, the student was given the number 258. As you can see they wrote that there were two hundreds, and then colored in two flats.

Next, they looked in the tens place and realized that there were 5 tens or 50. The student was then able to color in five longs.

Finally, they looked at the one’s place and saw that there were eight ones. They wrote 8 in the one’s place and then colored in 8 cubes.

Expanded Form

Once this is done, they jump right to expanded form, and this is easy since we just figured out how many hundreds, tens, and ones were in the number 258.

All they need to do is put it together: 200 + 50 + 8 equals 258.

Hundreds Chart

Right underneath the expanded form, we move to a funny-looking grid. This is a hundred’s chart puzzle, and if they haven’t done these before it may be a great idea to practice with our Hundreds Puzzle game.

The student can put the number 258 anywhere in the grid, and then figure out what the rest of the numbers would be if this was a hundred chart.

In this example, the child put the 258 right in the middle. They recognized that going up one space would put them at 248, the number to the left would be 247, and the number to the right would be 249.

Now the student used the same strategy going down. They added 10, and then subtracted and add one from 268 to get the next two answers.

There is so much math happening here!!!

Number Bonds

Moving on to our next section, we hit number bonds. This is a wonderful way to work on fact families in a very visual way. The children figure out two numbers that equal 258, and then they fill out the number bonds and the fact families that correspond to those numbers.

If you are working with young children and want to introduce number bonds, these monster task cards are a great place to start. 

Even and Odd

The next one is an easy one. Is the number even or odd? Once they figure that out, they just color in the circle.

More And Less

Understanding one more and one less, and ten more or less is an important skill. This reinforces the place value of each digit…..and this next box tackles this concept.

The children look at the number 258 and then do each of the following.

First, we do 258 + 1 = 259

Next comes 258 – 1 = 257

We move on to 258 + 10 = 268

And we end with 258 – 10 = 248

Get more adding and subtracting by 10 activities here.

Number Line

The last step of this number of the day worksheet is to put numbers on the number line. You could allow children to write the Number of the Day in the first box and move on from there….but you can definitely make it harder.

Asking them to put the number of the day in the middle or at the end of the number line will add a challenge. Now they must be able to count backward as well as count forward! A great place value lesson!

Working through a number of the day daily will help children build number sense and develop a deeper understanding of place value.

Number of the Day Printable

Below you will find the number of the day free printable and Google slides. Download the printables to your computer by clicking on the download button. Once you have downloaded them, you can print them.

Number-of-the-Day

Number-of-the-Day-Printable-and-Google-Slides

6 Shares

  • More

Create a PivotTable to analyze sheet data

The PivotTable is a powerful tool for calculating, summarizing, and analyzing data that makes it easy to find comparisons, patterns, and trends. PivotTables work a little differently depending on the platform you use to run Excel.

  1. Select the cells from which you want to create a pivot table.

    Note: Data must be organized in columns with one header row.

  2. On the tab Insert , click the button PivotTable .

  3. This will create a pivot table based on an existing table or range.

    Note: If you select the Add this data to Data Model option, the table or range used for this PivotTable will be added to the Book Data Model. Additional information.

  4. Select the location of the PivotTable report. Select "Create Sheet " to place the PivotTable on a new or existing sheet, and select where the new PivotTable should be displayed.

  5. Press button OK .

You can select other PivotTable sources by clicking the down arrow on the button. In addition to an existing table or range, there are three other sources from which you can choose to populate a PivotTable.

Note: Depending on your organization's IT environment,
the button might include your organization's name. For example, "From Power BI (Microsoft)"

Getting from an external data source

Get from data model

Use this option if the workbook contains a data model and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or work with very large datasets.

Get from Power BI

Use this setting if your organization uses Power BI and you want to discover and connect to recommended cloud datasets that you have access to.

  1. To add a field to a pivot table, select the check box next to the field name in area Pivot table fields .

    Note: Selected fields are added to default scopes: non-numeric fields are added to rows, datetime hierarchies are added to columns, and numeric fields are added to values.

  2. To move a field from one area to another, drag it to the target area.

When new data is added to a source, all PivotTables based on it must be updated. To refresh a single PivotTable, you can right-click anywhere in its range and select Refresh . If you have multiple PivotTables, first select any cell in any PivotTable, and then on the Ribbon, select Tab PivotTable Analysis , click the arrow under the Update button and select Update All .

Operation

By default, PivotTable fields placed in the Values ​​area will be displayed as sum . If Excel interprets your data as text, it will display as COUNT . This is why it's so important not to mix data types for value fields. To change the default calculation, first click the arrow to the right of the field name, and then select the Value Field Options option.

Then change the function in section Operation . Note that when you change a calculation method, Excel automatically adds its name to section Custom name (for example, "Sum by field field_name"), but you can change the name. To change the number format for the entire field, press the 9 button0012 Number format .

Tip: Because changing the calculation method in section Operation updates the PivotTable field name, it is not recommended that you rename PivotTable fields until you have finished customizing the PivotTable. Instead of manually changing the names, you can press the button Find and replace ( CTRL+H ), in the field Find enter Sum of field , and leave the field Replace empty.

Additional calculations

Values ​​can also be displayed as a percentage of the field value. In the example below, we have changed the expense amount to % of the total .

You can set these options in the dialog box Value field settings on tab Additional calculations .

Display value as calculation result and as percentage

Simply drag and drop the item into the Values ​​ section twice, and then adjust the Operation and Additional Calculations parameters for each of the copies.

  1. Select a table or data range on a sheet and press the 9 button0012 Insert > PivotTable to open the Insert PivotTable panel.

  2. You can manually create your own pivot table or select a recommended pivot table to create. Do one of the following:

  • On page "Create Your Own Pivot Table Card" select "Create Sheet" or "Existing Sheet" to select the destination of the pivot table.

  • In the Recommended PivotTable, select New Sheet or Existing Sheet to select the destination of the PivotTable.

Note: Recommended PivotTables are only available to Microsoft 365 subscribers.

The data source of a PivotTable can be changed when it is created.

  1. In area "Insert PivotTable " select the text field in section "Source" . When the source is changed , the cards on the panel will not be available.

  2. Select data in the grid or enter a range in the text box.

  3. Press the ENTER key or the button to confirm the selection. The panel will update with new recommended PivotTables based on the new data source.

Get from Power BI

Use this setting if your organization uses Power BI and you want to discover and connect to recommended cloud datasets that you have access to.

In the PivotTable Fields area , select the check box for any field that you want to add to the PivotTable.

By default, non-numeric fields are added to the Rows area, date and time fields are added to the Columns area, and numeric fields are added to the Values ​​area.

You can also manually drag any available item to any of the PivotTable fields, or if the item in the PivotTable is no longer needed, drag it from the list or clear it.

Operation

By default, PivotTable fields in the Values ​​area will be displayed as Sum . If Excel interprets your data as text, it will display as COUNT . This is why it's so important not to mix data types for value fields.

Modify the default calculation by right-clicking on any value in a row and selecting option "Sum values ​​over ".

Additional calculations

Values ​​can also be displayed as a percentage of the field value. In the example below, we have changed the expense amount to % of the total .

Right-click any value in the column for which you want to display the value. Select "Show values ​​as " in the menu. A list of available values ​​will be displayed.

Make a selection from the list.

To display the percent value of the parent total, hover over the item in the list and select the parent field you want to use as the calculation base.

When new data is added to a PivotTable data source, all PivotTables created from that data source must be updated. Right click anywhere PivotTable range and select command Refresh .

If you have created a pivot table and decide that it is no longer needed, select the entire range of the pivot table and press the DELETE key. This will not affect other data, PivotTables or charts around them. If the PivotTable is on a separate sheet that doesn't have any other data you want to keep, deleting the sheet is a quick way to delete the PivotTable0012 tables.

  • Data must be presented as a table that does not have empty rows or columns. It is recommended to use an Excel spreadsheet, as in the example above.

  • Tables are a great data source for PivotTables because rows added to the table are automatically included in the PivotTable when the data is refreshed, and any new columns are added to the list Pivot table fields . Otherwise, you must either change the source data for the PivotTable or use a dynamic named range formula.

  • All data in a column must be of the same type. For example, you should not enter dates and text in the same column.

  • Pivot tables are applied to a snapshot of data called a cache, and the actual data is not changed.

If you don't have much experience with PivotTables or don't know where to start, it's best to use the recommended PivotTable . In doing so, Excel determines the appropriate layout by matching the data to the most appropriate areas in the PivotTable. This provides a starting point for further experiments. After creating the recommended PivotTable, you can explore the different orientations and reorder the fields to get the results you want. You can also download the interactive tutorial Create your first PivotTable.

  1. Click a cell in the source data range and table.

  2. On the tab, Insert , click the Featured PivotTables button.

  3. Excel will analyze the data and provide several options, as in this example:

  4. Select the pivot table you like and click the OK button . Excel will create a pivot table on a new sheet and display a list of fields in the pivot table

  1. Click a cell in the source data range and table.

  2. On the tab Insert , click the button PivotTable .

  3. The Create PivotTable dialog box appears with your range or table name. In this case, we use the "table_FamilyExpenses" table.

  4. In section Specify where to place the PivotTable report , select the radio button On a new sheet or On an existing sheet . If you select On an existing worksheet , you will need to specify a cell to insert the PivotTable.

  5. Press button OK . Excel will create an empty pivot table and list Pivot table fields .

Pivot table field list

At the top of the Field Name area, select the check box for any field that you want to add to the PivotTable. By default, non-numeric fields are added to the String area, date and time fields are added to the Column area, and numeric fields are added to area values. You can also manually drag any available item to any of the PivotTable fields, or if the item in the PivotTable is no longer needed, simply drag it from the Field List or clear it. The ability to reorder field items is one of the PivotTable features that allows you to quickly change the look and feel.

Pivot table field list

  • Sum over

    By default, PivotTable fields placed in the Values ​​area will be displayed as sum . If Excel interprets your data as text, it will display as COUNT . This is why it's so important not to mix data types for value fields. To change the default calculation, first click the arrow to the right of the field name and then select option "Parameters fields".

    Then change the function in section Sum over . Note that when you change a calculation method, Excel automatically adds its name to section Custom name (for example, "Sum by field field_name"), but you can change this name. To change the number format for the entire field, click the Number... button.

    Tip: Because when you change the calculation method in section Summarize by the name of the pivot table field is updated, it is not recommended to rename the fields of the pivot table until the configuration is complete. Instead of manually changing the names, you can select Find ( in the Edit menu ), enter Sum of field in the Find field, and leave the Replace field blank.

  • Additional calculations

    Values ​​can also be displayed as a percentage of the field value. In the example below, we have changed the expense amount to % of the total .

    You can set these options in the dialog box Field Options on tab Additional Calculations .

  • Display value as calculation result and as percentage

    Simply drag and drop the element into the Values ​​section twice, right-click the value and select Field Options , and then configure the Sum by and Additional Calculations options for each of the copies.

When new data is added to a source, all PivotTables based on it must be updated. To refresh a single PivotTable, you can right-click anywhere in its range and select Refresh . If you have multiple PivotTables, first select any cell in any PivotTable, and then on the Ribbon click the PivotTable Analysis tab , click the arrow below the Update button and select Update All .

If you've created a PivotTable and decide you don't need it anymore, you can simply select the entire PivotTable range and then press DELETE . It will not affect other data, pivot tables or charts around them. If the PivotTable is on a separate sheet where there is no more data you need, you can simply delete that sheet. This is the easiest way to get rid of the pivot table.

Additional information

You can always ask the Excel Tech Community a question or ask for help in the Answers community.

PivotTable recommendations are part of a connected experience in Office and analyze data using artificial intelligence services. If you choose to opt out of a connected experience in Office, your data won't be sent to the AI ​​service and you won't be able to use PivotTable recommendations. For more information, see the Microsoft privacy statement.

Related Articles

Create a PivotChart

Using Slicers to Filter PivotTable Data

Create a PivotTable Timeline to Filter Dates

Create a pivot table with a data model to analyze data across multiple tables

Create a PivotTable connected to Power BI datasets

Ordering PivotTable Fields Using a Field List

Changing the PivotTable's Source Data

Calculating values ​​in a pivot table

Deleting a PivotTable

WorksheetBase Class (Microsoft.Office.Tools.Excel) | Microsoft Learn

Twitter LinkedIn Facebook E-mail address

  • Reference

Definition

Namespace:
Microsoft. Office.Tools.Excel
Assembly:
Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Important!

Some information refers to a pre-release product that may be subject to significant changes prior to release. Microsoft makes no warranties, express or implied, with respect to the information contained herein.

Provides the base class for the Sheet n classes in document-level projects for Microsoft Office Excel.

 [System.ComponentModel.ToolboxItem(false)] public abstract class WorksheetBase : IDisposable, Microsoft.Office.Tools.Excel.IWorksheetExtension, System.ComponentModel.IComponent, System.ComponentModel.ISupportInitialize, System.Windows.Forms.IBindableComponent 
Inheritance

Object

WorksheetBase

Attributes

ToolboxItemAttribute

Implementations

EntryPoint IWorksheetExtension IExtension IComponent ISupportInitialize IDisposable IBindableComponent

The

WorksheetBase class is the base class for the Sheet n classes in document-level Excel projects created with Visual Studio. Use 9 classes0631 Sheet n for programmatic access to sheets in a project. The WorksheetBase class is a host element that represents a worksheet in document-level projects. For more information, see Host Items and Controls of the Host Application and Sheet Host Item Overview.

The WorksheetBase class provides the same members as the Microsoft.Office.Interop.Excel.Worksheet class in the Excel primary interop assembly, but adds the following functionality:0003

  • The Controls property. This property is used to add managed controls to an Excel worksheet, or to remove controls at run time.

  • InnerObject property. This property is used to get the underlying Microsoft.Office.Interop.Excel.Worksheet object for the worksheet host item.

  • The GetAutomationObject method. Override this method to provide a class in the project to the VBA code in the worksheet.

  • Document-level events such as ActivateEvent and Change that are only exposed at the application level in the Excel object model. That is, in the Excel object model, these events are defined in the Microsoft.Office.Interop.Excel.Application class, not in the Microsoft.Office.Interop.Excel.Worksheet class.

Creating worksheet host items

You cannot create WorksheetBase objects programmatically in Office projects.

In document level 9 projects0631 Sheet instances of the n classes (which derive from WorksheetBase ) are automatically created by the Visual Studio Toolkit for Office (runtime) when an end user opens a workbook. For more information, see Programming Document-Level Customizations.

In application-level projects, you can programmatically create sheet anchors using the GetVstoObject method. The worksheet host item that is created is a Microsoft.Office.Tools.Excel.Worksheet object, not a WorksheetBase object. For more information, see Extending Word Documents and Excel Workbooks in VSTO Add-ins at Run Time.

Usage

This type is used only in Office projects that target the . NET Framework 4 or later. The assembly that defines this type is not part of the Visual Studio Tools for Office (Runtime). You must deploy this assembly along with the solution. For more information, see Assemblies in Visual Studio Tools for Office Runtime.

Constructors

WorksheetBase(Factory, IServiceProvider, String, String)

Properties

Application

Gets an Application object that represents the Microsoft Office Excel application.

AutoFilter

Gets an AutoFilter object that provides information about the filtered lists on the worksheet if filtering is enabled. Gets object null if filtering is disabled.

AutoFilterMode

Gets or sets a value indicating whether filtering is currently enabled on the worksheet (that is, whether filtering drop-down arrows are currently displayed).

Base

Gets or sets the Worksheet that this WorksheetBase extends.

BindingContext
Cells

Returns a Range object representing all cells in the worksheet (not just the cells currently in use).

CircularReference

Returns a Range object representing the range that contains the first circular reference in the worksheet, or returns null if there are no circular references in the worksheet.

columns

Gets a Range object that represents one or more columns on the worksheet.

Comments

Returns a Comments collection representing all the comments for the worksheet.

ConsolidationFunction

Returns the function code for the current consolidation.

ConsolidationOptions

Returns an Array of consolidation parameters, consisting of three elements.

ConsolidationSources

Returns an Array with the names of the source sheets and ranges for the current worksheet consolidation.

Controls

Gets the collection of managed controls contained in the worksheet.

creator

Returns a value indicating the application in which the worksheet was created.

CustomProperties

Returns a CustomProperties object that represents the identity information associated with the worksheet.

DataBindings
data host
DisplayPageBreaks

Gets or sets a value indicating whether page breaks (set manually or automatically) are displayed on the worksheet.

DisplayRightToLeft

Gets or sets a value indicating whether the worksheet should be displayed from right to left instead of left to right.

EnableAutoFilter

Gets or sets a value indicating whether autofilter arrows are displayed when using UI-only protection.

EnableCalculation

Gets or sets a value indicating whether Microsoft Office Excel will automatically recalculate the worksheet when necessary.

EnableFormatConditionsCalculation

Gets or sets a value indicating whether automatic evaluation of conditional formats is used.

Enable Outlining

Gets or sets a value indicating the display of outline symbols when using UI-only security. This type or member is intended for use only in projects in the 2007 Microsoft Office system. We do not recommend using smart tags in Office 2010. This type or member is intended for use only in 2007 Microsoft Office system release projects. It is not recommended to use smart tags in Office 2010..

EnablePivotTable

Gets or sets a value indicating whether PivotTable controls and functions can be used when UI-only security is applied.

EnableSelection

Gets or sets a value indicating the cells on the worksheet that can be selected.

FilterMode

Gets a value indicating whether the worksheet is actively filtering data.

HostContext
HPagebreaks

Returns an HPageBreaks collection that represents the horizontal page breaks on a worksheet.

hyperlinks

Returns a Hyperlinks collection representing hyperlinks to a range or worksheet.

Index

Returns the index number of the worksheet within the worksheet collection.

InnerObject

Gets a Worksheet object that represents the underlying native WorksheetBase object.

ItemProvider
ListObjects

Returns a collection of ListObjects on the worksheet.

MailEnvelope

Returns the email header for the worksheet.

Name

Gets or sets the name of the worksheet.

Names

Gets a Names collection that represents all worksheet-specific names (names defined with the "WorksheetName!" prefix).

Next

Returns a Worksheet object representing the next worksheet.

outline

Returns an Outline object representing the outline of the worksheet.

PageSetup

Returns a PageSetup object containing all the page setup options for the worksheet.

parent

Returns the parent worksheet object.

Previous

Returns a Worksheet object representing the previous worksheet.

PrintedCommentPages

Gets the number of note pages to be printed for the current sheet. This property can only be used in Excel 2010 projects.0003

ProtectContents

Returns a value indicating whether the contents of the worksheet (individual cells) are protected.

ProtectDrawingObjects

Gets a value indicating whether the object has shape protection.

Protection

Returns a Protection object that represents the protection settings for the worksheet.

ProtectionMode

Gets a value indicating that UI-only security is being used.

ProtectScenarios

Gets a value indicating whether worksheet scripts are protected.

QueryTables

Returns a QueryTables collection representing all query tables on the worksheet.

Range

Returns a Range object that represents a cell or range of cells.

Rows

Gets a Range object that represents one or more rows on the worksheet.

ScrollArea

Gets or sets the range within which scrolling is allowed, as a range reference in A1 format.

Shapes

Returns a Shapes object representing all the shapes on the worksheet.

site
Sort

Returns the sorted values ​​in the current worksheet.

StandardHeight

Returns the standard height (default) in points of all rows in the worksheet.

Standard Width

Gets or sets the standard (default) width of all columns in the worksheet.

Tab

Returns the Tab for the worksheet.

Tag

Gets or sets an object that contains data about the worksheet.

TransitionExpEval

Gets or sets a value indicating whether Microsoft Office Excel will use the Lotus 1-2-3 expression evaluation rules for the worksheet.

TransitionFormEntry

Gets or sets a value indicating whether Microsoft Office Excel uses the Lotus 1-2-3 formula entry rules for the worksheet.

type

Returns the worksheet type.

UsedRange

Returns a Range object that represents all cells that currently contain a value.

visible

Gets or sets an XlSheetVisibility value indicating whether the object is visible.

vpagebreaks

Returns a VPageBreaks collection that represents the vertical page breaks on the worksheet.

Methods

Activate()
BeginInit()
CalculateMethod()

Calculates formulas on a worksheet.

ChartObjects(Object)

Returns an object that represents either a single embedded chart (a ChartObject object) or a collection of all embedded charts (a ChartObjects collection) on the worksheet.

CheckSpelling(Object, Object, Object, Object)
CircleInvalid()

Circles invalid values ​​in the worksheet.

ClearArrows()

Removes trace arrows from the worksheet. Trace arrows are added using the audit feature.

ClearCircles()

Removes circles from invalid values ​​in the worksheet.

Copy(Object, Object)

Copies the sheet to another location in the workbook.

Delete()

Deletes the base Worksheet object, but does not delete the host item. It is highly recommended not to use this method.

Dispose()

Releases all resources used by the current instance of the WorksheetBase class.

EndInit()
Evaluate(Object)

Converts a Microsoft Office Excel name to an object or value.

ExportAsFixedFormat(XlFixedFormatType, Object, Object, Object, Object, Object, Object, Object, Object)

Performs an export to a file of the specified format.

FinishInitialization()
GetAutomationObject()

The Visual Studio Tools for Office (Runtime) is called to get an object that can be used by the VBA code in the worksheet.

Initialize()
InitializeDataBindings()
Move(Object, Object)

Moves the worksheet to a different location in the workbook.

OLEObjects(Object)

Returns an object that represents either a single OLE object (OLEObject object) or a collection of all OLE objects (OLEObjects collection) in the worksheet.

OnShutdown()
OnStartup()
Paste(Object, Object)

Pastes the contents of the clipboard into the worksheet.

PasteSpecial(Object, Object, Object, Object, Object, Object, Object)

Pastes the contents of the clipboard into the worksheet using the specified format. This method is used to paste data from other applications or paste data in a specific format.

PivotTables(Object)

Returns an object that represents either a single PivotTable report (PivotTable object) or a collection of all PivotTable reports (PivotTables collection) on the worksheet.

PivotTableWizard(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Creates a PivotTable object.

PrintOutEx(Object, Object, Object, Object, Object, Object, Object, Object, Object)

Print worksheet.

PrintPreview(Object)

Displays the sheet in Print Preview.

Protect(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Protects the worksheet from changes.

ResetAllPageBreaks()

Reset all page breaks on the specified worksheet.

SaveAs(String, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Saves changes in the worksheet to another file.

Scenarios(Object)

Returns an object that represents either a single script (a Scenario object) or a collection of scripts (a Scenarios collection) in a worksheet.

Select(Object)

Select worksheet.

SetBackgroundPicture(String)

Specifies the background image for the worksheet.

ShowAllData()

Makes all rows of the filtered list visible. If autofiltering is used, calling this method changes the arrows to "All" arrows.

ShowDataForm()

Displays the data form associated with the worksheet.

Unprotect(Object)

Removes protection from the worksheet. If there is no protection on the worksheet, this method does not work.

XmlDataQuery(String, Object, Object)

Returns a Range object representing the cells mapped to the specified XPath. Returns null if the specified XPath is not mapped to a worksheet, or if the mapped range is empty.

XmlMapQuery(String, Object, Object)

Returns a Range object representing the cells mapped to the specified XPath. Returns null if the specified XPath is not mapped to a worksheet.

Developments

ActivateEvent

Occurs when the worksheet is activated.

BeforeDoubleClick

Occurs when the sheet is double-clicked before the default double-click handler is called.

BeforeRightClick

Occurs when any sheet is right-clicked before the default right-click handler is called.

BindingContextChanged
Calculate

Occurs after the worksheet has been recalculated.

change

Occurs when any changes are made to cells in the WorksheetBase.

Deactivate

Occurs when the worksheet loses focus.

Disposed
FollowHyperlink

Occurs when any hyperlink in the worksheet is followed.

PivotTableAfterValueChange

Occurs after a cell or range of cells in a PivotTable has been modified or recalculated (for cells containing formulas). This event can only be used in Excel 2010 projects.

PivotTableBeforeAllocateChanges

Occurs before changes are applied to the PivotTable. This event can only be used in Excel 2010 projects.

PivotTableBeforeCommitChanges

Occurs before changes are made to the OLAP data source for a PivotTable. This event can only be used in Excel 2010 projects.

PivotTableBeforeDiscardChanges

Occurs before discarding changes to the PivotTable. This event can only be used in Excel 2010 projects.

PivotTableChangeSync

Occurs after changes are made to the PivotTable. This event can only be used in Excel 2010 projects.

PivotTableUpdate

Occurs when a PivotTable report on a worksheet is refreshed.

SelectionChange

Occurs when the selection on the worksheet changes.

shutdown

Occurs when the sheet host item is closed.

startup

Explicit Interface Implementations

EntryPoint.

Learn more


Wave

North Coast Community Services
710 Fraser Street, Prince Rupert, BC V8J 1P9
Ph: 250.627.7166 | Fx: 250.627.7482

© All Rights Reserved | powered by ExpressionEngine