How to Total Rows and Columns in Microsoft Word

Word logo

If you need to total values in a Word table, you can do so without breaking out the calculator or entering the data into Excel and then copying it back. Word can do simple calculations such as summing, multiplying, and averaging.

Let’s say you have a table something like the following. You have the units sold and the per unit cost, and you want to multiply those to get a total.

table of sales figures in word

Start by placing your insertion point into the blank top cell in the “Total” column.

Next, switch to the new “Layout” tab that appears toward the right end of the Ribbon (there’s a separate Layout tab just for tables) and then click the “Formula” button.

click the formula button on the layout tab

 

In this example, we are going to multiply the value in the “Units” column by the value in the “Unit Cost” column. To do this, type the following into the “Formula” field to multiply the values in the two cells to the left of the current cell:

=PRODUCT(LEFT)

Read the remaining 23 paragraphs

How to Protect Workbooks, Worksheets, and Cells From Editing in Microsoft Excel

excel logo

You’ve worked hard on your spreadsheet. You don’t want anyone to mess it up. Fortunately, Excel provides some pretty good tools for preventing people from editing various parts of a workbook.

Protection in Excel is password-based and happens at three different levels.

  • Workbook: You have a few options for protecting a workbook. You can encrypt it with a password to limit who can even open it. You can make the file open as read-only by default so that people have to opt into editing it. And you protect the structure of a workbook so that anyone can open it, but they need a password to rearrange, rename, delete, or create new worksheets.
  • Worksheet: You can protect the data on individual worksheets from being changed.
  • Cell: You can also protect just specific cells on a worksheet from being changed. Technically this method involves protecting a worksheet and then allowing certain cells to be exempt from that protection.

You can even combine the protection of those different levels for different effects.

Protect an Entire Workbook from Editing

You have three choices when it comes to protecting an entire Excel workbook: encrypt the workbook with a password, make the workbook read-only, or protect just the structure of a workbook.

Encrypt a Workbook with a Password

For the best protection, you can encrypt the file with a password. Whenever someone tries to open the document, Excel prompts them for a password first.

To set it up, open your Excel file and head to the File menu. You’ll see the “Info” category by default. Click the “Protect Workbook” button and then choose “Encrypt with Password” from the dropdown menu.

click protect workbook and choose the encrypt with password command

In the Encrypt Document window that opens, type your password and then click “OK.”

Read the remaining 64 paragraphs

How to Print in Word to Leave Room for a Hole Punch

Hole punches are great for inserting your printed documents into a binder neatly. Hole punches are not, unfortunately, so great when they accidentally cut off different words throughout your work. You can easily adjust your Word document’s margins to make room when using a hole punch or printing to pre-punched paper.

To leave room for a hole punch, you’ll need to adjust the layout of your document. It’s better to do so ahead of time so you can see how moving the margins affects the layout of your document.

To know how large to make the margins, consider the size of your hole punch or pre-punched paper. Most hole punches (whether you’re punching two holes at the top or three holes on the side of the page) punch about 0.5 inches from the edge of the paper. We recommend measuring your punch or paper to make sure and maybe even making the margins just a bit bigger. If your punch does measure out at 0.5 inches, for example, you might want to make your margins 0.75″ to be on the safe side.

Once you know how big to make your margins, head to the “Layout” tab in Word and click the “Margins” button.

You’ll only need to adjust margins on one side of the paper for a hole puncher, so go ahead and click the “Custom Margins” command on the drop-down menu.

You’ll want to change the margins on the side that you want to hole punch. If you’re adding hole punches to the top of your document, for example, you’ll add your measurement to the “Top” margin. If you’re putting them on the left, you’ll add it to the “Left” margin.

Read the remaining 6 paragraphs

How to Change a Picture From Color to Black & White in PowerPoint

Microsoft PowerPoint has several simple color adjustment options so that you can quickly and easily style the images in your PowerPoint presentation. Whether you want to create an artistic masterpiece or simply get your document to match your printer’s settings, you can change your images to black and white in PowerPoint

How to Change a Picture to Black & White in Microsoft PowerPoint

Changing your picture to black and white in Microsoft PowerPoint is easy! The color adjustment only affects the picture inserted into your document (and it’s reversible at that); it has no effect on the original file.

First, click to select the image in your document.

Switch to the “Format” tab on the Ribbon.

Click the “Color” button.

Read the remaining 11 paragraphs

How to Use Watermarks in a Microsoft Word Document

A watermark is a faded background image that displays behind the text in a document. You can use them to indicate a document’s state (confidential, draft, etc.), add a subtle company logo, or even for a bit of artistic flair. Here’s how to add and manipulate watermarks to your Word document.

How to Insert a Built-In Watermark

With your document open, switch over to the “Design” tab.

In the Page Background group on that tab, click the “Watermark” button.

On the drop-down menu, click any of the built-in watermarks to insert it into your document.

Word places the watermark behind the text.

Read the remaining 27 paragraphs