Sep 15, 20090

Getting To Grips With The Paste Special Command In Excel 2007

Categories: Microsoft

Each time that you use the Copy and Paste commands in Microsoft Excel, it is not just the cell data that is copied; the formatting, style and number formats are also copied. The Paste Special command allows you to be selective about what you are pasting. The Paste Special command can be used to import elements from other programs into Excel using Windows Object Linking and Embedding. When doing so, the option “Paste Link” can be used to create a link to the original data rather than pasting in a copy of it.

Each time that you use the Copy and Paste commands in Microsoft Excel, it is not just the cell data that is copied; the formatting, style and number formats are also copied. The Paste Special command allows you to be selective about what you are pasting. The Paste Special command can be used to import elements from other programs into Excel using Windows Object Linking and Embedding. When doing so, the option "Paste Link" can be used to create a link to ... Read More

Sep 6, 20090

Determining How Text Sits Within Cells In Microsoft Excel

Categories: Microsoft

Microsoft Excel is not a word processor, so we don’t expect too much of it in terms of text alignment. However, the program contains a surprising number of options for controlling the way in which data is displayed within a cell.

Microsoft Excel is not a word processor, so we don't expect too much of it in terms of text alignment. However, the program contains a surprising number of options for controlling the way in which data is displayed within a cell. The alignment section of the Home Tab of the Excel ribbon contains a number of options relating to the way in which your data is position within the cell. Perhaps the most familiar and the most frequently used buttons in this ... Read More