Excel Stuff to Remember

Excel stuff I can never remember and I'm tired of looking up all the time

•  Use $ to lock a cell location when it's dragged down 

Find Disabled Computers in AD

 

1. Open the Active Directory Users and Computers snap-in.
2. In the left pane, connect to the domain you want to query.
3. Right-click on the domain and select Find.
4. Beside Find, select Common Queries.
5. Check the box beside “disabled accounts.”
6. Click the Find Now button.

Move a window opening on a non-existent screen

 

1. In Windows 10, 8, 7, and Vista, hold down the “Shift” key while right-clicking the program in the taskbar, then select “Move“. In Windows XP, right-click the item in the task-bar and select “Move“. ...
2. Use your mouse or the arrow keys on your keyboard to move the window back onto the screen.

Creating an Admin Shortcut

 More exact details to follow...

CD C:\ 

CD Progra~2 

CD MICROS~4 

CD ADMINC~1 

CD bin 

start micros~1.exe 

 C:\Windows\System32\runas.exe /user:{domain}\{user} /savecreds 

"C:\AdminShortcut\RemoteControl.bat"

Find Short File Name

 When you need to find the short file name for a file, navigate to the folder in CMD and run dir /x

Find Office 2013 Microsoft Account for retail key

HKCU/Software/Microsoft/Office/15.0/Common/Identity/Identities/

Unread Mail folder under Favorites in Outlook

I got really used to having quick access to my unread messages using the Unread Mail favorites folder.

Every time I have a new account using Outlook, I always forget to add it back, since it's not done automagically anymore. Once I remember I want it back, I have to look up how to do it!

Sad thing is it's pretty easy.

At the bottom of the list of folders in your account, there's a Search Folder.

Right click Search Folders, and click on New Search Folder.

Make sure Unread mail is selected in the Search Folder box and click OK.

The folder will appear on Search Folders, and then you can right click it and select Show in Favorites. Now you can find the email you left unread so you can deal with it later.... about a week ago. :)