Login  |  Register  |  Forgot Password 
Below Login Ad

Quick Links

Excel Tips


Owner : Vikas
295 Members
Created : 10-Jun-2011, 06:44:35


Create New Community
Communities I've Joined

Browse by Category

Accounts
Audit
Career
Corporate Law
Direct Tax
Exams
Finance
General
General Knowledge
GST
Income Tax
Income Tax Software
Students
Technologies
testing

Popular Communities

Excel Tips
ACCOUNTS GURU PARVEEN SHARMA SIR
CA World Of RAJPUT'S
VG Sir
TOOLS OF TAX PLANNING
Famous Quotes
TOP CA Firms
Delhi 6 CA's
CA STUDENTS
ICAI

Topic Title

Community : Excel Tips
Topic : Excel 2010

By : CA.VIRAL JANI
  

Excel 2010 have a Great new features. Excel 2010 worksheets have 16,384 columns and 1,048,576 rows against 256 columns and 65,536 rows in earlier versions. Do you want to know more about Excel 2010?



By : CA.VIRAL JANI
  

Data-entry tips

The following list of data-entry tips can help those moving up to Excel from another

spreadsheet:

● To enter data without pressing the arrow keys, enable the After Pressing Enter, Move Selection option on the Advanced tab of the Excel Options dialog box (which you access from the Office➜Excel Options command). You can also choose the direction that you want to go.

● You may find it helpful to select a range of cells before entering data. If you do so, you can use the Tab key or Enter key to move only within the selected cells.

● To enter the same data in all cells within a range, select the range, enter the information into the active cell, and then press Ctrl+Enter.

● To copy the contents of the active cell to all other cells in a selected range, press F2 and then press Ctrl+Enter.

● To fill a range with increments of a single value, press Ctrl while you drag the fill handle at the lower-right corner of the cell.

● To create a custom AutoFill list, select the Edit Custom Lists button on the Popular tab of the Excel Options dialog box.

● To copy a cell without incrementing, drag the fill handle at the lower-right corner of the selection; or, press Ctrl+D to copy down or Ctrl+R to copy to the right.

● To make text easier to read, you can enter line breaks in a cell. To enter a line break, press Alt+Enter. Line breaks cause a cell’s contents to wrap within the cell.

● To enter a fraction, type 0, a space, and then the fraction (using a slash). Excel formats the cell using the Fraction number format.

● To automatically format a cell with the currency format, type your currency symbol before the value.

● To enter a value in percent format, type a percent sign after the value. You can also include your local thousand separator symbol to separate thousands (for example,123,434).

● To insert the current date, press Ctrl+; (semicolon). To enter the current time into a cell,press Ctrl+Shift+;.

● To set up a cell or range so that it accepts entries only of a certain type (or within a certain value range), choose the Data➜Data Tools➜Data Validation command.


 
   

Reply to this Discussion

Sorry . You need to member of the community to post any message .
 
www.casansaar.com
...keeps you updated

Home

  |  News

  |  Articles

  |  Discussion

  |  CA Firms

 |  Members

 |  CA Community

 |  Jobs

 |  Empanelment

 |  Files

 |  Matrimonial

 |  Students zone

 |  Queries

 |  Classified Ads

 |  Events

 |  About us

 |   Top Members

 |  Coaching Centres

  | Testimonials

 | Judiciary

 | Videos

 | Notifications/Circulars

 | Book

 | eDirectory

 | Interview

 | Website

 | Emails

 | Software

 |  Score Board

 |   Press Release  

 |   Blood Bank  

  |   Opinion Poll  

  |   Feedback
 |   Advertise us

 |   Terms & Conditions

 |   Refund Policy

 |   Contact us
 |   Blog

  |   Sitemap

  |   Auditing

  |   Bank

  |   Bank branch audit

  |   Banking

  |   Black Money

  |   CA

  |   CA Announcement

  |   TDS

  |   Students Zone

  |   Custom

  |   VAT

  |   Service Tax

  |   Corporate Law

  |   General

  |   Excise

  |   SEBI

  |   Finance

  |   GST

  |   ICAI

  |   FEMA

  |   ICWAI

  |   ICSI

  |   DGFT

  |   RBI

  |   IFRS

  |   CAG

  |   Budget

  |   Merger & Acquisitions

  |   International Business

  |   Shares & Stock

  |   Excel Tips

  |   International Taxation

  |   ITR

  |   Chartered Accountant

  |   Tax Audit

  |   Companies Act

  |   Money Laundering

  |   MCA

  |   Income Tax Refund

  |   NPA

  |   Income tax software

  |   CST

  |   CA Exams

  |   CA Results

  |   CBDT

  |   Accounting Standards

  |   DIN

  |   Judical Announcement

  |   MDP

  |   PAN

  |   Whats App

  |   Secretarial Standards

  |   NGO

  |   CA Convocation

  |   Finance Bill

  |   ICAI Notification

  |   CARO

  |   COMPANIES SECRETARY

  |   Accounts

Follow Us : Twitter Icon Facebook Icon Orkut Icon Linkedin Icon Linkedin Icon
Developed By: CASANSAAR Copyright © casansaar

Top Accounting Firms,CA COMMUNITY,CA SANSAAR,Chartered Accountant,Ca Networking Firms,Partner Portal,Ca Assignments,CA,Online Communities For Chartered Accountant,Circle For Ca,CS,CMA and FINANCE,Articles By CA / CS / CMA,accounting news articles,Ca Firms In Delhi,CA ANNOUNCEMENT

accounting jobs,article trainees,best website creator,empanelment,income tax slab, ITR, TDS Chart,budget of india 2014-15,gst,auditing,Income tax,students zone,cpt,community matrimony for ca,Classified Ads,Community Matrimony For Ca,Students Zone,Coaching Classes,Company Secretary,Cost Accountant,Judiciary.