Shortcut to lock or unlock a cell

The keyboard shortcut to unlock or lock a cell (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)

Export as PDF

If you frequently export files as pdfs then this keyboard shortcut may save you a little time.

Pressed in sequence, not held down use

Alt F E A

Related Posts

Restart a Pivot Table in one go

If you want to clear all the fields from a Pivot Table you can use the clear all option.

On the PivotTable Analyze or Analyze tab click the Clear drop down and select Clear All.

 

This removes all the fields and allows you to start again from scratch.

Financial Modelling with Scenarios

A great webinar recording from Danielle Stein Fairhurst from Plum Solutions and Thomas Paul from BDO.

A flexible technique to handle lots of different variables in a model using data tables.

Macro question – Slicer solution

Slicers are a very flexible filtering option and can control multiple pivots – even power pivots!

Always happy to help.