If you want to delete or clear a sparkline then follow these steps:

- Select the sparkline or the group of sparklines that you want to delete.
- On the Sparkline Tools, click the Design tab.
- On the Design tab, in the Group group, click Clear.

Excel help for the rest of us

You are here: Home / Archives for Excel help

December 9, 2010 by admin

If you want to delete or clear a sparkline then follow these steps:

- Select the sparkline or the group of sparklines that you want to delete.
- On the Sparkline Tools, click the Design tab.
- On the Design tab, in the Group group, click Clear.

Filed Under: Charts, Excel 2010 Tagged With: Charts, Excel 2010, Excel help

November 25, 2010 by admin

If you have a workbook with multiple worksheets and you want to hide some worksheets, e.g. to protect data from accidental change, you can do that as follows:

- Select the worksheet(s) you want to hide.
- In the Home tab, Cells group click Format.
- Under Visibility, point to Hide & Unhide and then click Hide Sheet.

To display or unhide a worksheet:

- In the Home tab, Cells group click Format.
- Under Visibility, point to Hide & Unhide and then click Unhide Sheet.
- In the Unhide sheet box, double-click the name of the hidden sheet that you want to display.

*Applies to: Excel 2007, Excel 2010*

Filed Under: Excel 2007, Excel 2010, Formatting Tagged With: Excel 2007, Excel 2010, Excel help, Formatting

November 12, 2010 by admin

If you are using a sparkline with a line style (Excel 2010), then you can show data markers to highlight individual values. Follow these steps:

- Select a sparkline or a group of sparklines.
- On the Sparkline Tools, click the Design tab.
- On the Design tab, in the Show group, select the check boxes for the individual markers you want to show e.g. High Point, Low Point or Negative Points.
- To show all markers, select the check box labeled Markers.
- To hide a specific marker or markers uncheck the relevant check box(s).

Filed Under: Charts, Excel 2010 Tagged With: Charts, Excel 2010, Excel help

November 5, 2010 by admin

The example below shows a Sparkline for the data in row 2.

To insert a Sparkline follow these steps:

- Enter your data in the worksheet.
- Select the cell where you want to insert the Sparkline.
- Click on the Insert tab.
- In the Sparklines group select one of the three options:
- Line: to plot your chart as a trendline.
- Column: to plot your chart as a series of columns.
- Win/Loss: good if you have negative numbers.

- The Create Sparklines window will open.
- In the Data Range text box enter your data range (in the form B2:G2).
- Your Sparkline will be inserted in the specified cell.

**Tip**.

If you right-click on the Sparkline you will see Sparkline options. e.g. you can change the data range or the Sparkline location.

Filed Under: Charts, Excel 2010 Tagged With: Charts, Excel 2010, Excel help

August 2, 2010 by admin

If you have a number of rows in your sheet and each one has a different size of data. For example one row may have a wrapped text or a text with big font size that does not match with the current row height, then you can adjust the row height.

To adjust the height of each row to fit the entered data:

- Select the rows to be adjusted.
- In the Home tab, Cells group, click Format.
- From the Format menu Click AutoFit Row Height.

Alternatively you can do the same by following these steps:

- Select the rows to be adjusted.
- Point to the lower border of anyone of the selected rows (at the left of the row where the row number is). The mouse pointer should change to a cross with vertical arrows at the top and bottom.
- Double click on the row border.

Before:

After:

Filed Under: Excel 2007, Formatting Tagged With: Excel 2007, Excel help, Formatting

July 15, 2010 by admin

You may have a number of columns in your sheet and each one has a different size of data. For example one column may have only a 2 digit sequence number but another column has a long text.

To adjust the size of each column to fit the entered data:

- Select the columns to be adjusted.
- In the Home tab, Cells group, click Format.
- From the Format menu Click AutoFit Column Width.

Alternatively you can do the same by following these steps:

- Select the columns to be adjusted.
- Point to the right border of anyone of the selected columns (at the top of the column where the column label is). The mouse pointer should change to a cross with horizontal arrows to the left and right.
- Double click on the column border.

Filed Under: Excel 2007, Formatting Tagged With: Excel 2007, Excel help, Formatting

March 30, 2010 by admin

To insert a shape (rectangle, circle, line … etc.) follow these steps:

- Select the Insert tab, then Click Shapes.
- A drop down menu will show different types of shapes.
- Select the shape you want. The mouse pointer will change to a cross like this :
- Draw the shape by pressing the left mouse button then dragging the mouse.
- Release the left mouse button when finished.

Filed Under: Excel 2007, General Tagged With: Drawing, Excel 2007, Excel help

February 11, 2010 by admin

Pivot table is a feature of Excel that takes a long list of data, summarizes it into a shorter list that is more easy to analyze and assimilate.

The best way to explain how to create a pivot table in Excel 2007 is by using an example.

Below is a list of products, salesmen and total sales for a product / salesman.

To create a pivot table to summarize the total sales by product, you perform the following steps:

- Prepare your data table and make sure you have columns headings.
- Select the data range or simply click on a cell within the range.
- In the Insert tab click Pivot Table. The window Create Pivot Table will open.
- Make sure that Table/Range points to your correct range then click OK.
- Now you will get a rectangular area to the left that represents the pivot table, and a field list to the right.
- In the Pivot Table Field List to the right select Product and Total Sales. The pivot table that summarizes total sales by product will be created as follows:
- If you select Salesman instead of Product, this is what you get: a pivot table that summarizes total sales by salesman.
- You can plot a chart from the pivot table as shown below.

Filed Under: Data, Excel 2007 Tagged With: Data, Excel 2007, Excel help

December 18, 2009 by admin

To hide rows based on cell value in Excel 2007 follow these steps:

- Prepare your data including a header row.
- In the Home tab, Editing group, click Sort and Filter then select Filter from the menu.
- Your data will now look like this:

In this example we want to hide rows where the sales are greater than or equal to 2000. I.e. we will only show rows where the sales are less than 2000.

- Click on the filter arrow next to Sales.
- Point to Number Filters and select Less Than.
- The Custom AutoFilter window will open.
- Enter 2000 in the Combo box to the right and click OK.
- Now all rows with values greater than or equal to 2000 will be hidden. Here is the final result:

**Note:**

If your data is text then you will see Text Filters instead of Number Filters in the menu.

Filed Under: Data, Excel 2007 Tagged With: Autofilter, Data, Excel 2007, Excel help

November 29, 2009 by admin

To sum times you usually use Excel built-in function SUM. If you have three cells A1, A2 and A3 formatted as time (hh:mm), and you have :

A1 = 02:30

A2 = 10:15

A3 has the formula: =SUM(A1:A2)

then A3 will have the correct values of 12:45.

However if your total times are greater than 24 hours then things get tricky.

If you have :

A1 = 15:30 and A2 = 10:15 then A3 will have 01:45 instead of 25:45. I.e. any hours beyond 24 hours are dropped.

To retain the hours beyond 24, you have two alternatives:

1. If you want to convert the hours beyond 24 into days then use this cell format : dd:hh:mm. The total in the previous example will be 01:01:45 ( 1day , 1 hour and 45 minutes)

2. If you want to keep the hours beyond 24 as is then use this cell format :[h]:mm. The total in the previous example will be 25:45.

In both cases the formula will remain as it is. Only the cell format differs.

See another example below:

More posts on time:

http://www.exceldigest.com/myblog/2009/02/08/how-to-add-or-sum-times/

http://www.exceldigest.com/myblog/2008/12/04/how-to-create-a-custom-time-format/

Filed Under: Date and Time, Excel 2007, Formatting, Formulas, Functions Tagged With: Excel 2007, Excel help, Formatting, Formulas, Functions

Autofill
Autofilter
Calendar
Cell Protection
Charts
Conditional Formating
Copy
Count
COUNTA
COUNTBLANK
COUNTIF
Customization
Data
Date
Date and Time
Dates
Excel
Excel 2007
Excel 2010
Excel Formatting
Excel Formulas
Excel Functions
Excel help
Excel Worksheet Protection
Files
Find
Formatting
Formulas
Functions
Links
Lists
Macros
Month
Password
Printing
Random Lookup
Save
Sum
Time
User Defined Functions
Validation
Visual Basic
Workbook
Worksheet
Worksheets

Copyright © 2017 · eleven40 theme on Genesis Framework · WordPress · Log in