Goal Seek

The Goal Seek feature can save you a lot of trial and error when you want a calculated cell to equal a specific value.

The keyboard shortcut to open the Goal Seek dialog is Alt T G.

Related Posts

Shortcut to lock or unlock a cell

The keyboard shortcut to unlock or lock a cell or a range (its a toggle, so it switches between the two) is Alt H O L pressed in sequence, not held down.

Related Posts

 

Windows Clipboard

Did you know you can accumulate copied entries in the Windows clipboard?

The default setting is to only have the last thing you copied, but a setting change can give you access to multiple items to paste.

You can also pin items to the clipboard to keep them there.

To change the setting.

Click the Windows button and choose the Settings icon

The select System.

Then select Clipboard (bottom left) and change the Clipboard History to On – done.

 

If you copy multiple items you can press the Windows key and V to access what’s on the clipboard.

Then you can click the top right elipse icon to Pin the item to the clipboard.

Related Posts

Nothing in life is to be feared, it is only to be understood. Now is the time to understand more, so that we may fear less.

Marie Curie (1867 – 1934)