Access Analytic: financial modelling, management reporting and training to help companies make decisions with confidence
<IMG SRC="/images/bw_images1.gif" WIDTH=312 HEIGHT=62 usemap="#bw_images1" BORDER=0>
decisions with confidence
financial modelling, management reporting and Excel auditing services
in-house and open learning training courses
Free Excel products, templates and add-ins to download
knowledge, research and whitepapers
contact us
about us
 

Knowledge

> Knowledge Home
> White papers
> Lunch & Learn Events
> Newsletter
> Success Stories
> Article Topics:
 + Arrays (7)
 + Charts (6)
 + Data Handling (46)
 + Excel 2007 (11)
 + Financial Modelling (16)
 + Formatting (41)
 + Functions (54)
 + Keyboard (13)
 - Mouse (12)
 > Double Click magic
 > Drag letters the same as numbers
 > Dragging Weekdays Only
 > Dragging weekdays only
 > Easy and Quick Formatting
 > Follow link by double clicking
 > Lining up charts and other graphics
 > Paste Linking
 > Pasting Values made easy
 > Print all sheets in one step
 > Shift key and the toolbar
 > Turning off Drag and Drop automatically
 + Printing (17)
 + VBA - Macros (17)

"I like things to happen. And when they don't happen, I like to make them happen."

-- Winston Churchill

  
 

Newsletter: Sample

  

Double Click magic

Mouse Shortcut

By Neale Blackwood, 1 Mar 08

Excel has a number of shortcuts that work with a double click. Here's a few.

Double click the AutoSum toolbar icon to automatically insert a SUM formula (it uses the guessed range). If you select a range first it only takes a single click to insert the SUM function.

Double click a tab name to rename the sheet

Double click the lines between rows and columns to resize the rows/columns to fit the contents

Double clicking within the formula bar can select references and function names to enable you to change the formula

First published: CPA AUSTRALIA Website 2008

Print this article></a> <a href=Print  E-mail this article Email Share:      

Be the First to Comment!

Comment Title:*
Comments:*
Comments may be edited for clarity, relevance or brevity.
Only <b> and <i> HTML tags recognised. Spam etc will not be published.
First Name:*
Last Name:*
E-mail:*  
(not displayed publicly)
Location: (optional)
Options: Remember me
Notify me when other comments on this article are published
Anti-spam:*

MathGuard security question, please solve:

2RD         G2U      
3      O    5 T   YKO
TRM   2X9   2 5      
  4    5    T 4   1CG
NU6         WUJ      
 

Related Articles

Follow link by double clicking - I've used spreadsheets that let you follow a link in a cell by double-clicking on the cell, but I can't find the setting that makes this work. What setting do I have to change?

The setting you need to change is named after another feature, which is why it's hard to find ...
 Privacy Policy | Terms & Conditions
top


Copyright © Access Analytic Solutions Pty Ltd 2002-2010 ACN 091 625 697. All rights reserved.
Access Analytic® and its logo are registered trademarks of Access Analytic Solutions Pty Ltd
Ground Floor, Unit 110/131 Adelaide Tce, East Perth WA 6004, Australia. Phone +61 8 6210 8500

Excel® is a registered trademark of Microsoft Corporation

Javascript must be enabled to use this site as all e-mail addresses have been encrypted
to protect against spam-bots. You can use this free tool too!