Microsoft Project Keyboard Shortcuts

SkillForge SkillSheet Microsoft Project 2010/13/16 Keyboard Shortcuts Click here to download the PDF version. Navigate Views and Windows In order to… Press Activate the Control menu ALT+SPACEBAR Activate the entry bar to edit text in a field F2 Activate the menu bar F10 or ALT …

QlikView–Moving the “Unmovable” Object

QlikView is without a doubt one of my most favorite programs to teach. The capabilities for modeling and visualizing data are just amazing. But for all of QlikView’s shine and wonder, it’s not without its shortcomings. I really shouldn’t say “shortcomings”, but there are a few areas that could use a bit of improvement. Take, for instance, moving objects around the report space.

Normally, an object possesses a title bar (or “caption”, as QlikView likes to call it) and you can simply click and hold the caption bar and move the object. The problem arises when a designer hides the caption bar (and to a lesser extent the border), leaving the report viewer with what appears to be no way to grab and move the object.

Instead of temporarily turning the caption and borders back on just to make a simple adjustment and then turning them back off again, you can place the mouse pointer over the object and hold down the ALT key on the keyboard. This will activate the MOVE feature where you can now relocate the object quickly and effectively.

Gauge

12 Excel Keyboard Shortcuts for Every User

Keyboard shortcuts are a great way to improve the speed at which documents are built, regardless of the application. It seems like there is a keyboard shortcut for just about every feature Excel contains; and there may be that one guru in the office that knows them all. But most of us fall somewhere between Guru and Labrador retriever (hopefully, closer to the former.)

The good news is that it’s not an “all or nothing” proposition when it comes to keyboard shortcuts. Knowing just a few of the most productive keyboard shortcuts will serve you far better than knowing none at all.

So let’s get this show on the road!

CTRL+SHIFT+L – Turn On/Off Filter Controls

Filters are of tremendous use when analyzing large numbers of records in a table, but you are only interested in a select set of records that met a specific criteria. Activating your filters is just a CTRL-SHIFT-L away. This keyboard can also be used to turn off all of the filters and display the entire list. (Filters are on by default when you convert a straight table to a Data Table, and not always desired.) Finally, if you hit the “L” key twice (CTRL-SHIFT-L & L) you can effectively clear the current filters to start fresh with a new filter query.

Script Editor

<F5> or <Ctrl> + R
- Runs load script
<CTRL> + <Shift> + R
- Partial reload
<Ctrl> + T
- Shows model diagram
<Ctrl> + E
- Opens table editor for LOAD INLINE statements (cursor should be placed inside statement)
<Ctrl> + Q + Q
- Inserts script that generates several dummy tables
<Ctrl> + K + C
- Comments blocks of script
<Ctrl> + K + U
- Uncomments blocks of script
<Ctrl> + F
- Allows search within the script in the debugger window