Skip to main content

Posts

Showing posts from November, 2014

Some Useful tips on MS Excel - Specially for those who are using Excel

Quick Help To get quick help on any menu item push  Shift+F1  and click the menu item Insert Today's Date To insert Today's date push  Ctrl+;  (semicolon) Insert Current Time To insert the current time push  Ctrl+Shift+:  (Colon) Show the Paste Function (Function Wizard) Push  Ctrl+F3 Show the GoTo dialog Push  F5 Show the Paste Names dialog Push  F3 . This will only work if you have named ranges. Name a Range To name a selected range, click in the " Name box " (far left on the formula bar) and type a one word name. Go To a Named Range To go to a named range select it from the " Name box " (far left of the formula bar). Or push  F5 . Edit a Named Range To  delete  or edit a named range go to  Insert>Name>Define  or Push  Ctrl+F3 . Headings as Range Names Highlight your range including the headings and go to  Insert>Name>Create ...