Export a sheet as a PDF

It takes a few clicks but it is possible

I have previously posted about using CutePDF to create pdfs from Excel sheets. There is another way, but it takes a few clicks and it only works in Excel 2010 and later versions. (It may work in Excel 2007 but I have taken that version off my PC so I can’t test it.)

Relationships Shortcut

Excel 2013 added the Data Model to Excel.

The Relationships option (Data ribbon) is part of that model. It allows you to create relationships between tables so that you can use a PivotTable to report on multiple tables.

See my December 2016 INTHEBLACK article for an example.

The keyboard shortcut to create or edit, a Relationship is easy to remember – it is

Alt a a

Pressed in sequence, not held down.

Day Of The Week

A quick and easy way to find out the day of the week for a specific date is to use the Long Date format from the drop down in the middle of the Home ribbon (in the Number section) – see below.

DayofWeek

Clearing the tab colour

I use colours on my sheet tabs to signify different things.

To clear a colour, you can use the following keyboard shortcut

Alt h o t n

Pressed in sequence, not held down.

 

Flash Fill Keyboard Shortcut

To apply the new Excel 2013 feature Flash Fill with the keyboard. First enter your values that define the rule. Then select the range to fill and then press in sequence (not held down)

Alt a f f

More about Flash Fill here