cell

Blog Post

How to find duplicates in Excel

March 5, 2013 10:56am PST

You'll need more than one trick up your sleeve to find duplicates in Excel.

8 Latest comment by thanhonap

Blog Post

How to add a drop-down list to an Excel cell

June 12, 2008 12:00am PDT

Drop-down lists can greatly facilitate data entry. Here's a look at how to use Excel's data validation feature to create handy lists within your worksheets.

43 Latest comment by dhivya.vasu01@...

Blog Post

Build a simple timesheet in Excel

May 3, 2013 12:43am PDT

Excel makes it easy to set up a system for tracking time. Follow these steps to create your own or download our sample timesheet template and customize it to fit your needs.

12 Latest comment by emma0123

Articles

Concatenate date cells with text cells in Excel

December 12, 2006 8:00am PST

Mary Ann Richardson explains that when concatenating date and text cell data in an Excel formula, you need to convert date cells to text to avoid unexpected results.

7 Latest comment by tali.tv

Blog Post

Quickly fill blank cells in Excel

April 26, 2010 10:50am PDT

Blank cells can spell trouble. Here's an easy way to fill in those blanks and protect the validity of your data.

10 Latest comment by Midhunmj

Articles

Use Excel to calculate the hours worked for any shift

June 23, 2005 7:00am PDT

With Excel, you can create a worksheet that figures the hours worked for any shift. Here's how.

23 Latest comment by ron4415

Blog Post

Build a simple timesheet in Excel

January 26, 2010 9:43am PST

Excel makes it easy to set up a system for tracking time. Follow these steps to create your own or download our sample timesheet template and customize it to fit your needs.

38 Latest comment by raj_as

Blog Post

Use a formula to trigger Excel's Conditional Formatting feature

January 5, 2009 1:07pm PST

If you need a visual clue to hype a worksheet, use Excel's Conditional Formatting feature to help values stand out.

29 Latest comment by JNirvaha

Articles

Copy an Excel formula without changing its cell references

October 31, 2006 8:00am PST

If you copy a formula from one place to another, Excel will want to readjust the references to reflect the change. However, if you want the formulas to stay the same, Mary Ann Richardson can help...

56 Latest comment by f.quintas

Blog Post

Excel 2013 Flash Fill anticipates needs on the fly

April 29, 2013 8:23am PDT

Put aside earlier list features and let Excel 2013's Flash Fill interpret your needs and complete the task.

Blog Post

10 obscure Excel tricks that can expedite common chores

June 10, 2008 11:33am PDT

Some Excel users waste a lot of time (and add to your support burden) because they don't know the smartest ways to work with spreadsheet data. Here are some highly useful tips that can streamline...

14 Latest comment by david.white@...

Blog Post

A quick way to delete blank rows in Excel

January 5, 2012 11:48am PST

Deleting blank rows in an Excel data range is easy with this technique, but watch out for unintended consequences.

3 Latest comment by jbenton@...

Articles

Adjust text to fit within an Excel cell

August 24, 2005 12:30am PDT

Microsoft Excel's AutoFit feature is great when you need to resize a cell to display more text than the cell currently allows. But when you can't change the size of a cell to fit the text, this...

11 Latest comment by moni123

Blog Post

A couple of time-saving autofill shortcuts for Excel

May 13, 2013 11:13am PDT

Learn these autofill tricks to work more efficiently with recurring data in Excel.

Articles

10 obscure Excel tricks that can expedite common chores

January 5, 2007 8:00am PST

The business world is full of users who have neither the opportunity nor the inclination to figure out Excel's shortcuts. They end up wasting a lot of time (and adding to your support burden)...

29 Latest comment by Rashidgg

Blog Post

Return the last item in an Excel column

October 20, 2008 12:00am PDT

Use this Excel formula to easily return the last item from any list.

8 Latest comment by wizard57m-cnet

Blog Post

Three ways to hide zero values in an Excel sheet

June 21, 2012 8:18am PDT

Although zero values are valid, you might need to hide them. Here are three methods for hiding zero values in an Excel sheet.

12 Latest comment by hws1947@...

Blog Post

10 powerful ways to use Excel's paste features

December 12, 2011 12:19pm PST

Excel's Paste and Paste Special commands harbor a multitude of useful options. Use them to do everything from transposing data to copying Validation rules.

2 Latest comment by mary@...

Blog Post

How to protect cells in a Word table using a Text Form Field

June 17, 2011 6:40am PDT

Protecting data in a Word table isn't as simple as turning a protection feature on, but it's possible using Text Form Field controls.

2 Latest comment by RowenaT

Blog Post

Create an Excel data table to compare multiple results

December 28, 2012 12:57am PST

Suppose you want to view multiple possibilities within an Excel calculation. The answer is to create a data table.

4 Latest comment by tufte@...