Heather's MS Office Blog

For Microsoft Office Excel 2007
Microsoft Office Excel 2007

Working with Large Formulas

With previous releases of Microsoft Office Excel, working within the formula bar at the top of the worksheet can be cumbersome, because although the formula bar expands when necessary, it often overlaps the sheet itself. To get around this in the 2007 Microsoft Office system, pause on the bottom of the formula bar, and then drag it to adjust it to any size you need. This adjustment gives you a larger working area and makes it easier to navigate a document sheet that has large formulas.

For Microsoft Office Excel 2007
Microsoft Office Excel 2007

Paste into Non-sequential Cells in Excel
You can use the CTRL key for multiple selections. Sometimes, you want to copy a formula or piece of data into a series of non-sequential cells in Microsoft Office Excel. You can do this quickly without having to paste into each cell individually.
1. Copy the data from the source cell.
2. Hold down the CTRL key as you click to select each destination cell.
3. After all the cells are highlighted, paste the data by pressing CTRL+V. You have to paste only once.

Similarly, you can type data into a series of cells simultaneously.
1. While holding down the CTRL key, click all the cells that you want to type the same text (or value) into.
2. Type the entry, and then press CTRL+ENTER. The text will be added to all the selected cells.

Rearrange Paragraphs in Word

Swapping paragraphs in Microsoft Office Word can be complicated. As well as having to cut and paste, you often have to reformat line breaks afterward to make the paragraph line up properly. Instead, you can use the SHIFT+ALT keyboard shortcut.

Click the paragraph that you want to move, hold down SHIFT+ALT, and move the paragraph up or down by using the arrow keys. Each press of an arrow key causes your selected paragraph to jump over one adjacent paragraph.

Welcome to our new blogs.

In the interest of communicating on the web, we have decided that we will get in on the action of blogging. However, we wish for this to be something other than just a 'me too' effort and really try to reach out with valid information, tips, tricks and perhaps even a little levity from time to time.

This particular area is dedicated to Microsoft's Office. I can answer questions from any edition you have. If I do not know the answer, I will research and get back with you. I am still learning Office 2007.

Please visit with us as we grow into this new type of media, and join in when you can.

Thanks for stopping by.

Ken and Heather Watson