Cannot drag and drop mail items in Outlook


This functionality was working but stopped. I can move by right clicking the mail item and selecting Move and then selecting my archive folder.

After a bit of research all you need to do is press the Esc key a couple of times and the drag and drop functionality returns!

Advertisements

How to convert a row into a column or a column into a row in Excel


  • Select all the cells in the columns or row that you wish to convert including column/row headings if applicable. Right click then and select Copy
  • Right click in the cell where you wish to put the data and select Paste Special
  • Tick the box at the bottom labelled Transpose and click OK
  • Your data should now be in the opposite format

Microsoft Outlook – Reported error (0x8004010F) : ‘Outlook data file cannot be accessed.’


After you have moved an Outlook account and associated .pst file to a different location or PC you may receive this error after you try to Send/Receive mail.

I found that the problem was caused by the expected delivery locations for the send/receive process.

I found that by changing the folder to specify a different inbox, applying and then selecting the correct inbox and applying fixed the issue.

– In Outlook 2010 click File>Account Settings>Account Settings

– Select the relevant account and click Change Folder

– Select a different location and apply

– Select Change Folder and select the correct Inbox location

The send/receive process should now work

 

How to easily remove all blank rows within a defined range in an Excel 2010 spreadsheet


I came across this problem whilst importing a large amount of data that contained two blank rows for every row that contained data.

First select your data that contains the blank rows

image001

Then click on the Home tab and select Find & Select. Now select Go To Special

image002

In the Go To Special dialogue box select Blanks and OK

image003

This should highlight the blank rows within your selected range

image004

Click on the Home tab again. Select Delete and Delete Sheet Rows

image005

This removes the blank rows and maintains any formulas

image006

How to rotate a text box in Word 2007 and 2010


I wanted to create a birthday card in Word and in order to print correctly I needed to rotate a text box 90 degrees anti clockwise containing the greeting.

After a lot of searching I concluded that it’s not possible to rotate a text box unless you copy it and paste it into a new document as an image. Then you can rotate the image. Trouble with that is that there is significant loss in the quality of the graphics which makes for poor printing.

Anyway, silly me the answer was there all along – you can’t rotate a text box but you can rotate the text inside the text box!

  • Double click the text box to select it and open the Format tab
  • On the Format tab, in the Text group select Text DirectionText Direction. Clicking Text Direction multiple times will cycle through the three options

 

 

You receive the message ‘Protected View – This file originated from an Internet location and might be unsafe. Click for more details’ when accessing an Office 2010 application


You receive the message ‘Protected View – This file originated from an Internet location and might be unsafe. Click for more details’ when accessing an Office 2010 application

image001

Protected View is a new security feature in Microsoft Office 2010. It activates when you attempt to open a file downloaded from the Internet of files that are from a source that fails validation.

A drawback here is that it seems to fail validation on files with legacy file extensions and so .xls and .doc fall foul of the validation process.

If you are working in an environment considered safe this feature may become a hindrance.

How to turn off and disable Protected View

Open the application that you wish to disable the Protected View option in and select File then Options

image002

Select Trust Center and then the Trust Center Settings button

image003

Select the Protected View option and in the right hand pane disable the options:

· Enable Protected View for files originating from the Internet

· Enable Protected View for files located in potentially unsafe locations

· Enable Protected View for Outlook attachments

image004

Click OK to come all the way out

Unfortunately you will have to repeat this process for each Office 2010 application that has the Protected View option implemented.

Excel 2010 – How to open numerous spreadsheets in their own separate windows?


Unlike earlier versions of Excel, Excel 2010 opens each spreadsheet within a parent Excel window rather than opening a separate Excel window per spreadsheet. This is a problem if you need to compare two spreadsheets across two monitors.

There is a workaround – simply opening a new instance of Excel and then using File and Open to locate the spreadsheet to open, but this is time consuming and frustrating if you are working on a large number of spreadsheets at any one time.

After a little searching I found a really good fix that just involves some minor changes to the registry.

· Open a registry editor like regedit. Start > Run > regedit

· Locate the following key HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/command

o In the right hand pane right click on (Default) and change

“C:\Program Files\Microsoft Office\Office14\EXCEL.EXE” /dde

to

“C:\Program Files\Microsoft Office\Office14\EXCEL.EXE” /e “%1”

image001

image002

o In the right hand pane right click on command and select rename

It can be renamed to anything so that it will be ignored. I renamed to commandold

· Locate the following key HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/ddeexec

o Select the ddeexec folder, right click on command and select rename

o It can be renamed to anything so that it will be ignored. I renamed to ddeexecold

image003

· Locate the following key HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/command

o In the right hand pane right click on (Default) and change

“C:\Program Files\Microsoft Office\Office14\EXCEL.EXE” /dde

to

“C:\Program Files\Microsoft Office\Office14\EXCEL.EXE” /e “%1”

· In the right hand pane right click on command and select rename

It can be renamed to anything so that it will be ignored. I renamed to commandold

image004

Close regedit and try to open two different spreadsheets – they should each open in their own instance of Excel!

When attempting to dismiss a reminder Microsoft Outlook errors with the message ‘Cannot turn off the reminder. You may be reminded again. The folder is full’


image001

This occurred after upgrading an Outlook installation from Outlook 2007 to 2010 using an existing Outlook data file.

I resolved this by closing Outlook and launching Outlook.exe from the command line with the “cleanreminders” argument:

C:’Program Files’Microsoft Office’Office14’OUTLOOK.EXE /cleanreminders

Note: Office14 in this case links to Office 2010. The Office iteration is different by version.

Unable to change the cell shading in a spreadsheet using Excel 2007


When I tried to change the cell fill in one of my spreadsheets the new shading wasn’t applied.

I found that the cells were actually conditionally formatted and had to remove this formatting restriction.

1. Select the cells that you wish to change

2. Select Home > Styles > Conditional Formatting

3. Select Clear Rules and Clear Rules from Selected Cells

image001