MS Office Legal and Corporate - NUMBERING CELLS QUICKLY FOR A DATA ENTRY PROJECT.

MS Office Legal and Corporate - NUMBERING CELLS QUICKLY FOR A DATA ENTRY PROJECT.





Scenario: So, we just got word that we will be receiving a Data Entry type project. We were asked to pre number the cells so that the data entry operator just has to match the number and put in the appropriate information.

1. Open up your Excel file and put in your number "1" in your first cell as shown above. Follow that with Alt H F I S. Up Comes the "Series Dialog Box".



2. Choose "Columns" and the "Stop Value" is the number of cells you wish to number.

 3. Format the column to your liking and you are done!

Training From An Inside Perspective…
888-422-0692 Ext. 1 and 2

Email:
louis@advanceto.com
Students@advanceto.com 

Hey Students:  AdvanceTo offers a very informative and information packed Excel class for beginners!  See link below!



Comments

Post a Comment

Popular posts from this blog

MS Office Legal and Corporate - You have to start somewhere…

Image
MS Office Legal and Corporate - You have to start somewhere… AdvanceTo is one of a few training companies that offer top-tier style training for legal and corporate firms.  We have worked within the industry as IT Help Desk, Lead Operators, Coordinators as well as Corporate Trainers. We train individuals as well as training within legal and corporate firms, full training of Outsource Legal Staff, offering full courses as well as workshops for everyone. We get calls from younger people who have graduated from high school as well as those who have graduated from a two year college and are looking to be trained for Secretarial, Administrative Assistant as well as those who are interested in becoming a Word Processing Operator .   We love to train people from scratch and when finished, they are operating on a high level with a thorough understanding of MS Office along with the understanding of the legal and/or corporate environment.  When one is trained from the beginning in ...
Read more

Sizing Up Your Documents When Setting Them Up From Scratch!

Image
Sizing Up Your Documents When Setting Them Up From Scratch! Scenario : An attorney brings to you a document that is composed of hand written pages, typed up pages that will be inserts, some of the typed up pages have document numbers where you can grab the material without having to type the insert related material.   The attorney has asked you to please create a TOC, TOA and Index of Terms page.  You are also informed that there will be an Exhibit A and B in the back of the documen t.  So knowing this info upfront, how do we go about segmenting the document into its proper sections? Of course we need a cover page.  Most probably it will need a border and will be centered vertically on the screen.  Therefore we need a Section Break “Next Page ” after our cover page. For our TOC, TOA and Index Pages, we need a page break after the TOC, a page break after the TOA and a Section Break “Next Page” after the Index of Terms page.  This second section will ...
Read more

Removing My Continuous Section Breaks Results Is now Destroying My Next Page Section Breaks

Image
Removing My Continuous Section Breaks Is now Destroying My Next Page Section Breaks A lot of you will appreciate this particular write-up.  At one time or another, you have had this happen. I don't believe this is a basic or advanced thing.  This is just one of the many things that can drive you crazy. Scenario :   You run an Index of Terms and realize that you have placed your cursor in the wrong location and now you have an Index of Terms in an unintended location.  You already had saved the document, so you can't undo it.  As you know, a completed Index of Terms is surrounded by two "Continuous Section Breaks".   Note :  Normally, if the Index of Terms is generated in the proper place, the Continuous Breaks cause No Harm.   Now the fun begins.   1.  As you attempt to remove the Continuous Section Breaks, they then eat up the previous " Next Page " type Section Break and befor...
Read more