Simple clear advice in plain English

PC help: Excel keyboard shortcut

Use a keyboard shortcut to replace AutoFill in Microsoft Excel

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.

Article tags

Reader Comments

   

Add your comment

All fields must be completed. Your email address will not be displayed or used to send marketing messages.

All messages will be checked by moderators before appearing on the site.

See our Privacy Policy for more information.

Related articles

Word's undo feature

How to fix common PC errors

It’s easy to hit the wrong key when using a PC and throw yourself into a panic. There's no need to worry - we have easy fixes for 30 common everyday errors

Excel worksheet error message screenshot

Why can’t I insert new rows and columns in Microsoft Excel?

A limit to the number or columns and rows in a spreadsheet causes problems

335-shortcuts-lead

Keyboard shortcuts made easy

Discover how keyboard shortcuts could speed things up – and print out our free guide to help you master some of the most common PC keyboard shortcuts

Question & Answer

Q.Why can't my browser find the website address I typed...

> Read the answer

Q.All updates have been downloaded, so why won't Windows...

> Read the answer

Q.How do I stop Windows 7 search?

> Read the answer

Best deals on the web

img

Apple MacBook Pro (MC724LL/A)

£999.99- Buy it now

img

Sony Vaio VPCF23P1E/B

£679.98- Buy it now

img

Samsung 300E5A-A01DX

£449.99- Buy it now

Great benefits for subscribers!

Poll

Which is your preferred web browser

Jargon Buster

Computing terms explained in plain English

Bittorrent

A technology for downloading files. Allows even very large files to be downloaded quickly.

Great shopping deals from Computeractive