31 March 2009
Using Microsoft Excel 2007's Freeze Panes Command
by 1 otherMany of the worksheets that are created Excel contain headings in the top row of the sheet. Normally, when we scroll down the sheet, any headings at the top will disappear. Similarly, if we scroll to the right, any headings on the left will disappear. ...
19 March 2009
Excel 2007 Selection Techniques
by 1 otherIn this article, we will look at Excel selection techniques which involve using the mouse in conjunction with the keyboard. One of the easiest and most useful is click followed by Shift-click. This is particularly handy for highlighting large ranges of...
24 February 2009
Changing Formats In The Same Cell In Microsoft Excel
by 1 otherWhen formatting text within an Excel worksheet, you have the choice of working at the cell level or at the text level. If you wish to work at the cell level you simply highlight one or more cells and choose your format settings. Any formatting that you...
23 February 2009
Two Methods Of Concatenating Data In Microsoft Excel
by 1 otherConcatenation is the simply the process of stringing together different pieces of information to form a new piece of data. For example, if say we have columns containing people's title and first name and another containing their last name, we might use...
19 February 2009
Microsoft Excel 2007 Text Alignment Options
by 1 otherThe alignment section of the Home Tab of the Excel 2007 ribbon is home to a number of options relating to the way in which your data is position within the cell. The most familiar and most frequently used icons in this section are the three relating to...
1
(5 marks)
