Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using CTRL to select cells for a formula
Hi -
I tried to search for help on this one before posting - but wasn't sure how to search for my answer if that makes sense. Essentially - I work with a very manual spreadsheet with a lot of various data for project reporting. (Forecasts, Actuals, EAC, Variance etc.) Due to the format / layout of the worksheet - I often need to use 'ctrl' to select the cells I want to include in a formula. IE: =sum(f1, f3, f33, f35) etc. Is it possible to back into a formula like that? IE: I click CTRL and select the various cells I want to total and I can see that # in the status bar at the bottom of the screen. Is there a way to copy those cells into a formula? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can you select visible cells only by default, without Ctrl+G. | Excel Discussion (Misc queries) | |||
CTRL+select Excel 2007 | Excel Worksheet Functions | |||
does ctrl f select cells randomly? | Excel Discussion (Misc queries) | |||
ctrl select not working in 07 | Excel Discussion (Misc queries) | |||
Ctrl Key to Select Cells | Excel Discussion (Misc queries) |