Repeat with F4

To repeat the last action you have performed on any range, or cell, you can press the F4 function key.

Not all actions can be repeated, but most can.

If you have recently performed two actions only the last one will be repeated.

Convert to a Number

Numbers formatted as text (often imported from other systems) can cause issues in Excel. To convert a number formatted as text into a real number that can be used in calculations use a formula like.


This will convert a number formatted as text in A1 into a real number. NOTE: it it will return an error if the value cannot be converted into a number.

Not everything that can be counted counts, and not everything that counts can be counted.

William Bruce Cameron

Populate a Range

To populate a range with the same entry you first select the range then use

Ctrl + Enter

This is handy for entering zeroes in input ranges. It can also be used to enter a formula in a range.

Arrange Windows Tiled

To arrange multiple windows in the current file in a tiled layout use

Alt w a Enter

Pressed in sequence , not held down.

New Window

To open a new window for the current file, which allows you to resize and see two separate views of the the same file use

Alt w n

Pressed in sequence, not held down.

Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away.

Antoine de Saint-Exupery (1900-1944)

Take the attitude of a student. Never be too big to ask questions. Never know too much to learn something new.

Og Mandino (1923 – 1996)