LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 24
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can you select visible cells only by default, without Ctrl+G. Lucian Cornea Excel Discussion (Misc queries) 3 April 23rd 08 05:07 PM
CTRL+select Excel 2007 ripley Excel Worksheet Functions 5 February 4th 08 05:35 PM
does ctrl f select cells randomly? tc Excel Discussion (Misc queries) 3 August 23rd 07 11:26 PM
ctrl select not working in 07 BorisS Excel Discussion (Misc queries) 3 April 10th 07 03:51 PM
Ctrl Key to Select Cells SJT Excel Discussion (Misc queries) 2 November 29th 06 07:53 PM


All times are GMT +1. The time now is 06:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"