Selecting a column

To quickly select a column of data in a formatted table you have a couple of options.

Keyboard

Select a cell in the column and press Ctrl + Space Bar.

This will select the column of data. If you want the heading too, press it again.

You can also select multiple columns before using the shortcut.

Mouse

This technique can take practice if your headings are in row 1.

If the heading starts in row 2 or below it is easier. See image below.

If you point to just above the heading row you will see a downward facing, black arrow. Click this once to select just the data. Click it again to include the heading.

When the heading row is in row 1 you need to do the same but make sure the column letter doesn’t highlight.

The image below is the correct arrow – this will select the column in the table only.

In the image below the arrow shown (because the column letter is highlighted) will select the whole column, not just the data in the table.

Barking Up The Wrong Tree (2017)

Eric has blogged for many years and this book follows on from his blog.

His writing style is relaxed and it is an easy read.

A book that turns some common advice on its head and confirms others.

Lots of studies are examined some of them conflicting, so you may need to experiment yourself with some of the practical suggestions.

 

Tribe of Mentors (2017)

Another great book from Tim Ferriss.

This has lots of short advice about life from successful people from all walks of life.

Its a smorgasbord – you can open it randomly and learn something new.

It follows on from his podcast and the Tools of Titans – another great book.

Many of his podcast questions are answered by people who haven’t been on the podcast.

 

VBA If statement tip

When creating long VBA code it is common that the start of an If statement and the matching End If statement may not be visible on the same screen.

When scrolling around trying to understand your code it can be useful to include the If statement itself as a comment following on the same line as the End If command – see examples below.

If x=0 Then
 
  'lots of code
 
  If y =1 Then
 
    'lots of code
 
  End If   'If y =1 then
 
End If   'If x=0 Then

The apostrophe is used to specify the start of a comment – you can have a comment following a line of code.

This structure can assist when trying to identify which End If statement relates to which If statement.

Entering Date and Time in Excel

There are shortcuts to enter

  • the current Date Ctr + ;
  • the current Time Ctrl + Shift + :

There isn’t one to enter both.

You can use them in sequence to achieve a date and a time entry.

In sequence press

Ctrl + ;

Space bar

Ctrl + Shift + :

The space separates the date and time and Excel will recognise the entry as a date and time.