Skip to content

Total Columns and Rows Using Keyboard

by Lynne on November 10th, 2010

There are several ways in which you can add up columns or rows of figures in Excel, but as long as there are no spaces in your columns or rows of figures the fastest way to do this is using your keyboard

Put cursor in the space to receive the total and press Alt =

It will highlight the range

Training Excel Screen Shot

If this is correct, Press Enter

You will now see your answer in the cell

One Comment
  1. Richard Leonard permalink

    This is a great tip Lynne, thanks for sharing

Comments are closed.