PC help: Excel keyboard shortcut

Use a keyboard shortcut to replace AutoFill in Microsoft Excel

Written by Computeractive staff, Computeractive

Q I use Microsoft Excel for tracking household expenses and other sums, but I find that the little square at the bottom of each entry is sometimes difficult to make into a cross in order to drag it down to the next cell by clicking and dragging, so that I can see a running total.

If the cell used for the calculation of the current total is put either lower down the sheet, or in an adjoining column, by entering =sum(A22:A32) as an example, it works, but I wonder if there is a quick way of doing the calculation in the following cell without clicking and dragging the small cross?
Betty Cowen

A The keyboard can be used to replace AutoFill, when a formula is copied and uses data in cells relative to the original position. This is great for columns of rows of figures. Create the first formula and press Ctrl and C to copy it into the clipboard. Select the other cells by moving to the next cell, holding down Shift then moving to the last cell. This can either be a single row or column. Press Ctrl and V to copy the formula.

Advertisement

Tags:

Reader comments

More from Computeractive

News

The latest home computing news

Downloads

The best PC tools, applications and more

Reviews

Independent opinions on new hardware and software

Step-by-step guides

Easy-to-follow projects with pictures

PC Help

Solve PC problems with our Q&A

Videos

PC projects demonstrated and product reviews

Articles

An in-depth look at how to get the best from your PC

Magazine

What's coming up in Computeractive

Forums

Get help with your PC problems from our readers

Competitions

Your chance to win computing prizes

Shopping

Great deals on products, services and more

NEW! Computeractive CD Rom 11
All 26 issues of Computeractive from 2008 on one CD-Rom.

Ultimate Guide to Disc Burning
Everything you need to know about creating your own discs.

Create your own calendars softwareCreate your own Calendars
The fun and easy way to create your own calendars!

Computeractive - Issue 280Computeractive Back Issues
Missed an issue? Click here to find a back issue

Blogs

Windows Watch

Windows Watch

Keeping an eye on the latest XP and Vista news

Outlook 2007 email controversy

One of the major changes in Outlook 2007 had nothing to do with the Ribbon but that Word was used to display...

Download Junkie

Download Junkie

Your daily dose of download discussion

Backup important data with SyncBack SE

Keeping certain files backed up helps to keep items safe in case anything disastrous happens to your computer, but although most of...

Advertisement

Free email newsletters

Techno babble demystified...

[Display all definitions]

Or type in any computer-related word and click "Go"

Advertisement

Computeractive is not reponsible for content of Google adverts

Primary Navigation

© Incisive Media Ltd. 2009. Incisive Media Limited, Haymarket House, 28-29 Haymarket, London SW1Y 4RX, is a company registered in England and Wales with company registration number 04038503

Search computeractive.co.uk