Tips for Setting Up a Table in Excel

There are a few things to consider before creating your Table: Columns are the foundation of an Excel Table. Table rows are easy to add and remove, but adding or removing Table columns disrupts a Table's basic structure. To save time and frustration, determine exactly what columns are necessary before creating your Table. Do not leave blank rows in the middle of your...

read more "Tips for Setting Up a Table in Excel"

Table Terms in Excel

Excel Tables are made up of columns, column labels, and rows; they can be sorted and/or filtered according to your specifications. Columns determine the informational structure of table rows NOTE: These are the same as database fields. Column Labels identify columns; they often have special formatting NOTE:...

read more "Table Terms in Excel"

Sorting Data in Excel (Sort Button and Sort Dialog Box)

Sorting Data: Sort Button If you simply want to sort your data by one column from smallest to largest or largest to smallest, you can do so with one click. Select a cell in the column used to sort From the Data command tab, in the Sort & Filter group, click SORT SMALLEST TO LARGESTor...

read more "Sorting Data in Excel (Sort Button and Sort Dialog Box)"

Separating Text in Excel (Separating the Data)

1.      Select the cells containing the data you want to separate NOTE: Excel can only separate one column at a time. 2.      Windows only: Select the Data command tab3.      Windows: In the Data Tools group, click TEXT TO...

read more "Separating Text in Excel (Separating the Data)"

Separating Text in Excel (Considerations)

Here are some things to consider before separating your cells: ·         To ensure consistent data separation, standardize all cell data and corresponding delimiters. Using Find and Replace can make standardization quicker and easier. ·         Do not use delimiters that also function as text characters. EXAMPLE:...

read more "Separating Text in Excel (Considerations)"

Hiding Columns, Rows, and Cells in Excel (Hiding Cell Contents)

You have the ability to hide the contents of individual cells if you do not need to view their contents or you simply do not want to print certain cells. 1.      Select the cell(s) to be hidden 2.      From the Home command tab, in the Cells group,...

read more "Hiding Columns, Rows, and Cells in Excel (Hiding Cell Contents)"

Hiding Columns, Rows, and Cells in Excel (Redisplaying Rows)

1.      Select at least one cell from both of the rows around the hidden row(s) to be redisplayed EXAMPLE: If row 5 is hidden, select a cell from rows 4 and 6. HINT: If you cannot select the appropriate cells, you can use the Go To command. 2.     ...

read more "Hiding Columns, Rows, and Cells in Excel (Redisplaying Rows)"

Hiding Columns, Rows, and Cells in Excel (Hiding Rows)

You can hide rows containing information that you do not need to view or do not want to print. 1.      Select a cell within the row(s) to be hidden2.      On the Home command tab, in the Cells group, click FORMAT 3.      From...

read more "Hiding Columns, Rows, and Cells in Excel (Hiding Rows)"

Hiding Columns, Rows, and Cells in Excel (Redisplaying Columns)

1.      Select at least one cell from both of the columns around the hidden column(s) to be redisplayed EXAMPLE: If column B is hidden, select a cell from both columns A and C. HINT: If you cannot select the appropriate cells, you can use the Go To command. 2.     ...

read more "Hiding Columns, Rows, and Cells in Excel (Redisplaying Columns)"

Hiding Columns, Rows, and Cells in Excel (Hiding Columns)

You can hide columns of your worksheet containing information that you do not need to view or do not want to print. 1.      Select a cell within the column(s) to be hidden 2.      On the Home command tab, in the Cells group, click FORMAT 3.     ...

read more "Hiding Columns, Rows, and Cells in Excel (Hiding Columns)"

Find and Replace Features in Excel (Using the Replace Feature)

The Replace feature is useful when you want to change the same piece of information throughout your worksheet. WARNING: Use the Replace All option with caution. If you do not first select specific cells to change, this option will replace the specified information throughout the entire document. This...

read more "Find and Replace Features in Excel (Using the Replace Feature)"