Using Excel’s Fill Handle

The Fill Handle is very useful for copying the contents of a cell or extending a series of data.  It is represented by a little blue square in the lower right corner of a selected cell. To fill in a series of data: Enter the first part of your data set. For instance, “1, 2,...

Restricting Editing to Individual Cells in Excel 2007

What if you only want to protect a single, or several single cells, in an entire Excel worksheet and allow users to edit or input data in the rest of the sheet? Let’s say you have a worksheet like this: You would like your department members to edit the “data” in the black text cells,...

Concatenating Text Columns in Excel

Adding “@colby.edu” to a List of Simple Usernames What do you do if you need to send out a mailing and all you can have is an excel list of simple usernames: no @ sign, no “colby.edu”.  Will you have to edit each one by hand? No! These easy steps will save you a ton of...

Hyperlinking Between Worksheets in Excel

You probably create links to web sites in Excel all the time. But did you know that you can create a hyperlink to different worksheets in the same workbook? Internal hyperlinks will save you time and – if you create an “Overview” sheet at the front of workbooks you want to share with team members...

Excel

Gridlines and Borders are not the same. Explore the differences between GRIDLINES and BORDERS in Excel worksheets.

Tracking Changes in Excel 2007

1 Click on the “Review” tab on the Ribbon in Excel 2007   2 The “Changes” group is on the far right hand side of the Ribbon   3 Click on “Track Changes” and “Highlight Changes”   4 Check “Track changes while editing.  This also shares your workbook.”   5 Select what you want highlighted  ...

Extracting Data by Cell Values in Excel

 Let’s say you have a large workbook of names and addresses and you need to find only those folks listed with area codes of 207 and 613. You could sort the data by area code and copy and paste after each section – or you could use the FILTER function. Here’s how: Select the entire...