# PCM Courseware Blog

Posted by Roger Hyttinen on

Microsoft Excel 2016 Level 3 is now available for download from the PCM Courseware library. You can preview the first three chapters of each course from our Microsoft Excel page. Microsoft OneNote 2016 is forthcoming.

## How to Move Rows Up and Down in a Word Table Using Your Keyboard

Posted by Roger Hyttinen on

If you have to rearrange rows in a table, there’s no need to cut and paste. You can quickly move rows up or down with a simple keyboard shortcut. To do so, follow these steps: Select the row or rows you want to move. Press the Shift + Alt + the up or down arrow key on your keyboard. The Shift + Alt + Up Arrow moves the row up by one row and the Shift + Alt + Down Arrow moves the row down. That’s it! This shortcut also works with paragraphs. Select the paragraph and press Shift +...

## How to join the contents of multiple cells in Excel

Posted by Roger Hyttinen on

Excel allows you to quickly combine (or concatenate) the contents of two or more cells into a new cell. There are two different methods for doing this: using an Ampersand or using the Concatenate function. Method 1: Combine Cells Using the Ampersand To combine the contents of two or more cells, separate each cell in the formula with an ampersand (&). For instance, if cell A1 contained the text John and cell B1 contained the text Smith, you can join them with the following formula: =A1&B1 However, the result will be: JohnSmith This is perhaps not quite what we want. The...

## Total Rows and Columns at the Same Time Using AutoSum

Posted by Roger Hyttinen on

Excel’s AutoSum button provides one-click access to several aggregrate functions: Sum, Average, Count Numbers, Max and Min. But you don’t have to total rows and columns separately - you can calculate them at the same time. To Total Adjacent Rows and Columns at the Same Time: Highlight the range you want to total. Be sure to include an extra row and column for the formulas. Click the arrow on the AutoSum button on the Home tab of the Ribbon or the Formulas tab of the Ribbon. Select the function you want from the drop-down list. Excel will enter in the...

## How to Prevent Word from Inserting Page Breaks within a Paragraph

Posted by Roger Hyttinen on

As type in Microsoft Word, you may notice that Word inserts an automatic page break within a paragraph as you near the bottom of the page. This may be fine in certain instances but sometimes, you might want to keep all of the text of a paragraph together on the same page, especially if the text is surrounded a border. To ensure that all of the sentences of your paragraph remain together, use the Keep Lines Together feature. To Prevent Word from Inserting Automatic Page Breaks Click the Home tab on the Ribbon. Click the Paragraph Dialog Launcher. Click the...