Windows 8 Keyboard Shortcuts

Here are some Windows 8 keyboard shortcuts from the MSDN blog.

· Windows key – Brings up the Metro start screen. You can start typing to search for an app, just like the Win7 start menu.

· Win + B – Switch to the (classic) Windows desktop and select the tray notification area.

· Win + C – Brings up the Charms menu, where you can search, share, and change settings.

· Win + D – Brings up the old Windows desktop.

· Win + E – Launch Windows Explorer with Computer view displayed.

· Win + F – Brings up the Metro File search screen.

· Win + H – Opens the Metro Share panel.

· Win + I – Opens the Settings panel, where you can change settings for the current app, change volume, wireless networks, shut down, or adjust the brightness.

· Win + J – Switches focus between snapped Metro applications.

· Win + K – Opens the Devices panel (for connecting to a projector or some other device)

· Win + L – Lock PC and return to Lock screen.

· Win + M – Minimize all Windows on the desktop

· Win + O – Locks device orientation.

· Win + P – Choose between available displays.

· Win + Q – Brings up the Metro App Search screen.

· Win + R – Switch to the (classic) Windows desktop and display the Run box.

· Win + U – Switch to the (classic) Windows desktop and launch the Ease of Access Center.

· Win + V – Cycles through toasts.

· Win + W – Brings up the Metro Settings search screen.

· Win + X – Launch Start Menu.

· Win + Y – Temporarily peek at the desktop.

· Win + Z – Opens the App Bar for the current Metro application.

· Win + Page Up / Down – Moves tiles to the left / right.

· Win + Tab – Opens the Metro application switcher menu, switches between applications.

· Win + , (comma) – Aero Peek at the desktop.

· Win + . (period) – Snaps the current Metro application to one side of the screen. (Right side)

· Win + Shift + . (period) – Snaps the current Metro application to the other side of the screen. (Left side)

· Win + Space – Switch input language and keyboard layout.

· Win + Shift + V – Cycles through toasts in reverse order.

· Win + Enter – Launches Narrator

· Win + Arrow Keys – Switch to the (classic) Windows desktop and enable Aero Snap

Copy Excel fields without changing formula

I had a row of formulas I wanted to copy to a separate row but retain the formulas as they were.
Excel wanted to change the formulas and update the cell references.
To keep it from doing this add a $ before the row and column reference.

So if a formula was =’4Q2011′!N6 meaning get the value from the 4Q2011 worksheet cell N6.
Make the formula =’4Q2011′!$N$6

This way when you copy it the formula will stay the same instead of what it was doing which was changing it to =’4Q2011′!N7

 

James and the Giant Peach

James and the Giant Peach production.

Enjoying a production of James and the Giant Peach the my daughter was in.

  • Camera: SGH-i937
  • Taken: 26 February, 2012
  • Aperture: ƒ/2.65
  • Focal length: 4.03mm
  • ISO: 125
  • Shutter speed: 1/15s
  • Title: ???????????????????