Latest Entries »


Untitled


Microsoft Word has been able to publish content to blog platforms since Office 2007. The feature is still available and has matured to a point where it gives Windows Live Writer a run for its money. Here is how to get set up.

How to Create a Blog Post in Office 2013

When you launch Word, you should see a Blog post template somewhere near the top of the screen. This is the template that is going to allow us to post the content we create to our blog. So go ahead and double click on it.


The first time you use the template, you are going to need to set up a blog account so that Word knows where and how to post your content. This is very important because different blogs platforms require the information to be formatted differently.


Word supports a surprising number of platforms out of the box. How-To Geek is run on WordPress, so we will choose that, but feel free to pick the platform that your blog is running on, then click next.


You will most likely have to enter some kind of URL so that Word knows where to post your content, but we also want it to remember our username and password so we opted to check the “Remember me” checkbox.

At Hack Zone, we initially publish everything as a draft so that it can be edited and proof read. To send the current post to draft, click on the publish drop down and select Publish as Draft. Alternatively, you can just click on Publish if you want the post to go live immediately.


ximg_51f6504ea4f76.png.pagespeed.ic.A-dKumMDHV

We recently showed you that you could use Microsoft Word as a blog post editor and the feature was really well received. We are back with this byte size tip to show you how you can quickly add screenshots to your posts.

Use Microsoft Word To Take Screenshots

Taking a screenshot in Word is really a painless experience. Simply switch over to the Insert tab and click on the Screenshot button. You will be greeted with a thumbnail image of every Window you have open at the moment. You can simply click on one of the thumbnail and it will be inserted into the current document.

image

Taking a decent screenshot of a particular Window has never been easier.

image

If you want to capture a specific area on the screen you can opt to go for the more precise, Screen Clipping option instead of clicking on a thumbnail.

image

Once you have selected the area on the screen you want to capture, it will be added to your document automatically.

image


00_lead_image_using_transpose

You’ve setup your worksheet with all your row and column headings and you’ve entered all your data. Then, you discover that it would look better if the rows were the columns and the columns were the rows. How do you accomplish this easily?

There is an easy way to convert your rows to columns and vice versa using the Transpose feature in Excel. We’ll show you how.

Select the cells containing the headings and data you want to transpose.

01_selecting_cells_to_transpose

Click Copy or press Ctrl + C.

02_clicking_copy

Click in a blank cell on the spreadsheet. This cell will be the top, left corner of the new table of data.

03_clicking_in_new_cell

Click the down arrow on the Paste button and select Paste Special from the drop-down menu.

04_selecting_paste_special

On the Paste Special dialog box, select the Transpose check box so there is a check mark in the box and click OK.

05_selecting_transpose

The rows become the columns and the columns become the rows. The original set of data still exists. You can select those cells and delete the headings and data, if desired.

06_transposed_cells

Isn’t that a lot easier and faster than retyping all your data?


00_lead_image_cell_and_formula

If you are working on an Excel worksheet with a lot of formulas in it, it may become difficult to follow and keep track of all your formulas. Excel provides a simple way of displaying formulas in the cells in addition to the formula bar.

This feature also displays the dependencies for each formula in the cells (when selected), so you can track the data being used in each calculation. Displaying formulas in cells helps you to find cells containing formulas and to quickly read through all your formulas and check for errors. You can also print the spreadsheet with the formulas in the cells to help check your work.

To display formulas in cells containing them, press the Ctrl + ` (the grave accent key). The formulas in each cell display as shown in the image above. The cells involved in the calculation are bordered in colors that match the cell references in the formula to help you track the data.

You can also click Show Formulas in the Formula Auditing section of the Formulas tab to display formulas in the cells.

02_clicking_show_formulas

Even if you don’t show formulas in the cells, when you click on a cell containing a formula, the formula displays in the formula bar. If you don’t want the formulas visible to users of your spreadsheet, you can hide them and protect the sheet. To do this, select the cells whose formulas you want to hide.

03_selecting_cells

In the Cells section of the Home tab, click Format and select Format Cells from the drop-down menu.

04_selecting_format_cells

The Format Cells dialog box displays. On the Protection tab, select the Hidden check box. Click OK.

05_selecting_hidden

To finish hiding the formulas, you must protect the sheet. Click Format in the Cells section of the Home tab again. This time, select Protect Sheet from the drop-down menu.

06_selecting_protect_sheet

On the Protect Sheet dialog box, make sure the Protect worksheet and contents of locked cells check box is selected. Enter a password in the Password to unprotect sheet edit box that will allow you to unprotect the sheet and show the formulas again. In the Allow all users of this worksheet to list box, select the check boxes for the tasks you want to allow the users to perform. Click OK.

07_protect_sheet_dialog

Enter your password again in the Reenter password to proceed edit box on the Confirm Password dialog box and click OK.

08_confirm_password_dialog

Now, you’ll notice that when you select a cell containing a formula, the formula bar is empty.

09_no_formula_showing

To show the formulas in the formula bar again, click Format in the Cells section of the Home tab and select Unprotect Sheet from the drop-down menu.

10_selecting_unprotect_sheet

Enter your password on the Unprotect Sheet dialog box and click OK.

11_unprotect_sheet_dialog

All your formulas will be visible again when those cells are selected in the worksheet.