Pasting Functions

**pickel182** · 08-21-2008, 12:14 PM

this is either a really easy question or not possible...im making a price guide it is set up with each different item on top of each other and sizes going off to the right...i have the rows set up to add together all of the sizes for a total count...what im wondering is if there is an easier way to do the formulas, basically im looking to copy paste the formula somehow because they are all essentially the exact same formula...except different cells..any help on this is greatly appreciated thanks a lot

**shg** · 08-21-2008, 12:16 PM

Please read the Forum Rules about thread titles, and then edit yours to be descriptive of your problem.

**pickel182** · 08-21-2008, 01:21 PM

sorry for not reading ill be good from now on

**shg** · 08-21-2008, 01:30 PM

You can select the cell with the prototype formula and grab the little square at the bottom right (called the fill handle), and drag it in whatever direction you need.

If that doesn't work, post a workbook and explain in context.

**pickel182** · 08-21-2008, 01:42 PM

i have already finished this one im just looking to learn all the little shortcuts lol...you can see im adding all values from d4 to l4...im basically wondering if there would be any way to just highlight the whole group(from d4 to l39) and get each row to individually apply the formula thanks once again for all your help

**shg** · 08-21-2008, 01:47 PM

So you can enter the formula once and drag it down. Or select all the cells where you want to enter the same formula, type it into the formula bar, hold down the Ctrl key, and then hit Enter.

See Help for Keyboard Shortcuts.