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
Related articles
Q.Why can't my browser find the website address I typed...
Q.All updates have been downloaded, so why won't Windows...
Q.How do I stop Windows 7 search?
Need more power than from a tablet computer?
A technology for downloading files. Allows even very large files to be downloaded quickly.
|
|
|
|
|
Nikon Coolpix S570 BlackPrice: £66.99 |
Computeractive Ultimate Guide - Storage, Sharing & BackupPrice: £5.99 |
Back Issue CD-Rom 13 (2010)Price: £9.99 |
Hallmark Card Studio DeluxePrice: £15.31 |
Marine AquariumPrice: £15.41 |