Change the Windows 7 Login Screen Background Image

When you login to your Windows 7 computer (assuming you haven’t used something like this tutorial to turn on automatic login), you’ll generally see a login window with a background looking something like this.

It’s fine; there’s nothing wrong with it. But sometimes a change is good so in this article we’ll show you how to change the background image behind the login screen to anything you want.
The first step is to open up the Start Menu by clicking the orb in the lower left corner of the screen.

Now, in the Start Menu search box, type regedit, to open up the Registry Editor.

When the Registry Editor appears in the Start Menu, click the Enter key to launch it. You should see a window like this.

Now, right-click on the HKEY_LOCAL_MACHINE folder, and choose the Find option.

The search window will appear so perform a search for OEMBackground.

It will eventually be found under Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Authentication\LogonUI\Background (you could navigate there directly, but the search function is probably quicker than typing all that into the path bar.

Note: it’s possible that OEMBackground doesn’t exist on your system; if this is the case, adding a new DWORD value with the name of OEMBackground will fix things.
Once you can see the OEMBackground entry, double click to reveal its properties, and change the value from 0 (the default) to 1 (which will allow us – or the computer’s OEM as intended – to change the login screen background).

Once this is finished you can close the Registry Editor and open up Windows Explorer. We want to go to %windir%\system32\oobe, so enter that into the path bar.

You’ll now need to create an info folder (all lowercase), and then a new folder, named backgrounds (also lowercase), inside the info folder. Depending on your computer’s OEM, you may find these folders already exist and may already have images in them, placed there by Dell or HP or IBM, etc.

Now simply select a favorite wallpaper. It should be in JPG format and less than 245 KB in size (and ideally the exact dimensions of your display to avoid stretching). Name this image backgroundDefault.jpg and place it in the backgrounds folder.

You can now restart, lock your screen or logout to see your new login screen.

How can I find unread emails in Gmail?

Search for;

label:unread

OR

is:unread

in your Gmail search box.

Other Gmail search operators can be found here;

Rotate data by converting columns to rows

Say you have a column of text:

Dairy

Meat

Beverages

Produce

That you want to change into a row, like so:

Dairy

Meat

Beverages

Produce

Or maybe you have a row of data that you want to change into a column.
Moving the data manually, one item at a time, would be a tedious process. To save time, you can use the Paste Special command to quickly transpose a column of data to a row of data, or vice versa.

Move data between rows and columns

1. Copy the data in one or more columns or rows.
2. Before you paste the copied data, right-click your first destination cell (the first cell of the row or column into which you want to paste your data), and then click Paste Special.
3. In the Paste Special dialog box, select Transpose, and then click OK.

You'll find theTranspose check box in the lower-right corner of the dialog box: 

 

Starting with your first cell, Excel pastes the data into a row or column.

 Notes 

• Columns and rows can not overlap. For example, if you select values in Column C, and try to paste them into a row that overlaps Column C, Excel displays an error message. When you go to paste a column or row, the destination area must be outside of the original values.
• If you copy and paste data from more than one column, Excel places the data from the leftmost column on top. For example, say you copy data from columns A and B of a worksheet, and you paste the data into another worksheet starting at row 1. Excel places the data from column A in row 1, column B in row 2, and so on.
• If you don't see the Paste Special command, make sure you right-click the first destination cell. You'll also find the command on the Edit menu. If you still don't see the command, make sure you're using Excel 2000 or later.