cells

The number of organ donors in North America is consistently lower than the number awaiting a donation. Now Organovo, a biotech company based in San Francisco, is attempting to save thousands of lives with their "organ printer" that is supposedly ... able to create artificial blood vessels made entirely from human cells. While it might sound like a wishful, futuristic endeavor, the way an "organ printer" operates is incredible. An Assortment of Printable Cell-Types Instead of dispensing ink (as with a traditional printer) the "organ printer" uses two robotic tips that deposit an ... (view more)

I have had situations when I was using an MS Excel spreadsheet and had a column of data and then wanted to increase the value of a range of cells by, perhaps, 10%. No doubt, you have also experienced this when using MS Excel. If so, I am sure that ... this meant keying in the new values, or using a hidden column and formulas, or by making all of the cells formula-based when you created the worksheet. Well now I am going to tell you how to do it the easy way -- the way in which you save time and keystrokes! That's what I'm talking about! Follow the steps below to learn how: Open your spreadsheet ... (view more)

Formatting worksheet content has been problematic in the past because compared to MS Word or even PowerPoint, Excel was pretty rigid in this area. However, if you use the new formatting capabilities in Excel, there will be no more problems! Your ... workbook is comprised of sheets, that are comprised of rows and columns, that are comprised of cells. Start by formatting the most of your workbook that you can in one fell swoop, such as applying a theme and setting workbook defaults. One of the easiest and most time-saving things you can do when formatting workbooks is to set your formatting ... (view more)

A reader asked if there was any formula in Excel that would convert a date shown in the European format of day-month-year to the U.S. version of month-day-year. Technically, it may not be necessary to do this. Excel maintains dates as numeric values ... and displays them using various formats. If the dates are numeric values in your worksheet, then you can simply change the format and the dates will be displayed in the U.S. format. The day you see in a worksheet could instead be a text value rather than a numeric value. To see if the date is truly an Excel date or text value, you can change the ... (view more)

In a recent article, I told you some of my favorite tips and tricks to use in MS Word when looking to save time and keystrokes. Get ready for some of my favorite timesaving tips and tricks to use in MS Excel. Want to copy an entire worksheet? Simply ... select the tab of the worksheet. Hold down the Ctrl key and drag the tab of the worksheet to either the left or right. You will see what looks appears to be a little sheet of paper with a plus sign on it Drag the little sheet wherever you wish to copy it. Release the mouse and you are finished! Want to clear cells in a worksheet? I know that you ... (view more)

The Paste Special command can be used to create a link between cells. The source cell values must be copied to the Windows Clipboard. The link is created when the values are pasted to the target destination cells using the Paste Special Command. To ... create a link by USING the Paste Special command, follow the steps below: Open the desired workbooks, if necessary. Select the source cell(s) to be copied. Click on the Copy button on the Standard toolbar. Or right-click on the cells and then choose copy from the shortcut menu. Choose Edit | Copy. Press CTRL + C as an alternative. Select the ... (view more)

Data that is stored in one section of a worksheet is often needed in other sections of the same worksheet, other worksheets within the same workbook, or even different workbooks. Excel makes it easy for you to create dynamic or active links between ... cells, whether they are in the same or different workbooks. Linking data eliminates the need to repeat information in several files. Links are often used to automate worksheets that share similar values. For example, several worksheets might use an interest rate figure that is constantly changing. Instead of updating the interest rate in each ... (view more)

Rather than just pasting raw numbers into a table, you can embed a worksheet into a document. Embedding retains the formulas that ride behind your numbers and all the functionality of Excel. You can create an Excel worksheet from scratch, or, if the ... worksheet already exists, you can insert it using the Paste Special command. Although an embedded worksheet behaves as a picture in the document, when you double-click to modify it, Excel opens within MS Word, allowing you to use Excel's formulas to calculate results. One drawback to embedding an Excel worksheet is that it increases the file size ... (view more)

The Paste Special command can also be used to link an Excel worksheet. In contract to embedding, linking sets up a link between the worksheet cells in the document and the original Excel worksheet source. The MS Word document holds an image of the ... Excel worksheet and a shortcut to it but not an actual copy of the worksheet. Because of the link, any changes in the original are automatically reflected in the MS Word document. The advantage to linking the worksheet is that if the source worksheet in Excel changes, the values are automatically updated in the Word document. If you make a change in ... (view more)